Kbase P130492: SQL: Internal error 2 running query with WIN32 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/18/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Internal error 2 executing a complex query against a WIN32 database
Error: Internal error 2 (A buffer other than the NLS system handle memory was not large enough) in SQL from subsystem NLS SERVICES function nls_conversion_t::convert_buffer called from sql_qt_project_t::xec_describe on . for . Save log for Progress technical (State:S1000, Native Code: FFFCA503)
Using a windows XP database server and the Synametrics WinSQL ODBC client, the query fails with above error.
Using a UNIX database and a Windows WinSQL ODBC client, the same query runs successfully.
FACT(s) (Environment):
Windows
OpenEdge 10.1B
OpenEdge 10.1C
CAUSE:
Bug# OE00167617
CAUSE:
This bug is Windows Operating System specific. For very long select list expressions like the one in the query in this bug, computing the result set column name for the select statement overflows the sqlda buffer. Sometimes, on Windows Operating System, it will fail to null-terminate the column name.
FIX:
Upgrade to OpenEdge 10.1C01 or later