SAP Knowledge Base Article - Public

1915010 - Error: 'The database table cannot be found...' when refreshing a report based on a text file using the CR TextFile ODBC driver in Crystal Reports

Symptom

  • Error: The database table cannot be found.
  • When viewing a report connecting to a Text or CSV file, it generates the error.
  • When viewing a report based on a Text file in SAP BI LaunchPad using an ODBC connection, it fails with the error. 
  • When refreshing a report in Crystal Reports, connecting to a Text file or CSV file, using the CR TextFile ODBC driver, it fails with the error: 
      
       "The database table "<Table Name>" cannot be found. Proceed to remove this table from the report?

       Table Cannot be found.png

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. Launch the Microsoft ODBC Data Source Administrator.
  2. Create an ODBC DSN to a text file using the CR TextFile ODBC Driver.
  3. In Crystal Reports, create a new report based on an ODBC connection using the ODBC DSN created to the text file. 
  4. Save the report.
  5. On a different computer, share the report and text file.
  6. Open the same report on the other computer in Crystal Reports, and refresh it.
  7. It fails with the error: "The database table "<Table Name>" cannot be found..."

Cause

  • The error occur because the file: QETXT.INI, is missing.
  • When creating an ODBC DSN to a Text File using the CR TextFile ODBC driver, it generates the file QETXT.INI that contains the definition of each text file.
  • Therefore, beside sharing the text file, and creating the same ODBC DSN to the text file using the CR TextFile ODBC Driver, the file definition QETXT.INI needs to be copied in the same directory as the text file on the other computer.

Resolution

  • Copy the file: QETXT.INI, from the computer where the ODBC connection to the text file was orignally created, to the new computer where the text file is located.
       
    1. On the computer where the ODBC connection to the text file was originally created, navigate to the folder where the text file is located.
    2. Copy the file: QETXT.INI
    3. Share the file to the other computer, and copy it in the folder where the text file is located.

Keywords

CSV , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020