Kbase P124985: SQL: A ''server crash is likely'' error is generated when an SQL Query invoking the SUM() and DECODE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: A ''server crash is likely'' error is generated when an SQL Query invoking the SUM() and DECODE() functions is executed as a JDBC PreparedStatement object.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=0
[DataDirect][OpenEdge JDBC Driver]A server crash is likely.
Error is generated when an SQL Query invoking the SUM() and DECODE() functions is executed as a JDBC PreparedStatement object.
JDBC Spy log includes:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]A server crash is likely. ErrorCode=0 SQLState=HY000
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]A server crash is likely.
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.headerSwapOut(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientCursorRequest.processReplyFreeCursor(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientCursorRequest.freeCursor(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientCursorRequest.freeCursor(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.closeStatement(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.close(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.close(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.close(Unknown Source)
at com.ddtek.jdbcspy.SpyStatement.close(Unknown Source)
at W706270084.runTest1(W706270084.java:97)
at W706270084.runTests(W706270084.java:59)
at W706270084.main(W706270084.java:108)
FACT(s) (Environment):
SuSe Linux 8.0
OpenEdge 10.1B01 32-bit Service Pack
Progress OpenEdge 10.1B driver
CAUSE:
Bug# OE00153907
CAUSE:
The issue is with scalar function "decode" which may, under certain circumstances, fail to return a type and length for the result.
FIX:
Upgrade to OpenEdge 10.1B03