3 Replies Latest reply: Jul 6, 2013 5:14 AM by 841717 RSS

    ODI Load Plan errors in OBIA11.1.1.7.1

    1005509

      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

        • 1. Re: ODI Load Plan errors in OBIA11.1.1.7.1
          Sher Ullah Baig

          Hi

          this is general error. please click on 'Load step' on left hand side menu and then expend all Tasks and navigate to Task where Error is showing (red one, this task might have child tasks) then Double click on child tasks and post full error.

          As per this error it seems Source Database is missing Table or view.

          'ORA-00942: table or view does not exist'

           

          Ref: 

           

          Regards

          Sher

          • 2. Re: ODI Load Plan errors in OBIA11.1.1.7.1
            1005509

            Hi Sher...

             

            Please find the error on the step...

             

            ODI-1217: Session SDE_PSFT_90_ADAPTOR_SDE_PSFT_DOMAINGENERAL_PSXLATITEM_FIN (118500) 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

             

            The question I have is...apperently staging table( eg. SQ_PSXLATITEM) are being created on Source Database which is a "no" for us...more over Source DB is readonly. can you check where these staging tables are  created in your environment if you have run Load plan??

             

            Thanks

            • 3. Re: ODI Load Plan errors in OBIA11.1.1.7.1
              841717

              SQ_PSXLATITEM would not be an actual stage table but an inline query alias (or alias of temp interface). Check the code section to see the extract SQL. Check if the schema prefixes to table name in the extract SQL are that of the correct source schema. Try running only the select query directly through SQL developer on source schema. Looks mostly like a config issue.