Skip to Content

Error log information into a table in BODS

Jun 05, 2017 at 02:21 PM


avatar image
Former Member

I have a requirement that I need to capture failed jobs information in an environment like error message, job name,workflow name,data flow name and job failed time into a table.

I have tried to read the data from error log file using al_history and al_history_info tables to get the file folder and file for a day. but it is working only for some cases.

Can you please help me on the requirement.

Thanks in advance


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Sasi Jun 06, 2017 at 09:31 AM

Can you try using the functions available inside a script and then insert the values in an error log table. This would make life simpler. Getting the details from metadata tables is tedious




You can use error_message() function inside a catch exception

This can be tricky but achieveable :)


Arun Sasi

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I have tried it with the catch block but it failed.

Error_message can be achievable by using try block. But in this case try block is catching only error that are enabled in catch block.using data_flow name and job_name function will show the information of the respective data flow and job.

We don't know the exact failure job name on daily basis. As per my requirement I need to capture the information of all jobs failed in an environment like Test or Live.

Please find the attached screenshot of my test job flow(Which I have tried with AL_HISTORY and AL_HISTORY_INFO)


01.png (95.9 kB)
02.png (278.4 kB)
03.png (59.8 kB)
04.png (37.2 kB)
05.png (120.4 kB)
06.png (211.3 kB)
07.png (84.7 kB)
08.png (109.6 kB)
09.png (214.6 kB)