This discussion is archived
1 2 3 Previous Next 32 Replies Latest reply: Mar 14, 2013 3:09 AM by Veeresh Rayan RSS

ExecutionPlan Error while loading HRMS data through DAC

993605 Newbie
Currently Being Moderated
Hi All,

While executing Execution plan in DAC for HRMS we are getting below error. Please help US.

2013-03-07 01:07:01.353 INFORMATICA TASK:SILOS:SIL_IntlAssignmentDimension:(Source : FULL Target : FULL) has started.



ANOMALY INFO::: Error while executing : INFORMATICA TASK:SILOS:SIL_IntlAssignmentDimension:(Source : FULL Target : FULL)
MESSAGE:::
Irrecoverable Error
Error while contacting Informatica server for getting workflow status for SIL_IntlAssignmentDimension
Error Code = 36331:Unknown reason for error code 36331
Pmcmd output :

=====================================
STD OUTPUT
=====================================

Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1111], LINUX 32-bit
Copyright (c) Informatica Corporation 1994 - 2010
All Rights Reserved.

Invoked at Thu Mar 07 01:07:23 2013

Connected to Integration Service: [EISBI_IS].
Integration Service status: [Running]
Integration Service startup time: [Tue Jan 29 22:41:20 2013]
Integration Service current time: [Thu Mar 07 01:07:23 2013]
Folder: [SILOS]
Workflow: [SIL_IntlAssignmentDimension] version [1].
Workflow run status: [Failed]
Workflow run error code: [36331]
Workflow run error message: [WARNING: Session task instance [SIL_IntlAssignmentDimension_Unspecified_Full] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SIL_IntlAssignmentDimension] will be failed.]
Workflow run id [10058].
Start time: [Thu Mar 07 01:07:03 2013]
End time: [Thu Mar 07 01:07:21 2013]
Workflow log file: [d02/informatica/server/infa_shared/WorkflowLogs/SIL_IntlAssignmentDimension.log]
Workflow run type: [User request]
Run workflow as user: [Administrator]
Run workflow with Impersonated OSProfile in domain: []
Integration Service: [EISBI_IS]
Disconnecting from Integration Service

Completed at Thu Mar 07 01:07:23 2013

=====================================
ERROR OUTPUT
=====================================


Re-Queue to attempt to run again or attach to running workflow
if Execution Plan is still running or re-submit Execution Plan to execute the workflow.
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:886)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
java.lang.Thread.run(Thread.java:662)

(Number of retries : 1)

pmcmd startworkflow -sv EISBI_IS -d Domain_eld17.eistech.com -u Administrator -p **** -f SILOS -lpf /d02/informatica/server/infa_shared/SrcFiles//DataWarehouse.DataWarehouse.SILOS.SIL_IntlAssignmentDimension.txt SIL_IntlAssignmentDimension

2013-03-07 01:07:24.118 INFORMATICA TASK:SILOS:SIL_IntlAssignmentDimension:(Source : FULL Target : FULL) has finished execution with Failed status.

