BW4HANA access new DTP log via ABAP

[alexander_kutz]

I try to get the detailed error log from a DTP run in BW4HANA via ABAP. Through the FM RSPC_API_CHAIN_GET_LOG I get the DTP run with INSTANCE DTPR__20190516... and the DTP name. But how can I read the log. The tables changed. I guess it must be read through a class of the DTP or is there a class to read in general logs?

[DoanManhQuynh]

1. Read it from application log:

Call function module: APPL_LOG_READ_DB with Object = RSSM, Sub object = MON, EXTERNAL_NUMBER = instance ID of DTP & "*" (external number is concatenate of instance number and DSO type, name...so you have to push * there).

2. Alternative way is read from Job log SM37:

2.1. Get process chain node type, event and parameter from table RSPCCHAIN,

2.2. Get job count from table TBCTO with job name = "BI_PROCESS_"&"node type", event ID and parameter.

2.3. Read job log using function module BP_JOBLOG_READ with job name and job count.

[alexander_kutz]

Thanks.

First one is not working in BW4HANA - I don't find anything - even if I search only on the External number with the instance.

The alternative is parcially working, but I get there only the job log of the DTP itself. The error messages raised within the transformation (which are visible in the details of the DTP run) are not accessible through this log.

Any other ideas?

[DoanManhQuynh]

Alexander Kutz:Can you see the application logs from tcode SLG1? my BW system is for HANA too, i can see the logs there...i dont have error logs to verify.

[alexander_kutz]

There are log entries, yes, but there are not the process log entries (by adding messages to MONITOR TYPE rstmonitor in e.g. start routine of the transformation). These messages must be stored somewhere else - and these message I would like to read.

[DoanManhQuynh]

Alexander Kutz

DTP message would be stored in table RSBMONMESS_DTP.

you get request ID from table RSBKREQUEST with condition is Request number for the data transfer is the ID you get from begining.