SAP Knowledge Base Article - Preview

3224126 - Default Deletion Job slows down the PO system

Symptom

  • The Process Orchestration system performance is slow during the execution of default deletion job.
  • After the deletion job is executed, you see the below SQL query running:

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")


Read more...

Environment

SAP Netweaver Process Orchestration

Product

SAP NetWeaver all versions

Keywords

Default deletion job, IdocDBTableCleanup, IdocDBTableCleanupPeriodic , XI_IDOC_IN_MSG, XI_IDOC_OUT_TREX, slow, performance , KBA , BC-XI-CON-MSG , Messaging System , BC-XI-CON-IDO , Idoc Adapter J2EE , Problem

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.