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.