Stored Procedure abend SQL state [38503]; error code [-430]

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • avinash556
    New Member
    • Jun 2013
    • 1

    Stored Procedure abend SQL state [38503]; error code [-430]

    The Connection Manager received a fatal connection error from the Resource Adapter for resource jdbc/aims. The exception is:
    Code:
    com.ibm.db2.jcc.c.SqlException: PROCEDURE PROD.APS707 
    (SPECIFIC NAME PROD.APS707) HAS ABNORMALLY 
    TERMINATED:com.ibm.db2.jcc.c.SqlException: UNSUCCESSFUL 
    EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT 
    PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS
    
    uncategorized SQLException for SQL [{call PROD.APS707(?, 
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; 
    SQL state [38503]; error code [-430]; PROCEDURE 
    PROD.APS707 (SPECIFIC NAME PROD.APS707) HAS ABNORMALLY 
    TERMINATED; nested exception is 
    com.ibm.websphere.ce.cm.StaleConnectionException: 
    PROCEDURE PROD.APS707 (SPECIFIC NAME PROD.APS707) HAS 
    ABNORMALLY TERMINATED"
    This is the info we received. Can anyone please help how to find out the root cause for this.

    Thanks a lot.

    Avinash
    Last edited by acoder; Jun 26 '13, 12:11 PM.
Working...