This post explains the process to unload an error message from ODI repository log tables SNP_LPI_STEP_LOG, SNP_LPI_EXC_LOG to .txt file and attach it to a Load Plan failure notification email.
- Create ‘Error_Notification’ package which uses ODISqlUnload utility to unload error message from log tables and write into text file, OdiSendMail utility to send email to distribution list with error message attached.
- Create exception in load plan and add ‘Error_Notification’ package scenario.
Drag OdiSqlUnload utility from ‘All’ or ‘Files’ folder into package.
Enter OdiSqlUnload parameters as below
Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.
What are you most interested in learning today?
Answer Total Number Total %
What is blockchain 38 0.21
Why blockchain 18 0.1
Industry use cases 106 0.57
How to get started 11 0.06
Best practices 12 0.06
Total Responses: 185 of 428 (43%)
Drag OdiSendMail utility from ‘All’ or ‘Internet’ folder
Enter OdiSendMail parameters as below
Where is your organization on its blockchain journey?
Answer Total Number Total % Not yet started 130 0.62 Identifying use cases 55 0.26 Competing a POC 9 0.04 Building a prototype 7 0.03 Doing a pilot 5 0.02 Planning to scale 3 0.01 Total Responses: 209 of 428 (49%)
Save package and generate scenario.
Open load plan, go to Exceptions tab on left side, add exception and drag the ‘FAILURE_EMAIL_WITH_LOG_FILE’ scenario as below.
Whenever load plan fails, ‘FAILURE_EMAIL_WITH_LOG_FILE’ scenario will be executed and email will be sent to distribution list with error message attached in .txt file.