Datasphere Replication Flow logs

[MattRogers]

I want to be able to check on the status of my replication flows by checking the log/database tables so I can monitor and check on replication flow execution status programatically.  When I look at the Data Integration Monitor within Datasphere, I can see the Run log details and the Object log details displayed.

The Run log details can be found in the monitoring tables ("TASK_LOGS_V_EXT" and "TASK_LOG_MESSAGES_V_EXT") but I cannot find the Object log details.  See attached file for the Object log details that I am looking for

Does anyone know if these are available?

regs

[Vitaliy-R]

Have you tried if you can do that using CLI (sorry, I do not know the answer): https://help.sap.com/docs/SAP_DATASPHERE/d0ecd6f297ac40249072a44df0549c1a/2b26a31f197444dea314495bc0...?

[MattRogers]

Hi Vitaliy 

Thanks for the suggestion - unfortunately I've just tried it and whilst you can download the tasklogs, it's only the same level of detail that I get from the Monitor table around tasks.  I'm still missing the Object log level detail that the Data Integration Monitor screen shows unfortunately.

[AtillaCemYildizJ]

Hello Matt,

Have you ever find the table? I need that detail level but i cant find too.

[MattRogers]

Hi Atilla,

Unfortunately no - not found a way yet to get visibility of this level of detail which is a shame as it seems to be critical to be able to know when these types of issues arise and let other dependent systems know - seems aligned to the business data fabric concept.

[AtillaCemYildizJ]

Hello again Matt,
Although it's not exactly what you want but I found some things that might be useful. I accessed Database Explorer from System --> Configuration --> Database Analysis. There is a table called REPLICATIONFLOW_RUN_DETAILS. This table holds the data from the Replication tab in the Replication Flow. It wasn't exactly what I was looking for, but maybe it's useful to you.

[MattRogers]

Thanks Atilla - will take a look!