Symptoms

You use Report Commander to process a report that uses the PostgreSQL ODBC driver, with the driver configured to require an SSL connection. Report Commander successfully exports, prints, or e-mails the report, but then terminates with an application failure message similar to the following:

Report Commander has encountered a problem and needs to close. We are sorry for the inconvenience.

Note: This article applies only if you are using the driver configuration described. If you are not, the application failure is caused by a different issue and this article does not apply.

Cause

This problem appears to be caused by an issue in the PostgreSQL driver.

Resolution

This problem is the result of a defect in the PostgreSQL software. To address this issue you can:

  • Look for assistance in the PostgreSQL community.
  • Switch to a different PostgreSQL driver.
  • Use the PostgreSQL ODBC driver without SSL support.
  • Ignore the application failure, since it occurs only after report processing has been completed.

Additional Information

Testing has shown that this problem occurs when using the Crystal Reports runtime components used by adTempus, but not when using the same report and driver from the Crystal Reports designer. However, reviews of PostgreSQL logs and of the technology involved indicate that the problem is in the database driver, and not in the Report Commander or Crystal Reports software.

The PostgreSQL driver log file from a failure scenario shows the following as the last line before the failure:

[SQLDisconnect for 068D3E38][5744-7.662]PGAPI_Disconnect: entering...

Whereas a successful operation (through Crystal Reports) shows the following: 

][SQLDisconnect for 074E3DD0][4324-21.750]PGAPI_Disconnect: entering...
]PGAPI_Disconnect: about to CC_cleanup
]in CC_Cleanup, self=074E3DD0
]after CC_abort
]SOCK_Destructor
]after SOCK destructor
]exit CC_Cleanup
]PGAPI_Disconnect: done CC_cleanup
]PGAPI_Disconnect: returning...
][[SQLFreeHandle]][4324-21.750]PGAPI_FreeConnect: entering...
]**** in PGAPI_FreeConnect: hdbc=074E3DD0
]enter CC_Destructor, self=074E3DD0
]in CC_Cleanup, self=074E3DD0
]after SOCK destructor
]exit CC_Cleanup
]after CC_Cleanup
]after free statement holders
]exit CC_Destructor
]PGAPI_FreeConnect: returning...
][[SQLFreeHandle]][4324-21.750]**** in PGAPI_FreeEnv: env = 074E2940 ** 
]in EN_Destructor, self=074E2940
]clearing conns count=128
]exit EN_Destructor: rv = 1
]   ok
]DETACHING PROCESS
]LIBPQ.dll unload success=1