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
- Create a crystal report based on a postgreSQL stored procedure.
- Export the report to BusinessObjects Server.
- Run the report from InfoView.
- Login to postgreSQL server.
- 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 Business View Manager , Problem
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1