Kbase P142459: SQL: Errors (7899) and (10002) running UPDATE STATISTICS against a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/18/2011 |
|
Status: Verified
SYMPTOM(s):
SQL: Error (7899) running UPDATE STATISTICS against a database
Inconsistent metadata - contact Progress technical support. (7899)
SQLState=HY000
ErrorCode=-219903
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Inconsistent metadata - contact Progress technical support. (7899)
Tuple not found for the specified TID
SQLState=HY000
ErrorCode=-10002
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Tuple not found for the specified TID.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The 'Tuple not found for the specified TID' error was caused by one or more fields having sql field widths that are too wide. The 'Inconsistent metadata - contact Progress technical support. (7899)' error was caused by one or more tables having no fields or indexes defined.
FIX:
Run dbTool against the offending table(s) to eliminate the 'Tuple not found for the specified TID' error. Remove the table(s) with no fields or indexes defined or define fields and indexes for these tables to eliminate the 'Inconsistent metadata - contact Progress technical support. (7899)' error.