Kbase P122219: SQL: Errors (10002) and (8934) executing UPDATE STATISTICS against a large database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/03/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Errors (10002) and (8934) executing UPDATE STATISTICS against a large database
Under OpenEdge 10.1A02 the following error is generated:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-10002
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Server Error -10002. No message from server.
Under 10.1A02 the following error is generated:
=== SQL Exception 1 ===
SQLState=08S01
ErrorCode=0
[DataDirect][OpenEdge JDBC Driver]Connection reset
Executing the statement:
UPDATE ALL COLUMN STATISTICS;
Under 10.1A02, the PROGRESS stack trace contains the following lines:
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 005397E6 01:001387E6 C:\Progress\OpenEdge101A\bin\_sqlsrv2.exe
Under 10.1B the following error is generated:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-10002
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Tuple not found for the specified TID.
FACT(s) (Environment):
Windows
OpenEdge 10.1A
OpenEdge 10.1A02 Service Pack
OpenEdge 10.1B
CAUSE:
Bug# OE00146369
CAUSE:
A bug allowed the SQL-WIDTH to be exceeded in the first row when generating column statistics thus causeing the above errors.
FIX:
Upgrade to OpenEdge 10.1C or later. If the upgrade to OpenEdge 10.1C or later is not feasible, then a workaround is to run the DBTOOL option 2 against the database to scan and fix the offending SQL-WIDTH.