Kbase P162216: SQL: ErrorCode=-211022 executing an SQL query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/19/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL: ErrorCode=-211022 executing an SQL query.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-211022
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Encountered internal error in SQL ENGINE at 869 in /vobs_sql/sql/src/sts/sts_srtt.cxx. Contact Progress Technical Support
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B03
CAUSE:
Not having run UPDATE STATISTICS means not having accurate statistics to build an optimum query plan. Without accurate statistics, SQL may build a query plan that results in large temp tables that exceed the memory and/or storage resources available to the client and cause the query failure.
FIX:
Run UPDATE STATISTICS regularly against the database.