Kbase P131392: SQL statement fails with error "buffer too small for generated record" in OpenEdge 10
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/02/2009 |
|
Status: Verified
SYMPTOM(s):
Running a SQL SELECT DISTINCT statement
SQL statement fails under heavy load at same point
Driver side reports internal error -1 (buffer too small for generated record)
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -1 (buffer too small for generated record) in SQL from subsystem RECORD SERVICES function recPutLONG called from sts_srtt_t:::add_row on for . Save log for Progress technical support.
at
com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.fetchProcessReply(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.fetch(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplResultSet.fetchAtPosition(Unknown Source)
at com.ddtek.jdbc.base.BaseImplResultSet.next(Unknown Source)
at com.ddtek.jdbc.base.BaseResultSet.next(Unknown Source)
at com.result.tools.sql.Sql.outputData(Sql.java(Compiled Code))
at com.result.tools.sql.Sql.select(Sql.java(Inlined Compiled Code))
at com.result.tools.sql.Sql.executeSql(Sql.java(Inlined Compiled Code))
at com.result.tools.sql.Sql.execute(Sql.java(Compiled Code))
at com.result.tools.sql.Sql.run(Sql.java:83)
at com.result.tools.fw.ToolMain.runTool(ToolMain.java:126)
at com.result.tools.sql.Sql.main(Sql.java:340)
SQL server logs report error -219901
Problem does not occur when executing the SQL query on its own from a separate SQL Explorer Tool instance
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
CAUSE:
Bug# OE00165633
FIX:
Upgrade to OpenEdge 10.1C01 or later