TBML - Batch Execution Failed Because Of Invalid Schema Name
(Doc ID 2734158.1)
Last updated on APRIL 24, 2023
Applies to:
Oracle Financial Services Behavior Detection Platform - Version 8.0 and laterInformation in this document applies to any platform.
Goal
Customer is reported that, they have installed fresh TBAML 807 on OFSBD and ECM 807. Installation was successful and no errors were found in logs.
After this they have executed the TBAML scenario jobs, and after the alerts were created. After they executed the TBAML ECM batch the batch failed on the 2nd step.
In the logs we noticed that temp table creation failed. it is trying to use table from OFSAATBMLUBL table instead on OFSAAFCCMUBL which is the correct schema table.
2020/11/09 11:17:01:::sourceName::OFSAATBMLUBLdataMovementCode::TBAML_EVENT_LOOKUP::runskey::9412::filters::"$RUNSKEY"="9412"[]"$MISDATE"="to_date(^20151030^,^yyyyMMdd^)"
java.sql.SQLException: ORA-20104: Create Temp Table failed
ORA-06512: at "OFSAAFCCMUBL.PKG_FCC_DM", line 250
ORA-06512: at line 1
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |