JR37006: STORED PROCEDURE STAGE USING ORACLE STORED PROCEDURE WITH CURSORS PRODUCE DEADLOCK ERRORS.

APAR status

• Closed as program error.

Error description

• Using Stored Procedure stage to call Oracle stored procedure
  with cursors results in following deadlock error:
  
     Item #: 35
     Event ID: 1231
     Timestamp: 2010-04-30 11:39:46
     Type: Warning
     User Name: PBS|ChulatCh
     Message Id: IIS-XXXX-XXXX-00000
     Message: Stored_Procedure_1,0: Error: Deadlock detected: all
  input links blocked
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of Stored Procedure stage with Oracle as DBVendor
  option and using STP in Transform mode with both input and
  output links.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When an Oracle procedure is used to read rows from the Oracle
  database using cursors
  and in Transform mode with both input and output links, the job
  aborts with the
  following error message:
  
     Item #: 35
     Event ID: 1231
     Timestamp: 2010-04-30 11:39:46
     Type: Warning
     User Name: NLSHYD|dsadm
     Message Id: IIS-XXXX-XXXX-00000
     Message: Stored_Procedure_1,0: Error: Deadlock detected: all
  input links blocked
  
  
  ****************************************************************
  RECOMMENDATION:
  Apply this APAR.
  ****************************************************************
  

Problem conclusion

• There was a problem dealing with the row in the last iteration
  of getting EOD row. This has been corrected so that it won't
  error out and cause a deadlock.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP