Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Message : Unknown reason for error code 36331 (DAC Error)

2632950Dec 9 2014 — edited Dec 10 2014

Hello - I am running a DAC execution plan which keeps failing with error code 36331 but no reason logged. Could anyone share your thoughts on this? Please see log below:

613 SEVERE Tue Dec 09 16:25:37 CST 2014

--------------------------------------------

START OF ETL

--------------------------------------------

614 SEVERE Tue Dec 09 16:30:57 CST 2014 Starting ETL Process.

615 SEVERE Tue Dec 09 16:41:15 CST 2014 Request to start workflow : 'SDE_Custom_Adaptor:SDE_PSFT_GrantsDepartmentDimension_Test' has completed with error code 0

616 SEVERE Tue Dec 09 16:44:10 CST 2014 pmcmd startworkflow -sv IS_hhvappobip02 -d Domain_hhvappobip02.tmh.tmhs -u Administrator -p **** -f SDE_Custom_Adaptor -lpf /apps/obiee/Informatica/9.0.1/server/infa_shared/SrcFiles/PSFT_9_1_FINSCM_UAT.DataWarehouse_UAT.SDE_Custom_Adaptor.SDE_PSFT_GrantsDepartmentDimension_Test.txt SDE_PSFT_GrantsDepartmentDimension_Test

Status Desc : Failed

WorkFlowMessage :

=====================================

STD OUTPUT

=====================================

Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1110], LINUX 64-bit

Invoked at Tue Dec 09 16:44:00 2014

Connected to Integration Service: [IS_hhvappobip02].

Integration Service status: [Running]

Integration Service startup time: [Mon Dec 01 05:59:09 2014]

Integration Service current time: [Tue Dec 09 16:44:09 2014]

Folder: [SDE_Custom_Adaptor]

Workflow: [SDE_PSFT_GrantsDepartmentDimension_Test] version [7].

Workflow run status: [Failed]

Workflow run error code: [36331]

Workflow run error message: [WARNING: Session task instance [SDE_PSFT_GrantsDepartmentDimension_Test] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_PSFT_GrantsDepartmentDimension_Test] will be failed.]

Workflow run id [393158].

Start time: [Tue Dec 09 16:41:14 2014]

End time: [Tue Dec 09 16:43:57 2014]

Workflow log file: [/apps/obiee/Informatica/9.0.1/server/infa_shared/WorkflowLogs/SDE_PSFT_GrantsDepartmentDimension_Test.log]

Workflow run type: [User request]

Run workflow as user: [Administrator]

Run workflow with Impersonated OSProfile in domain: []

Integration Service: [IS_hhvappobip02]

Disconnecting from Integration Service

Completed at Tue Dec 09 16:44:09 2014

=====================================

ERROR OUTPUT

=====================================

Error Message : Unknown reason for error code 36331

ErrorCode : 36331

617 SEVERE Tue Dec 09 16:44:22 CST 2014

ANOMALY INFO::: Error while executing : INFORMATICA TASK:SDE_Custom_Adaptor:SDE_PSFT_GrantsDepartmentDimension_Test:(Source : INCREMENTAL Target : INCREMENTAL)

MESSAGE:::

Irrecoverable Error

pmcmd startworkflow -sv IS_hhvappobip02 -d Domain_hhvappobip02.tmh.tmhs -u Administrator -p **** -f SDE_Custom_Adaptor -lpf /apps/obiee/Informatica/9.0.1/server/infa_shared/SrcFiles/PSFT_9_1_FINSCM_UAT.DataWarehouse_UAT.SDE_Custom_Adaptor.SDE_PSFT_GrantsDepartmentDimension_Test.txt SDE_PSFT_GrantsDepartmentDimension_Test

Status Desc : Failed

WorkFlowMessage :

=====================================

STD OUTPUT

=====================================

Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1110], LINUX 64-bit

Invoked at Tue Dec 09 16:44:00 2014

Connected to Integration Service: [IS_hhvappobip02].

Integration Service status: [Running]

Integration Service startup time: [Mon Dec 01 05:59:09 2014]

Integration Service current time: [Tue Dec 09 16:44:09 2014]

Folder: [SDE_Custom_Adaptor]

Workflow: [SDE_PSFT_GrantsDepartmentDimension_Test] version [7].

Workflow run status: [Failed]

Workflow run error code: [36331]

Workflow run id [393158].

Start time: [Tue Dec 09 16:41:14 2014]

End time: [Tue Dec 09 16:43:57 2014]

Workflow log file: [/apps/obiee/Informatica/9.0.1/server/infa_shared/WorkflowLogs/SDE_PSFT_GrantsDepartmentDimension_Test.log]

Workflow run type: [User request]

Run workflow as user: [Administrator]

Run workflow with Impersonated OSProfile in domain: []

Integration Service: [IS_hhvappobip02]

Disconnecting from Integration Service

Completed at Tue Dec 09 16:44:09 2014

=====================================

ERROR OUTPUT

=====================================

Error Message : Unknown reason for error code 36331

ErrorCode : 36331

EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.IrrecoverableException

com.siebel.analytics.etl.etltask.InformaticaTask.doExecute(InformaticaTask.java:183)

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:411)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)

com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:586)

com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)

java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

java.util.concurrent.FutureTask.run(FutureTask.java:138)

java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

java.util.concurrent.FutureTask.run(FutureTask.java:138)

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

java.lang.Thread.run(Thread.java:662)

618 SEVERE Tue Dec 09 16:44:22 CST 2014

ANOMALY INFO::: Error while executing task Informatica Session Batch

MESSAGE:::Submitted task failed during execution

EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.FailedTaskException

com.siebel.analytics.etl.etltask.ParallelTaskBatch.submitIncompleteTasks(ParallelTaskBatch.java:251)

com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:360)

com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:164)

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:411)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)

com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:326)

com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:164)

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:411)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.etl.engine.core.Session.executeTasks(Session.java:2701)

com.siebel.etl.engine.core.Session.run(Session.java:3251)

java.lang.Thread.run(Thread.java:662)

619 SEVERE Tue Dec 09 16:44:22 CST 2014

ANOMALY INFO::: Error while executing : com.siebel.analytics.etl.etltask.ParallelTaskBatch:Informatica Session Batch

MESSAGE:::com.siebel.analytics.etl.etltask.FailedTaskException: Submitted task failed during execution

EXCEPTION CLASS::: java.lang.RuntimeException

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:470)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)

com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecuteNormal(ParallelTaskBatch.java:326)

com.siebel.analytics.etl.etltask.ParallelTaskBatch.doExecute(ParallelTaskBatch.java:164)

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:411)

com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)

com.siebel.etl.engine.core.Session.executeTasks(Session.java:2701)

com.siebel.etl.engine.core.Session.run(Session.java:3251)

java.lang.Thread.run(Thread.java:662)

::: CAUSE :::