Kbase P152439: Executing a SQL UPDATE statement against a UTF-8 database fails with error -211023
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/11/2010 |
|
Status: Unverified
SYMPTOM(s):
Executing a SQL UPDATE statement against a UTF-8 database fails with error -211023
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-211023
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Insufficient Memory. Memory allocation failed at 2631 in Z:/vobs_sql/sql/src/progstub/stub_idx.cxx. Contact Progress Technical Support
Problem affects both JDBC and ODBC connections
UPDATE statement includes a column used in a word index
Disabling the word index avoids the problem
FACT(s) (Environment):
Database uses UTF-8 codepage
No problem seen when using a single-byte codepage such as ISO8859-1
Updating statistics of database using following commands has no effect:
UPDATE STATISTICS;
UPDATE TABLE STATISTICS;
UPDATE INDEX STATISTICS;
UPDATE ALL COLUMN STATISTICS;
Running with -SQLTempPgSize 256 and -SQLTempBuff 32000 has no effect
Problem does not occur in OpenEdge 10.1A02 and lower
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2A
Windows
CHANGE:
Upgraded from OpenEdge 10.0B to OpenEdge 10.1C
CAUSE:
Bug# OE00188383
CAUSE:
An overflow condition caused the _SQLSRV2 process to try to allocate more memory than was needed for the operation
FIX:
Upgrade to 10.2A03
Upgrade to 10.2B