2 Replies Latest reply: Nov 1, 2012 4:58 AM by 971430 RSS

    DAC Load is failing for Siebel Source system on DB2 database.

    971430
      Source is Siebel on DB2.
      Warehouse is on DB2.
      While executing the DAC following error occurred:
      2012-10-30 03:58:20.138 Acquiring Resources

      2012-10-30 03:58:20.224 Acquired Resources


      2012-10-30 03:58:20.462 CHANGE CAPTURE:IMG_BUILD - Internal S_LEAD_OPTY has started.




      # of prune days: 43200

      Capturing data modified after: 2012-09-29 10:24:25.692 in Full Mode.

      2012-10-30 03:58:20.483 - Executing :
      SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
      2012-10-30 03:58:20.493 - ERROR: While executing :
      SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
      DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=TRANSACTION;SET ;<space>, DRIVER=3.57.82


      ANOMALY INFO::: Error while executing : CHANGE CAPTURE:IMG_BUILD - Internal S_LEAD_OPTY
      MESSAGE:::com.siebel.analytics.etl.execution.exceptions.ChangeCaptureTaskFailedException: Change Capture failed.
      EXCEPTION CLASS::: java.lang.RuntimeException

      com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:536)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
      com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
      java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      java.util.concurrent.FutureTask.run(Unknown Source)
      java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      java.util.concurrent.FutureTask.run(Unknown Source)
      java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      java.lang.Thread.run(Unknown Source)

      ::: CAUSE :::
      MESSAGE :::Change Capture failed.
      EXCEPTION CLASS::: com.siebel.analytics.etl.execution.exceptions.ChangeCaptureTaskFailedException

      com.siebel.analytics.etl.etltask.ChangeCaptureTask.executeChangeCapture(ChangeCaptureTask.java:93)
      com.siebel.analytics.etl.etltask.ChangeCaptureTask.doExecute(ChangeCaptureTask.java:46)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
      com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
      java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      java.util.concurrent.FutureTask.run(Unknown Source)
      java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      java.util.concurrent.FutureTask.run(Unknown Source)
      java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      java.lang.Thread.run(Unknown Source)

      (Number of retries : 1)

      IMG_BUILD - Internal

      2012-10-30 03:58:30.5 CHANGE CAPTURE:IMG_BUILD - Internal S_LEAD_OPTY has finished execution with Failed status.