We installed and configured OBIA11.1.1.7.1
and trying to run a load plan through biacm...and get these errors...any idea what they could be...we followed the documentation for installtion and configuration.
ODI-1519: Serial step "Start Load Plan (InternalID:120500)" failed because child step "Global Variable Refresh (InternalID:121500)" is in error. ODI-1519: Serial step "Global Variable Refresh (InternalID:121500)" failed because child step "Source Extract Phase (InternalID:124500)" is in error. ODI-1519: Serial step "Source Extract Phase (InternalID:124500)" failed because child step "1 General (InternalID:125500)" is in error. ODI-1519: Serial step "1 General (InternalID:125500)" failed because child step "2 General SDE (InternalID:168500)" is in error. ODI-1519: Serial step "2 General SDE (InternalID:168500)" failed because child step "Serial (InternalID:169500)" is in error. ODI-1519: Serial step "Serial (InternalID:169500)" failed because child step "3 SDE General Domain (InternalID:172500)" is in error. ODI-1519: Serial step "3 SDE General Domain (InternalID:172500)" failed because child step "Load Target Table (InternalID:173500)" is in error. ODI-1519: Serial step "Load Target Table (InternalID:173500)" failed because child step "PSFT_9_0 - DSN 1 (InternalID:174500)" is in error. ODI-1519: Serial step "PSFT_9_0 - DSN 1 (InternalID:174500)" failed because child step "DOMAIN (InternalID:175500)" is in error. ODI-1519: Serial step "DOMAIN (InternalID:175500)" failed because child step "Parallel (InternalID:176500)" is in error. ODI-1518: Parallel step "Parallel (InternalID:176500)" failed; 3 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: PROC (InternalID:189500), FINANCIALS (InternalID:185500), COMMON (InternalID:177500) ODI-1518: Parallel step "PROC (InternalID:189500)" 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: SDE_PSFT_DOMAINGENERAL_PSXLATITEM EXMEXPENSEPAYMENTTYPE (InternalID:190500) ODI-1217: Session SDE_PSFT_90_ADAPTOR_SDE_PSFT_DOMAINGENERAL_PSXLATITEM_FIN (72500) fails with return code 942. ODI-1226: Step Run SDE_PSFT_DomainGeneral_PSXLATITEM_FIN_W_DOMAIN_MEMBER_GS fails after 1 attempt(s). ODI-1240: Flow Run SDE_PSFT_DomainGeneral_PSXLATITEM_FIN_W_DOMAIN_MEMBER_GS fails while performing a Loading operation. This flow loads target table W_DOMAIN_MEMBER_GS. ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection ODI_POC_DB. Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Thanks