getting error in Dac @DAC_SIL_PositionDimension_FULL_TD_CMD

Question

Hello Expert,

I am trying to load the sample data of siebel with help of DAC but it getting failed at task starting with @DAC_SIL_PositionDimension_FULL_TD_CMD.

I have search on blog and found that a patch is required for DAC 10.1.3.4.1.

But when I trying to download the patch from oracle site it says bug has been fixed and download option is grayed out.

Please let me know can i bypass this task if yes what will be effect and in case its important then how I can download the patch.

Kindly advice.

Thanks,

singh

SriniVEERAVALLI · Answer

I see as below for this

TaskName: Load into Position Dimension

Cmd for Full load: SIL_PositionDimension_Full

Cmd for Incr load: SIL_PositionDimension

I dont find any of DAC object as @DAC_SIL_PositionDimension_FULL_TD_CMD

you need to takeout and run with above info that should work.

user12116294 · Answer

Hello Srini,

Please find the below detail:-

Task Name: Load into position dimension

Group: TASK_GROUP-LOAD_POSITIONDIMENSION

Task Details;

Task: load into position dimension

name: @dac_sil_positiondimension_full_td_cmd

log message

2016-04-04 22:42:32.784 INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD:(Source : FULL Target : FULL) has started.

ANOMALY INFO::: Error while executing : INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD:(Source : FULL Target : FULL)

MESSAGE:::

Irrecoverable Error

Request to start workflow : '@DAC_SIL_PositionDimension_FULL_TD_CMD' has completed with error code 2

Error Message : The specified task name, workflow name, or folder name does not exist.

Command Used: pmcmd startworkflow -sv Powercenter_IS -d OBIA_7963 -u Administrator -p **** -f SILOS  -lpf C:\Informatica\9.0.1\server\infa_shared\DataWarehouse.DataWarehouse.SILOS.@DAC_SIL_PositionDimension_FULL_TD_CMD.txt @DAC_SIL_PositionDimension_FULL_TD_CMD

Workflow Message:

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

STD OUTPUT

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

Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1111], Windows 64-bit

Copyright (c) Informatica Corporation 1994 - 2010

Invoked at Mon Apr 04 22:42:33 2016

Connected to Integration Service: [Powercenter_IS].

ERROR: Workflow [@DAC_SIL_PositionDimension_FULL_TD_CMD] not found in folder [SILOS].

Disconnecting from Integration Service

Completed at Mon Apr 04 22:42:33 2016

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

ERROR OUTPUT

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

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

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

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

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

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

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

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:885)

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

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

(Number of retries : 1)

pmcmd startworkflow -sv Powercenter_IS -d OBIA_7963 -u Administrator -p **** -f SILOS  -lpf C:\Informatica\9.0.1\server\infa_shared\DataWarehouse.DataWarehouse.SILOS.@DAC_SIL_PositionDimension_FULL_TD_CMD.txt @DAC_SIL_PositionDimension_FULL_TD_CMD

2016-04-04 22:42:33.64 INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD:(Source : FULL Target : FULL) has finished execution with Failed status.

SriniVEERAVALLI · Answer

Whats the DAC task to see this?