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
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 ...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 ...Convert Elliott Internal Date to Proper Date Format in Third-Party Tools (Crystal Reports)
Release Date: 07/08/2024 Version: 8.5 & Up ELIDATE2SQL() User-Defined Function Elliott's internal database stores a date field as an 8-digit numeric in a YYYYMMdd format where YYYY is the 4-digit year, MM is the number of the month, and dd is for the ...Crystal Report Conversion for V8.5
A major improvement in Version 8.5 is the support of alphanumeric document numbers. This significant change adds flexibility and addresses the pressing issue that many Elliott users faced, which is running out of order and invoice numbers. The ...