SAP Knowledge Base Article - Public

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


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


  • 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.


Generic postgreSQL unixODBC driver is not supported with crystal reports


Use the specified driver in the supported platform.


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


Crystal Reports 2008 V0 ; Crystal Reports 2008 V1