Kbase P158011: SQL-92 query fails after upgrade to 10.2A service pack
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/01/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 query fails after upgrade to 10.2A service pack
Executing a SQL query in 10.2A01 or 10.2A02 generates unexpected errors
Behaviour can change depending on the settings that the database is started with
Behaviour can change depending on the Isolation Level used by the ODBC DSN
If the ODBC DSN uses Read Committed then error 7870 is generated
Error: Lock table is full. (7870) (State:S1000, Native Code: FFFCCBA0)
If the ODBC DSN uses Read Uncommitted then "Internal error -1 (buffer too small for generated record)..." (full error message below) is generated
If -L is set to a high value when the database is started then "Internal error -1 (buffer too small for generated record)..." (full error message below) is generated
Error: 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 (ttbl# 6, len/maxlen/reqlen = 17/16/17) for . Save log for Progress technical support. (State:S1000, Native Code: FFFCA503)
FACT(s) (Environment):
Same SQL query executes as expected in 10.2A00
OpenEdge 10.2A
OpenEdge 10.2A01 32-bit Service Pack
OpenEdge 10.2A02 32-bit Service Pack
All Supported Operating Systems
CHANGE:
Applied a Service Pack to OpenEdge 10.2A
CAUSE:
Bug# OE00194325
FIX:
Set the -SQLTempPgSize and -SQLTempBuff parameters when starting the database (values may need to be modified depending on the database queried). The value of the -SQLTempBuff parameter is based on that of -SQLTempPgSize. The formula is as follows:
-SQLTempBuff = (-SQLTempPgSize / 8) * 1000
For example:
-SQLTempPgSize 16
-SQLTempBuff 2000
(16/8) + 1000 = 2000
-SQLTempPgSize has a valid range of 4 - 256.