Kbase P123069: SQL: Errors (8184) & 'Tuple not found for the specified TID' generated executing UPDATE ALL COLUMN S
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/12/2010 |
|
Status: Verified
SYMPTOM(s):
SQL: Errors (8184) & 'Tuple not found for the specified TID' generated executing UPDATE ALL COLUMN STATISTICS
Update count = 0.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-10002
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Tuple not found for the specified TID.
UPDATEING ALL COLUMN STATISTICS FOR sub-notes
Update count = 0.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20152
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Character string is too long (8184)
The 'Tuple not found for the specified TID' error was generated executing UPDATE ALL COLUMN STATISTICS for one table.
The Character string is too long (8184)' error was generated executing UPDATE ALL COLUMN STATISTICS for another table.
Both tables have a fields with large amounts of data.
The same errors are generated using ODBC and JDBC clients to execute the UPDATE ALL COLUMN STATISTICS statement.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
CAUSE:
Bug# OE00148715
CAUSE:
The data extracted for sampling of nvarchar column values is too large for the _value column of the _sysnvarcharstat table.
FIX:
Upgrade to OpenEdge 10.1C or later