Kbase P115931: _SQLSRV2 process crashes when a non-DBA user tries to query a UTF-8 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2009 |
|
Status: Unverified
SYMPTOM(s):
_SQLSRV2 process crashes when a non-DBA user tries to query a UTF-8 database
Using the Progress SQL engine to access the database
SQL-92 server process (_SQLSRV2) crashes when accessing the database schema
Stack trace from _SQLSRV2.EXE reads:
nlsIsSortNeeded
Third-party applications (MS Excel, Crystal Reports) hang when _SQLSRV2 crashes
ODBC trace log ends on the function SQLTablesW:
excel 450-65c ENTER SQLTablesW
HSTMT 02331C58
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
FACT(s) (Environment):
User does not have DBA rights
User has only SELECT permissions
Users with DBA permissions can access the database normally
Database uses codepage UTF-8
Database uses BASIC collation
No problems seen with an ISO8859-1 database
10.1A01
OpenEdge 10.1A
All Supported Operating Systems
CAUSE:
Bug# OE00127634
FIX:
Option #1
Upgrade to OpenEdge 10.1A02
Upgrade to OpenEdge 10.1B
Option #2
When using an ODBC / JDBC reporting tool, only READ-ONLY access to the database is required. Grant the DBA privilege to the required users and set the Default Isolation Level of the connection to Read Uncommitted.
Option #3
Use a non-UTF-8 database.