In ADP trace we cannot see the DB transaction events
I am using Asynchronous data pages but when i do a trace none of my DB transaction events in the ADP calling activity is getting listed in tracer( Activity stepsm when , DataTransform are available in tracer ). Even i have enabled DB cache and DB Query. Let me know if there is any settings to enable the same. Thanks in advance.
In normal tracer would not list up DB query runs by ADP because it runs on different requestor / thread due to its nature of being Asynchronous. You can try setting ADP Load event type from tracer setting. Hope this will help you.
Please refer my earlier attachment. I have enabled all tracer setting but i am still unable to view the ADP DB trace related logs (Obj-Save, Obj-opn, even Commit) does not show anything. I am able to see the ADP traces (but not the DB transactions in them).
How exactly you are loading your datapage? are you calling connect-Wait method? In case you loading datapage in a flow action then in pre processing activity you can load datapage and post processing activity you can call connect-wait method provided the pool ID matches in both activities.
While tracing your activity check for the requestor management on SMA to capture the child requestor ID for loading datapage, you can select that requestor and click on tracer.