Skip to Content
avatar image
Former Member

Error log information into a table in BODS

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

--Praneeth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    dataflow_name()

    job_name()

    workflow_name()

    You can use error_message() function inside a catch exception

    This can be tricky but achieveable :)

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded