Capture errors from DQ Reports

[danped]

I have a data integration job which uses the tDqReportRun component to execute a DQ report. It captures the output of the tDqReportRun component into a table which logs errors with the execution, however it does not capture all errors. I also want to be able to capture errors with the reports themselves.

In my case the DQ report stores the DQ rule results in an oracle database. If the credentials (user/pass) supplied to the oracle database is invalid an Oracle error is thrown, I can see this in the output window in the console but how can I access this in the jobflow to log the error?

Thanks

[Anonymous]

Hello,

Could you please show us the error message you want to capture by DQ Reports?We will appreciate if you could post your job design screenshot here.

Best regards

Sabrina

[danped]

Hi Sabrina - here is an image of the job along with an example of an error we'd like to capture.

[danped]

Hi - Any ideas on how to capture this?