Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Error While running ETL for Caused By: java.sql.SQLException: ORA-20001: Error when creating index/c
3122505
Rank 3 - Community Apprentice
Hi experts,
I am running ETL for SCM and facing the following error,
| ODI-1519 | |
| ODI-1519: Serial step "Start Load Plan (InternalID:66307500)" failed because child step "Global Variable Refresh (InternalID:66308500)" is in error. ODI-1519: Serial step "Global Variable Refresh (InternalID:66308500)" failed because child step "Warehouse Load Phase (InternalID:68507500)" is in error. ODI-1519: Serial step "Warehouse Load Phase (InternalID:68507500)" failed because child step "1 SIL Load (InternalID:68508500)" is in error. ODI-1519: Serial step "1 SIL Load (InternalID:68508500)" failed because child step "2 SIL Dimension Group (InternalID:68509500)" is in error. ODI-1519: Serial step "2 SIL Dimension Group (InternalID:68509500)" failed because child step "Parallel -Independent DimGroup (InternalID:68521500)" is in error. ODI-1518: Parallel step "Parallel -Independent DimGroup (InternalID:68521500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: 3 SIL Dims PRODCAT_DIM (InternalID:68665500) ODI-1519: Serial step "3 SIL Dims PRODCAT_DIM (InternalID:68665500)" failed because child step "Initialize PRODCAT_DIM (InternalID:68666500)" is in error. ODI-1518: Parallel step "Initialize PRODCAT_DIM (InternalID:68666500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: Initialize : W_PROD_CAT_DH (InternalID:68667500) ODI-1217: Session EXEC_TABLE_MAINT_PROC (61752500) fails with return code 20001. ODI-1226: Step TABLE_MAINT_PROC fails after 1 attempt(s). ODI-1232: Procedure TABLE_MAINT_PROC execution fails. ODI-1228: Task TABLE_MAINT_PROC (Procedure) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-20001: Error when creating index/constraint W_PROD_CAT_DH_M11 for table DEV_DW.W_PROD_CAT_DH Error=-1732 -ORA-01732: data manipulation operation not legal on this view ORA-06512: at line 94 |
0