Skip to content
logo Knowledgebase

Error: "Failed to retrieve data from the database"

Created on  | Last modified on 

Description

Cause

Incompatible Crystal Runtime Components installed.

Resolution

CAUTION: This solution requires advanced knowledge of your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions. 
CAUTION: This solution requires advanced knowledge of your computer's operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions. 
CAUTION: Sage Customer Support does not provide assistance for issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.e 

Remove and reinstall the prerequisite "SAP Crystal Reports runtime engine for .NET Framework" for the version of Sage 300 CRE Accounting installed on the affected machine.

  • Sage 300 CRE Accounting version 15.1 installs v13.0.8.1216 of the SAP Crystal Runtime
  • Sage 300 CRE Accounting version 16.1 installs v13.0.8.1216 of the SAP Crystal Runtime
  • Sage 300 CRE Accounting version 17.1 installs v13.0.19.2312 of the SAP Crystal Runtime
  • Sage 300 CRE Accounting version 18.1 installs v13.0.19 of the SAP Crystal Runtime

The SAP Crystal Runtime installer for v15.1 and v16.1 can be found at the following location on the Sage 300 CRE server:

  • C:\ProgramData\Sage\TIMBERLINE OFFICE\9.5\Accounting\WinInst\Prerequisites\Crystal Runtime Engine (x86)\CRRuntime_32bit_13_0_8.msi

The SAP Crystal Runtime installer for v17.1 and higher can be found at the following location on the Sage 300 CRE server:

  • C:\ProgramData\Sage\TIMBERLINE OFFICE\9.5\Accounting\WinInst\Prerequisites\Crystal Runtime Engine (x86)\CRRuntime_32bit_13_0_19.msi

Once this problem has been resolved and you can print Crystal-based reports in Sage 300 CRE, if you are unable to run standard Sage Fixed Assets reports refer to article 89033 "Error: Load report failed Running Standard reports".

DocLink: Error: "Failed to retrieve data from the Database" (Troubleshooting)
DocLink: Crystal Runtime Version Conflict
DocLink: What are the Crystal Runtime compatible versions of the recent releases of Sage 300 CRE, Sage Estimating, and Sage Fixed Assets?

Chat with support