Article

SQL: Internal error -20033 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmRecordCreate executing a query from a JAVA program.

Information

 
Article Number000014130
EnvironmentProduct: Progress
Version: 9.1D, 9.1E
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: SQL-92
Question/Problem Description
Executing an SQL Query from a Java client results in error 2033.
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.
Steps to Reproduce
Clarifying Information

 
Error MessageSQL: 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 .
Defect/Enhancement Number
Cause
Java program logic or syntax errors submitted an invalid query to the SQL server.

error -20033 is DSM_S_ERROR_EXIT : a dsm operation has encountered a fatal error. The failure is in the low-level storage manager. When trying to create the record, the storage manager could not find the expected table.

 
Resolution
Ensure that the Java program logic and syntax are correct by confirming 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.
Workaround
Notes
Progress Articles:

 000015879, SELECT DISTINCT fails with Internal error -20033  
Attachment 
Last Modified Date12/18/2018 9:19 AM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025