Installing Elliott 8.5 or 8.6 with Error on SYCNTRY.BTR File
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