Anti-Virus Caused Failure on Crystal Reports ODBC Access
Release Date: 05/22/18
Q - I have a Crystal Report that has ran against our production Elliott data without issue. I am trying to run this same report against the test Elliott data. I am getting "failed to retrieve data" messages when trying to run the report. See sample screens below. The Crystal Reports server has been upgraded in the test environment and I need to verify this report will run in the new version of Crystal Reports.
Message 1: Failed to retrieve data from the database.
Message 2: Database Connector Error: 'HY000:[PSQL][ODBC Client Interface][LNA][PSQL][SQL Engine][Data Record Manager][The Microkernel cannot find the specified file (Btrieve Error 12)'
Message 3: Failed to retrieve data from the database. Details: 'HY000:[PSQL][ODBC Client Interface][LNA][PSQL][SQL Engine]Unable to open table: APTRXFIL.
A - The key clue in these messages is (Btrieve Error 12), which means the Microkernel cannot find the specified file. See the following KB articles for the details of error code 012 and a list of other Microkernel error messages:
We first tried to access the table APTRXFIL from PSQL Control Center and it failed with the same message. We then confirmed that the setup of ODBC was pointing to the right path and that the particular table APTRXFIL.BTR does exist. Our suspicion then points to the Anti-Virus. Anti-Virus, based on configuration or update, may deny access to certain directories. This is especially true when IT has no idea what operation requirement is needed to run Elliott and its database.
The problem was then resolved when the IT Security team added the Test environment Elliott8\Data folder to the exclusion list, which corrected the issue. The user can now open the tables from the Pervasive tool and run the Crystal Report.
EMK
Related Articles
The Selected Menu Item Could Not Be Launched - Caused by Anti-Virus
Release Date: 08/25/2020 Q - We are receiving the launch exception error after we have log into Elliott and when we attempt to open a task: Elliott 8.5 Control Center Menu Launch Exception The selected menu item could not be launched. See ...Anti-Virus Causes PostOffice Emailing Problem
Release Date: 12/29/2017 Q - I have a user who received the following error message when trying to use PostOffice to send order acknowledgement emails: ERROR: Error in processing. The server response was: See http://pobox.com/~djb/docs/smtplf.html. ...Anti-Virus Causes Report Viewer Unhandled Error
Release Date: 01/23/2020 Version: 8.0 & Up A user running Elliott 8.2 received the following error when printing a report to the screen. They rebooted the server a few times, but they were still receiving the following errors when printing reports to ...What Do I Do When My Anti-virus Software Reports Elliott EXE File as a Virus?
Q - I am using Avast Anti-Virus software, and it reports Elliott EL800P.EXE in the M:\Elliott7\Bin folder as a virus. What should I do? A - If this is the original EL800P.EXE from us, it should not be a virus. But if it's changed after installed, ...Bitdefender Anti-Virus Software Causes Elliott to Fail at Startup
Release Date: 04/12/2022 Version: 7.5 & Up On Monday, 04/11/2022, we received three separate support incidents that Elliott 8.5 failed to startup. One user's entire in-house workstations failed to start. This user is running on an older version of ...