Installing Elliott 8.5 or 8.6 with Error on SYCNTRY.BTR File

Installing Elliott 8.5 or 8.6 with Error on SYCNTRY.BTR File

Release Date: 3/28/2023
Version: 8.5 & Up

When you install Elliott 8.5 or 8.6 on the server, you may receive the following message:
Error 1306: Another application has exclusive access to
the file ......\SYCNTRY.BTR. Please shut
down all other applications, then click Retry.
See sample screen below:


This may happen if you have an older version of the SYCNTRY.BTR file and other users currently have this file opened. If you run into this message, you may need to ask your users to exit Elliott 8.5 or 8.6. You can find out who opened this file by bringing up the PSQL Monitor utility. See sample screen below:



If this happens during the day, you can retry the installation in the evening when all users are exited out of Elliott.

How to Put Conflict File Into Backup (Continuous Operation) Mode

If you still run into this issue in the evening due to user forget to exit, then you can put SYCNTRY.BTR into continuous operation mode (backup mode) by using the following command in a command prompt:
    BUTIL -STARTBU D:\ACCT\ELLIOTT8\SYCNTRY.BTR
"STARTBU" means "Start Back up".  Note that you must use the local path, not the mapped drive path.  This command, if executed successfully, will put SYCNTRY.BTR into backup mode (continuous operation mode). The PSQL engine will close SYCNTRY.BTR file and create another "delta" file SYCNTRY.^^^. See sample screen below:



Since SYCNTRY.BTR is no longer opened by PSQL engine, you can proceed with the installation now.  Once the installation is done, you need to end the backup mode by using the following command:
    BUTIL -ENDBU D:\ACCT\ELLIOTT8\SYCNTRY.BTR
Upon successful execution of this command, the content in SYCNTRY.^^^ will be roll over to SYCNTRY.BTR and SYCNTRY.^^^ will be deleted.

EMK


    • Related Articles

    • Instructions to Install Elliott V8 on Top of Elliott V7

      Elliott V8 and Elliott V7.5 are compatible at the database level. When you migrate from Elliott V7.5 to Elliott V8, we recommend that you install Elliott 8 on top of Elliott V7.5. This way, you can run Elliott V8 and V7.5 side by side until you feel ...

    • How to Install 2023 Zip Codes, Cities, and County Code Updates

      Release Date: 09/07/2023 Version: 8.5 & Higher In Elliott 8.5d.907 and 8.63.907 and after, the Zip Codes, Cities, and County Code tables are updated to Post Office's 2023 August data. The following are Elliott's affected tables: SYZIPCDS.BTR - Zip ...

    • Btrieve Error 161 on Password File When Starting Up Elliott

      Q - We are receiving an Error 161: The maximum number of user count licenses has been reached. This happens to all users when starting up Elliott. We have rebooted all office computers and the PSQL server. There is no one is in Elliott. Yet we are ...

    • Is It OK to Install Elliott Update If I Skipped the Previous Version?

      Release Date: 12/19/2024 Version: 7.x & Update Q - I received the email about the update availability for V8.64.c18. I did not install the previous update V8.64.a23 version. Is it OK for me to skip that version and install the latest V8.64.c18? A - ...

    • Error Invoking Macro - Cannot Install Hook

      Q - On my old terminal server, when I go to a customer file and bring up a customer, I can run an external macro by sending certain customer information to an existing document in Word Pad. This function is no longer working after I switched to a new ...