1664779 - Crystal Reports execute stored procedure SQL twice on postgreSQL database

SAP Knowledge Base Article - Public

1664779 - Crystal Reports execute stored procedure SQL twice on postgreSQL database

Symptom

Stored procedure are executed twice on postgreSQL database server when running crystal reports from InfoView.

Environment

  • Crystal Reports 2008 
  • Generic postgreSQL unixODBC driver.
  • Unix Server. 

Reproducing the Issue

  1. Create a crystal report based on a postgreSQL stored procedure.
  2. Export the report to BusinessObjects Server.
  3. Run the report from InfoView.
  4. Login to postgreSQL server.
  5. Log the used stored procedure execution.

Cause

Generic postgreSQL unixODBC driver is not supported with crystal reports

Resolution

Use the specified driver in the supported platform.

Keywords

postgreSQL, unixODBC, stored procedure, double execution. , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1