1216704 - Error: "Unknown Query Engine Error" in Crystal Reports 9 with Oracle

SAP Knowledge Base Article - Public

1216704 - Error: "Unknown Query Engine Error" in Crystal Reports 9 with Oracle

Symptom

  • Crystal Reports 9 Oracle Native driver
  • Selecting remote link synonyms that refer to other servers.
  • Error: "Unknown Query Engine Error."
With the Crystal Oracle ODBC Driver 4.10, the remote link synonym does not display.

Resolution

This is a known issue with Crystal Enterprise (CE) 9 and Crystal Reports (CR) 9 and has been tracked. The Problem ID is ADAPT00069084. Hot Fix updates addressing this issue are available as indicated below. With the updates, new registry keys have been added to disable auto-commit, and thus enable manual-commit mode:

CAUTION

Using the Registry Editor can cause serious problems that may require reinstalling the operating system. Crystal Decisions is not responsible for any problems resulting from using the Windows Registry Editor; use it at your own risk. Crystal Decisions recommends that you back up the registry before you edit it.

HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\9.0\Crystal Reports\Database\ODBC\AutoCommit
HKEY_CURRENT_USER\SOFTWARE\Crystal Decisions\9.0\Crystal Reports\Database\ODBC\AutoCommit
To switch from auto-commit to manual-commit mode, change the string "AutoCommit" to have a value of "0".

CAUTION

Unless indicated otherwise, Hot Fix updates from our FTP site have only been tested with English versions of products.

Crystal Enterprise 9
For Crystal Enterprise 9 deployments, the fix for this issue is included in the CE 9 Database and Export Weekly Hot Fix (WHF), that is available in English only at the downloads page.
This issue is corrected in the following component (and later) versions:
  • Crdb_odbc.dll, version 9.2.1.621, dated 10/23/2003
  • Crdb_oracle.dll, version 9.2.1.124, dated 02/09/2003
Crystal Reports 9
For Crystal Reports 9, the fix for this issue is included in the CR 9 Database and Export Weekly Hot Fix (WHF), that is available in English only at the downloads page.
This issue is corrected in the following component (and later) versions:
  • Crdb_odbc.dll, version 9.2.1.621, dated 10/23/2003

CAUTION

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, please refer to our OEM Product Warning.

See Also

For more information on the issues resolved by this Hot Fix, view the ReadMe or PDF file included in the TAR or ZIP file.
For instructions on applying Hot Fixes and Service Packs, please refer to the Hot Fix and Service Pack FAQ.

Keywords

CE WHF 69084 ORACLE NATIVE ODBC DRIVER QUERY ENGINE ERROR Crystal Reports Query Engine Error Oracle CE90DBEX WHF CR90DBEX , c2014384 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 9.0