SA Data Archive System SXXML Log Tables Report overview

System Administrator > Data Archive Purge > SAD Reports > SADSX

Function acronym: SADSX

Use this report to archive records that were created by the Create Transaction Audit Records business rule with the rule type of audit. The business rule is enabled in SA Business Rule Setup. These records are created to notify system administrators of issues or errors that occur when running applications that use SX.api calls in the SX.api appserver.

Records with a blank docStatus or records with a docStatus of prc, err, wip or can are removed from these SXXML log tables:

  • sxxmldoc
  • sxxmlnode
  • sxxmlattr
  • edidata
  • edie
  • edih
  • edil

These records are not removed by this report:

  • Records that are used in EDI Electronic Transaction Control Center Entry
  • Unresolved errors that are processed in OE Ecommerce Queue Inquiry in the graphical version of Distribution SX.e

We recommend that you evaluate the number of records in your database before performing the purge. The first time that you run the report, do not specify 0 for the Number of Days to Keep SXXML Log Tables option to remove all tables. The report might take a long time to run. Start with a large number of days to determine how long the report takes to complete. You can set the report up as a stored report to run on a regular basis, such as quarterly.