SAP Knowledge Base Article - Public

2588011 - When connecting to a Stored Procedure that use Temp Table, Crystal Reports for Enterprise stop responding

Symptom

  • Crystal Reports for Enterprise crash, or stop responding.
  • When attempting to create a report off a stored procedure that uses temp table in Crystal Reports for Enterprise, it generates an error, then crash.
  • Can successfully report off Stored Procedure that does not use temp table in Crystal Reports for Enterprise.

Environment

  • SAP Crystal Reports for Enterprise 4.0
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2

Reproducing the Issue

  1. In a database, create a stored procedure that uses temp table.
  2. In Crystal Reports for Enterprise, create a new report, and when selecting or refreshing a report off a stored procedure with temp table, it generates an error, and then crash.

Cause

  • This issue occurs when the stored procedure uses temp table, because it is not supported in Crystal Reports for Enterprise.
               
  • Crystal Reports for Enterprise supports SQL Query Language in a Stored Procedure that retreive data from a data source like:
    • SELECT
    • FROM
    • WHERE
    • GROUP BY
    • ORDER BY
    • UNION
              
  • But does not support SQL Query Language for data manipulation like:
    • CREATE TABLE
    • ALTER TABLE
    • DROP TABLE
    • INSERT
    • UPDATE
    • DELETE

Resolution

  • To be able to report successfully from the stored procedure, remove all the temp table from the stored procedure.

Keywords

CRFE, CR4E, CR for Enterprise, Stored Proc , KBA , BI-RA-CRE , Crystal Reports for Enterprise , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016