Experts
I 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.
My source system is Siebel 8.1.X and MS SQL is Technology. Also noticed that all the sessions related to the S_LST_OF_VAL are failed.
ODI-1519: Serial step "Serial (InternalID:50500)" failed because child step "3 SDE General Domain (InternalID:53500)" is in error. ODI-1519: Serial step "3 SDE General Domain (InternalID:53500)" failed because child step "Load Target Table (InternalID:54500)" is in error. ODI-1519: Serial step "Load Target Table (InternalID:54500)" failed because child step "SEBL_8_1_1 - DSN 1 (InternalID:55500)" is in error. ODI-1519: Serial step "SEBL_8_1_1 - DSN 1 (InternalID:55500)" failed because child step "DOMAIN (InternalID:56500)" is in error. ODI-1519: Serial step "DOMAIN (InternalID:56500)" failed because child step "Parallel (InternalID:57500)" is in error. ODI-1518: Parallel step "Parallel (InternalID:57500)" 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: SALES (InternalID:106500), COMMON (InternalID:58500), SERVICE (InternalID:80500) ODI-1518: Parallel step "SALES (InternalID:106500)" failed; 10 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_DomainGeneral_S_LST_OF_VAL OPTY_SALES_CHANNEL (InternalID:115500), SDE_DomainGeneral_S_LST_OF_VAL DEAL_HORIZON (InternalID:116500), SDE_DomainGeneral_S_LST_OF_VAL DECISION_LVL (InternalID:110500), SDE_DomainGeneral_S_LST_OF_VAL RISK (InternalID:109500), SDE_SBL_DOMAINGENERAL_SALESSTAGE (InternalID:107500), SDE_DomainGeneral_S_LST_OF_VAL STRATEGIC (InternalID:108500), SDE_DomainGeneral_S_LST_OF_VAL OPTY_STATUS (InternalID:112500), SDE_DomainGeneral_S_LST_OF_VAL REASON_WON_LOST (InternalID:113500), SDE_DomainGeneral_S_LST_OF_VAL REVENUE_CLASS (InternalID:111500), SDE_DomainGeneral_S_LST_OF_VAL LEAD_QUALITY (InternalID:114500) ODI-1217: Session SDE_SBL_811_ADAPTOR_SDE_DOMAINGENERAL_S_LST_OF_VAL (46500) fails with return code 156. ODI-1226: Step SDE_DomainGeneral_S_LST_OF_VAL fails after 1 attempt(s). ODI-1240: Flow SDE_DomainGeneral_S_LST_OF_VAL 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 SIEBEL_SOURCE. Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'NULL'. at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source) at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source) at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source) at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source) at weblogic.jdbc.sqlserver.ddj.m(Unknown Source) at weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source) at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source) at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source) at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source) at weblogic.jdbc.sqlserverbase.ddel.r(Unknown Source) at weblogic.jdbc.sqlserverbase.ddde.execute(Unknown Source) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82) at java.lang.Thread.run(Thread.java:662)
Thanks
Matt