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 while loading sample data of siebel with DAC

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

Hello Experts,

We are trying to load the sample data of siebel into warehouse with DAC.

DAC version:-  10.1.3.4.1

siebel call center 7.8

Informatica - 9.0

we trying to run the CRM Service - Siebel 7.8 execution plans

following task is getting failed due to all subsequent tasks also fails.

TASK_GROUP_EXTRACT_InternalOrganizationHierarchy_temporary

error mesasge

Because task Extract for Internal Organization Dimension Hierarchy BU Temporary failed marking all the completed nodes of the group TASK_GROUP_Extract_InternalOrganizationHierarchy_Temporary (whose restart all is set to true), as failed.

we tried to run it the associated mapping manually from Informatica but it also fails.

when we trying to see the log from informatica we are facing another error message:

Unable to fetch log

core_003 an internal execption occurred with message  lgs_10052

the log service has no record of the requested session or workflow run.\n

Kindly help

Thanks

Singh

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Singh, If you are storing parameter files at dac folder then keep in Informatica folder and try to run the workflow from Workflow manager.

    let me know how this works for you.

    then we go to dac!

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Also you may Unit Test the task 'Extract for Internal Organization Dimension Hierarchy BU Temporary' from dac execution plan.

    let me know log message from both.

  • user12116294
    user12116294 Rank 3 - Community Apprentice

    Thanks Srini, I have checked the mapping and found that mapping was using a parameter file at shared location, I have placed the file and it solved the issue.

    Thanks you a lot.