Hi,
I'm trying to run 'PKG-ORACLE_KNOWLEDGE_MAIN' but it's failing. The error I'm getting:
| Header 1 |
|---|
WARNING ODI-1134 Agent Internal encountered an error: ODI-1226: ODI-1226 Step V_NEXT_BATCH_FROM_STAGE fails after 1 attempt(s). ERROR ODI-1217 Session PKG-ORACLE_KNOWLEDGE_MAIN (7262137) fails with return code 7000. |
On looking into the V_NEXT_BATCH_FROM_STAGE, I saw the error is actually thrown by variable V_NEXT_BATCH_FROM_STAGE. The error details:
| Header 1 |
|---|
java.lang.NumberFormatException at java.math.BigDecimal.<init>(BigDecimal.java:459) |
Please let me know where am I going wrong.
We are using ODI 11g(11.1.1.7) with Oracle DB.
Regards
-Adi
========================================================EDIT 1=============================================================================================
We saw that the variable V_NEXT_BATCH_FROM_STAGE here was having sql definition which was different from what we get originally in the regular install. So, we tried deleting DW_Data_Loads after stopping Agent but we its not geting deleted and we are getting the following error:
| Header 1 |
|---|
ODI-10090: Object Knowledge Module: DW_Data_Loads.CKM Oracle is referenced by: DwgObject(com.sunopsis.dwg.dbobj.SnpModel): Dev_Target_New_Data. Cannot remove. Excetion: com.sunopsis.dwg.SnpslsReferenceException: ODI-10090 |
Please let me know where am I going wrong.
Regards:
-Adi