Pivotal Knowledge Base


Cognos Query using JDBC does not Return a Result or Error


  • Pivotal Greenplum Database (GPDB) 4.3.x
  • Operating System- Red Hat Enterprise Linux 6.x


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.


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.


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.


Powered by Zendesk