Pivotal Knowledge Base

Follow

Cognos Query using JDBC does not return a Result nor Error

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS RHEL 6.x

Symptom

When using IBM Cognos and an ODBC or JDBC Driver, if an error is returned from the driver, and not the database, the exception may not be caught and the process will run forever until terminated.

Error Message:

Error: [Pivotal][Greenplum JDBC Driver]Usage error for UtilPagedTempBuffer: specified offset extends beyond current end of buffer.
SQLState: HY000
ErrorCode: 0

The error was captured utilizing a generic JDBC Client application (squirrel-sql.sourceforge.net) to test the same function. No error was generated at the GPDB Server as the database successfully executed the function.

Cause 

This particular error was due to version 5.1.1 of the Greenplum Driver provided via Data Direct.
This error was not found in the latest version of the driver available.

Resolution

Pivotal Support strongly recommends that our clients always use the latest version of the driver available from our software distribution site https://network.pivotal.io/products/pivotal-gpdb, unless advised otherwise.
  

Comments

Powered by Zendesk