JR60001: DELTA EXTRACT STAGE FAILS WITH SQL ERROR WHILE RUNNING WITH MULTIPLE NODES PARTICULARLY WITH MORE THAN 2 NODES (REG. JR59681

APAR status

• Closed as program error.

Error description

• Delta Extract Stage fails with SQL error while running with
  multiple nodes particularly with more than 2 nodes (regression
  introduced by JR59681)
  Multiple nodes tried to update SAP table (RSBASIDOC , ROOSGEN ,
  TBDA2 , ROOSPRMSC). Due to which one tables that is already
  locked by one node, when another node try to update it, we get
  following errors:
      Object requested is currently locked by user <sap_username>
  for <datasource_name>
      SQL error SQL code: 60 occurred while accessing table DDPRH
  

Local fix

• NA
  

Problem summary

• Delta Extract Stage fails with SQL error while running with
  multiple nodes particularly with more than 2 nodes (regression
  introduced by JR59681)
  

Problem conclusion

• Reason:
  Multiple nodes tried to update SAP table (RSBASIDOC , ROOSGEN ,
  TBDA2 , ROOSPRMSC). Due to which one tables that is already
  locked by one node, when another node try to update it, we get
  following errors:
      Object requested is currently locked by user <sap_username>
  for <datasource_name>
      SQL error SQL code: 60 occurred while accessing table DDPRH
  
  Resolution:
  Code fix: Update the system tables by the master node only. Fix
  available as patch for v8003 and v81; present in v8101.
  

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

  IS PACK FOR SAP

• Fixed component ID

  5724Q5500

Applicable component levels