How to Resolve Files Open Conflict During Elliott Installation

How to Resolve Files Open Conflict During Elliott Installation

Release Date: 03/29/2024
Version: 8.6 & Up

Q - During installation of Elliott 8.6, I run into the following error message:
Error 1306: Another application has excusive access to
the file C:\Company\Elliott7\SYRDTYPB.BTR. Please
shut down all other applications, then click Retry.
See sample screen below:

Retry won't work so I have to choose the "Cancel" option to end the installation.

I understand this is due to some of the Report Desk or PowerSearch files experiencing an open conflict in the Elliott root directory.  But all Elliott users are logged out.  This file is still open by the PSQL engine.  See PSQL Monitor sample screen below:


I know I can restart the PSQL engine to close this file.  However, we have website activities on 24x7 basis.  Is there a way for me not to restart the PSQL engine and complete the installation?

A - You can use BUTIL -STARTBU and -ENDBU to allow the installation to override this file.  Here are the details:
1. On the PSQL server, bring up a command prompt and go to the local path where Elliott is installed. In this case, it is C:\COMPANY\ELLIOTT7.
2. Bring up a command prompt. In this example, use 
    BUTIL -STARTBU C:\COMPANY\ELLIOTT7\SYRDTYPB.BTR.

3. The above procedure puts this file into backup mode which will allow the installation utility to override. 
4. Proceed with Elliott Installation again. 
5. If you run into a similar error with different files, repeat steps 2 - 4.
6. Once Elliott is successfully installed, it may prompts you to restart the server. Ignore it by answering "No." See sample screen below:
 
7. Go back to your command prompt and end the file backup mode by using the following command:
     BUTIL -ENDBU C:\COMPANY\ELLIOTT7\SYRDTYPB.BTR
8. Repeat step 7 for all files where you did the BUTIL -STARTBU.


EMK


    • Related Articles

    • Solving Elliott 8.6 Installation Conflict with Root Directory BTR Files

      Release Date: 05/09/2024 Version: 8.6 Elliott 8.6 supports ReportDesk and PowerSearch features. Both features require installing BTR files at the Elliott root directory level. Some of these BTR files may change from time to time, which will be ...

    • A Comparison of Elliott 7.5, 8.2, 8.5, 8.6 and 8.6 V2 DDF Files

      Release Date: 11/15/2022 Last Updated: 06/25/2024 Version: 7.5 & Up DDF Files are used to define the PSQL database schema. Generally speaking, we distribute four different types of DDF files for different versions of Elliott releases: 7.5 DDF: These ...

    • Login SUPERVISOR to Update DDF Files After Elliott 8.6 Installation

      Release Date: 8/17/2022 Version: Elliott V8.6 and Higher Background Most of Elliott Business Software uses the PSQL transactional database engine (Btrieve) to perform its work. However, some new features of Elliott V8.6 use the PSQL relational ...

    • AP22S1 Accounts Payable Purge AP Open Item File

      Purge A/P Open Item File Application Overview Even when an invoice has been fully paid, the information on the A/P Open Item File pertaining to it remains on file until purged. If you never purged the A/P Open Item File, the disk would eventually get ...

    • An Example of DDF Files in DATA Folder that Can Confuse PSQL

      Release Date: 04/11/2024 Version: All Q - I tried to access Elliott Item master column ITEM_CASE_SIZE in Report Desk. In one of the Report Desk reports, I wanted to drag ITEM_CASE_SIZE to the report body. But I can't find that column under the ...