Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

getting error in Dac @DAC_SIL_PositionDimension_FULL_TD_CMD

Received Response
11
Views
3
Comments
user12116294
user12116294 Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

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

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Whats the DAC task to see this?

  • user12116294
    user12116294 Rank 3 - Community Apprentice

    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

    All Rights Reserved.

    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
    SriniVEERAVALLI Rank 6 - Analytics Lead

    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.