SAP PO Transaction Log Full problem deleting records in table XI_AF_ADM_PROC_LOG

[Former Member]

Hello experts,

We have a PO 7.4 single stack instance with DB2 database, the problem with transaction log full happens many times a day, we have captured the SQL statement that causes the problem using db2diag.log and the command "db2 get snapshot for application agentid ####":

Dynamic SQL statement text: DELETE FROM "XI_AF_ADM_PROC_LOG" WHERE "XI_AF_ADM_PROC_LOG"."CREATED_TIME" < ?

Is there a way to clean consistently the table XI_AF_ADM_PROC_LOG? It has about 22.000.000 records. The log space was increased, but the problem continues. I could not identify the process that triggers that SQL statement in PO.

Thanks and regards,

[Former Member · Accepted solution]

Hi,

The problem was solved, we created an incident, and SAP asked to truncate the table XI_AF_ADM_PROC_LOG.

Regards,

[Former Member]

Hello Prithviraj,

I already checked the expensive SQL statement trough Solman and the sentence is: DELETE FROM "XI_AF_ADM_PROC_LOG" WHERE "XI_AF_ADM_PROC_LOG"."CREATED_TIME" < ?

We identified the job that triggers the SQL sentence: http://hostname:50000/pimon - Monitoring Home - Monitoring - Adapter Engine - Background Job Processing Monitor - Adapter Framework Scheduler Jobs :

Job Name: ChannelProcessStatusLogRemoverJob

Recurrence: 90 minutes

Each time the job is executed the transaction log gets full. Is there a way to pause the job while the table gets cleaned or trucated?

Thanks,

Ronald Melian

[Former Member]

Hi Ronald,

First, search for table name XI_AF_ADM_PROC_LOG in expensive SQL statement list in DB02 (If it is single stack try connecting it through Solution Manager) to find the source program/report.

Also check the below blog if that helps

https://blogs.sap.com/2015/12/31/db2-primary-and-secondary-logs-and-troubleshooting/

Regards

Prithviraj