SAP Knowledge Base Article - Public

2046553 - Error: 'An error occurred in the query server while executing a query for execution' when refreshing a report in Crystal Reports off Siebel

Symptom

  • Database Connection Error: 'An error occurred in the query server while executing a query for execution'
  • When refreshing some report in Crystal Reports 2011 based off a Siebel data source, it fails with the a Database Connection Error.
  • When refreshing the same report in Crystal Reports 2008, it refresh successfully.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. In Crystal Reports 2011, create a report off Siebel.
  2. Add at least 2 tables to the report, and link the tables.
  3. Add on the report at least one database fields from each table.
  4. When refreshing the report, it will generate the error:
     
    "Database Connection Error: 'An error occurred in the query server while executing a query for execution"
          
    Siebel Error.png

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01702550

Resolution

  • This issue has been resolved in the following product updates:
            
    • Crystal Reports 2011:
      • Support Pack 10
            
    • Crystal Reports 2013:
      • Support Pack 04

Keywords

CR, Siebel, error , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013