|Pivotal Greenplum (GPDB)||4.3.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: [Pivotal][Greenplum JDBC Driver]Usage error for UtilPagedTempBuffer: specified offset extends beyond current end of buffer.
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.