SAP Knowledge Base Article - Preview

3366832 - Jconn4.jar app cannot catch error related to resource shortage -- SAP IQ

Symptom

  • From Jconn42.jar app, Customer are trying to catch errors related to resource shortage, such as “You have run out space in IQ_SYSTEM_TEMP” or “Insufficient buffers for sort” fired by a SQL in a sproc. But the error is still not displayed in Java app. 
  • Test & Findings 
    • the initial the error returned by the server cannot be caught in JDBC
    • the error handling code is never executed. It should print: “*** Procedure failed no space” but it does not.
    • I can see with the request level log that as soon as the error occurs, it exits from the sproc regardless the options and regardless the sproc is with or without ON EXCEPTION RESUME
    • - If, in the sproc, I replace the SQL with some SQL on non-existing table: select * form toto , then the error is displayed in the JDBC app.

         In addition, when I call the sproc with:

    • Sajdbc4.jar, the error can be caught and the error text “You have run out space in IQ_SYSTEM_TEMP” is printed.
    • Jconn42.jar, the error is not caught and nothing is printed.

         With Jconn4.jar, in my java program, if I execute the SQL directly instead of the sproc, then the error is caught.


Read more...

Environment

SAP IQ 16.1 SP04.XX

Keywords

CR 828261,  Jconn4.jar , SQLException , , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.