Thanks,
Siva
  • 1. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    Session task instance [SIL_IntlAssignmentDimension_Unspecified_Full] failed. Can you post session log for this session?
  • 2. Re: ExecutionPlan Error while loading HRMS data through DAC
    993605 Newbie
    Currently Being Moderated
    Hi,

    When I'm checking Informatica(M) ..It's showing below error. SDE level i'm facing this problem. But some times log also not generated.

    Failed

    Var_27026 Error: Missing inital value for session parameters:[$DBConnection_OLAP] .


    Thanks,
    Siva

    Edited by: 990602 on Mar 7, 2013 4:42 AM
  • 3. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Can you confirm your DAC version?..

    Regards,
    Veeresh Rayan
  • 4. Re: ExecutionPlan Error while loading HRMS data through DAC
    993605 Newbie
    Currently Being Moderated
    Hi..

    DAC 10.1.3.4.1

    Informatica : 9.0.2 Hotfix 2

    Thanks,
    Siva
  • 5. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Are you on latest version of cummulative DAC patch if you are using 10.1..3.4 as DAC version?..

    If not please download patch from metalink and apply it..

    You will face lot of other issues if you haven't applied this patch.

    Patch 14306642: DAC 10.1.3.4.1 CUMULATIVE PATCH FOR BI APPS - JUL 2012

    Shutdown the DAC server before you apply(also make the backup of DAWSystem.jar file backup and make any other file backup before replacing)

    Mark correct or helpfull if it helps.

    Regards,
    Veeresh Rayan
  • 6. Re: ExecutionPlan Error while loading HRMS data through DAC
    993605 Newbie
    Currently Being Moderated
    Hi,

    I have loaded Finance Data using same version of DAC..Right now i am loading HRMS data through same version DAC.

    Finance data loaded perfectly with out any error. So please guide me how to handle this type of issues.

    Failed

    Var_27026 Error: Missing inital value for session parameters:[$DBConnection_OLAP] .

    Thanks,
    Siva

    Edited by: 990602 on Mar 7, 2013 4:56 AM
  • 7. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Can you please let me know if you have setup OLAP and OLTP connections properly for HR execution plan?..

    Go to Execute-->highlight your execution plan -->in the down pain check for parameters tab --> check for the parameters for OLTP and OLAP and flat file.

    Another check you do is go to informatica -->workflow manager -->on the top pain connections -->then check the same parameter values are defined in the informatica

    These values exactly match with the values in the DAC source system parameter.

    Are you not combining HR and Fin together in your execution plan?..

    Can you also post what are you doing I mean the steps you are following??..I will be able to help you in case if you have missed any steps.

    Regards,
    Veeresh Rayan
  • 8. Re: ExecutionPlan Error while loading HRMS data through DAC
    993605 Newbie
    Currently Being Moderated
    Hi Veeresh,

    Thanks for your replaying . Same parameters i was done in both DAC and Informatica workflow connection.

    Fins execution plan is different and HR is execution plan is different. below are the connection details for HRMS data loading.


    DAC :-

    Name Value
    -------- ---------
    DBConnection_OLAP DataWarehouse(dwh/dwh)
    DBConnection_OLTP ORA_R1213(apps/apps)
    FlatFileConnection ORA_R1213_Flatfile

    Informatica :-

    Name
    -------
    DataWarehouse(dwh/dwh)
    ORA_R1213(apps/apps)



    Is it required to need to assign any flat file connection in informatica.


    Thanks,
    Siva
  • 9. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    Can you check the parameter file, generated by DAC, if you can find value for this parameter. If not, issue with DAC as it has not generated proper parameter file. Parameter fill location can be found in DAC->SETUP->SYSTEM PROPERTIES->PARAMETER FILE LOCATION.
  • 10. Re: ExecutionPlan Error while loading HRMS data through DAC
    993605 Newbie
    Currently Being Moderated
    This are the below details i have kept in DAC->SETUP->SYSTEM PROPERTIES->PARAMETER FILE LOCATION.


    InformaticaParameterFileLocation : /d02/informatica/server/infa_shared/SrcFiles/

    If i did any wrong please guide me. Can you please give me your mail id i will send my DAC System Properties screen Shots.



    Thanks,
    Siva.

    Edited by: 990602 on Mar 8, 2013 1:51 AM

    Edited by: 990602 on Mar 8, 2013 2:02 AM
  • 11. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    Please identify the paramenter file from this location corresponding to this DAC task and paste the contents here. My id-prabu202004@gmail.com
  • 12. Re: ExecutionPlan Error while loading HRMS data through DAC
    993605 Newbie
    Currently Being Moderated
    Hi,

    Parameter details.

    SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full]
    $$ANALYSIS_END=01/01/2011 12:59:00
    $$ANALYSIS_END_WID=20110101
    $$ANALYSIS_START=12/31/1979 01:00:00
    $$ANALYSIS_START_WID=19791231
    $$COST_TIME_GRAIN=QUARTER
    $$CURRENT_DATE=03/06/2013
    $$CURRENT_DATE_IN_SQL_FORMAT=TO_DATE('2013-03-06', 'YYYY-MM-DD')
    $$CURRENT_DATE_TIME_IN_SQL_FORMAT=TO_DATE('2013-03-06 03:38:30', 'YYYY-MM-DD HH24:MI:SS')
    $$CURRENT_DATE_WID=20130306
    $$CURRENT_ETL_START_TS=TO_DATE('2013-03-06 03:37:05', 'YYYY-MM-DD HH24:MI:SS')
    $$DATASOURCE_NUM_ID=1000
    $$DEFAULT_LOC_RATE_TYPE=Corporate
    $$DFLT_LANG=US
    $$ETL_PROC_WID=22708688
    $$FILTER_BY_LEDGER_ID='N'
    $$FILTER_BY_LEDGER_TYPE='N'
    $$GBL_CALENDAR_ID=Accounting~Month
    $$GBL_DATASOURCE_NUM_ID=9
    $$GLOBAL1_CURR_CODE=USD
    $$GLOBAL1_RATE_TYPE=Corporate
    $$GLOBAL2_CURR_CODE=USD
    $$GLOBAL2_RATE_TYPE=Corporate
    $$GLOBAL3_CURR_CODE=USD
    $$GLOBAL3_RATE_TYPE=Corporate
    $$HI_DATE=TO_DATE('3714-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HI_DT=01/01/3714 12:00:00
    $$HR_ABSNC_EXTRACT_DATE=1980-01-01
    $$HR_WRKFC_ADJ_SERVICE_DATE='N'
    $$HR_WRKFC_EXTRACT_DATE=TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HR_WRKFC_SNAPSHOT_DT=TO_DATE('2004-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HR_WRKFC_SNAPSHOT_TO_WID=20130306
    $$Hint_Tera_Post_Cast=
    $$Hint_Tera_Pre_Cast=
    $$INITIAL_EXTRACT_DATE=01/01/2007
    $$INVPROD_CAT_SET_ID=27
    $$INV_PROD_CAT_SET_ID10=
    $$INV_PROD_CAT_SET_ID1=27
    $$INV_PROD_CAT_SET_ID2=
    $$INV_PROD_CAT_SET_ID3=
    $$INV_PROD_CAT_SET_ID4=
    $$INV_PROD_CAT_SET_ID5=
    $$INV_PROD_CAT_SET_ID6=
    $$INV_PROD_CAT_SET_ID7=
    $$INV_PROD_CAT_SET_ID8=
    $$INV_PROD_CAT_SET_ID9=
    $$LANGUAGE_CODE=E
    $$LAST_EXTRACT_DATE=03/30/2003
    $$LAST_EXTRACT_DATE_IN_SQL_FORMAT=
    $$LAST_EXTRACT_DATE_WID=
    $$LAST_TARGET_EXTRACT_DATE_IN_SQL_FORMAT=
    $$LEDGER_ID_LIST=1
    $$LEDGER_TYPE_LIST='NONE'
    $$LOAD_DT=TO_DATE('2013-03-06 03:37:05', 'YYYY-MM-DD HH24:MI:SS')
    $$LOW_DATE=TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$LOW_DT=01/01/1899 00:00:00
    $$MASTER_CODE_NOT_FOUND=
    $$ORA_HI_DATE=TO_DATE('4712-12-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$PROD_CAT_SET_ID10=
    $$PROD_CAT_SET_ID1=2
    $$PROD_CAT_SET_ID2=
    $$PROD_CAT_SET_ID3=
    $$PROD_CAT_SET_ID4=
    $$PROD_CAT_SET_ID5=
    $$PROD_CAT_SET_ID6=
    $$PROD_CAT_SET_ID7=
    $$PROD_CAT_SET_ID8=
    $$PROD_CAT_SET_ID9=
    $$PROD_CAT_SET_ID=2
    $$SOURCE_CODE_NOT_SUPPLIED=
    $$TENANT_ID=DEFAULT
    $$WH_DATASOURCE_NUM_ID=999
    $$XRATE_UPD_NUM_DAY=10000
    $DBConnection_OLAP=DataWarehouse
    $DBConnection_OLTP=ORA_R1213
    $PMSessionLogFile=ORA_R1213.DATAWAREHOUSE.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.log
    mplt_BC_ORA_RateGeneral.$$INITIAL_EXTRACT_DATE=01/01/2007
    mplt_BC_ORA_RateGeneral.$$LAST_EXTRACT_DATE=03/30/2003
  • 13. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    Hi, I am expecting parameter file of the task- 'SIL_IntlAssignmentDimension' which was failed as you mentioned earlier. Is this OOTB tasks or custom one?
  • 14. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Prabhu,

    Thanks for your prompt reply.

    We are facing the issues in SDE level also and wants to clear the issue in SDE level first. Please consider the last Parameter file is major one.

    We are working on OOTB tasks only and even we didn't start any development in OBIApps as of now.

    Myself and Siva working together for same project.

    Thanks in Advance.

    Raghu NAgadasari
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points