SAP Knowledge Base Article - Preview

2706367 - Archiving and Deletion jobs are slow on JAVA PO PI systems - SAP ASE for Business Suite

Symptom

  • Archiving and Deletion jobs are slow on SAP JAVA AS - PO PI systems.
  • Specifically, IdocDBTableCleanup and/or IdocDBTableCleanupPeriodic 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')

 


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

JAVA, PO, PI, XI, archiving, deletion, jobs, IdocDBTableCleanup, IdocDBTableCleanupPeriodic, slow, BC_MSG, XI_IDOC_IN_MSG, iDoc , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.