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 ...

    • Configuring Elliott V8.0

      Configuring Elliott V8.0 After installing Elliott V8.0, you need to make some configuration changes. If this is the first time you have started Elliott, the system will detect that the EL800.CFG file does not exist in your startup <root>\Bin ...

    • Avalara - Log Files

      Release Date: 4/28/23 Version: 8.6 & Above Log files can be very important when investigating why taxes may not be calculated as expected. In particular, the AvalaraAPICalls.xml file is important when you speak with Avalara reps for support. This ...

    • Btrieve Error 025 on COP Open Order by Salesman Report

      Q - When I run COP -> Reports -> Open Order by Salesman Report, I receive Btrieve Error 025. What causes this error? See sample screen below: A - Typically this is caused by a work file usage conflict. This means another user is in the middle of ...

    • 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 ...