Kbase P161470: SQL: Internal error -20033 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmRecordCreat
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/25/2010 |
|
Status: Verified
SYMPTOM(s):
SQL: Internal error -20033 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmRecordCreate executing a query from a JAVA program.
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -20033 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmRecordCreate called from sts_srtt_t:::add_row on .SRTT_Temp_-24977 for . Save log for Progress technical support.
FACT(s) (Environment):
The JAVA program references many user defined methods involved in the construction of the query.
The query runs error free when executed from a simplified JAVA program with no user defined method references.
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Java program logic or syntax errors submitted an invalid query to the SQL server.
FIX:
Ensure that the Java program logic and syntax are correct. Confirm the query generated by the Java program is a valid SQL query. One way to validate the query is to display the query text from the program and visually inspect it. A better way to validate the correctness of the query generated by the program to execute it from an ODBC or a JDBC client like WinSQL ODBC client or the DbVisualizer JDBC client before integrating the query into Java program.