SAP Knowledge Base Article - Preview

2706367 - Default Deletion job and Archiving job is slow on JAVA PO PI systems - SAP ASE for Business Suite

Symptom

  • Archiving and "Default Deletion" jobs are slow on SAP JAVA AS - PO PI systems.
  • "IdocDBTableCleanup" and/or "IdocDBTableCleanupPeriodic" jobs which run as part of  / alongside the "Default Deletion" job are slow
  • The underlying slow sql queries are -

SELECT XI_MSG_NO FROM XI_IDOC_IN_MSG WHERE OUT_TIME <= convert(datetime,'10/10/18',3)
AND XI_MSG_NO NOT IN (SELECT MSG_ID FROM BC_MSG WHERE DIRECTION= 'OUTBOUND')
AND XI_MSG_NO NOT IN (SELECT PARENT_MSG_ID FROM BC_MSG WHERE DIRECTION = 'OUTBOUND' AND "PARENT_MSG_ID" IS NOT NULL)

SELECT XI_MSG_NO FROM XI_IDOC_IN_MSG m
WHERE m.OUT_TIME between '2018-07-18T00:00:00.000' and '2018-07-18T23:59:59.000'
AND XI_MSG_NO NOT IN (SELECT PARENT_MSG_ID FROM BC_MSG WHERE DIRECTION = 'OUTBOUND' AND PARENT_MSG_ID IS NOT NULL)
AND XI_MSG_NO NOT IN (SELECT MSG_ID FROM BC_MSG WHERE DIRECTION = 'OUTBOUND')

SELECT "OTX"."AUTO_NUMBER" "OTX_AUTO_NUMBER_autoNumber" FROM "XI_IDOC_OUT_TREX" "OTX" WHERE "OTX"."AUTO_NUMBER" NOT IN (SELECT DISTINCT "OMSG"."REF_NUMBER" FROM "XI_IDOC_OUT_MSG" "OMSG") AND "OTX"."AUTO_NUMBER" NOT IN (SELECT DISTINCT "OACK"."REF_NUMBER_TREX" FROM "XI_IDOC_OUT_ACK" "OACK")

  • On the ASE database, processes are seen to block on queries accessing tables, BC_MSG and BC_MID_CON_TRFC

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver JAVA AS

Product

SAP ERP 6.0

Keywords

BC_MID_CON_TRFC, BC_MSG, JAVA, PO, PI, XI, archiving, "Default deletion job", "deletion job", IdocDBTableCleanup, IdocDBTableCleanupPeriodic , XI_IDOC_IN_MSG, iDoc OUT_TIME, AUTO_NUMBER , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-XI-CON-IDO , Idoc Adapter J2EE , BC-XI-CON-MSG , Messaging System , Problem

About this page

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

Search for additional results

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