Skip to Main Content
Forums

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!

Informatica Start Workflow failed in Workflow Manager

405415Feb 26 2008 — edited Mar 17 2008
Hi,
I have just completed the installation of oracle BI Apps version 7.9.4 (Chapter 4 & 5 of installtion document). Now I am trying to run workflow using informatica workflow manager and i am getting below error in workflow log.

It says "Cannot find specified parameter file [opt/oracle/informatica/server/SrcFiles/PLP.PLP_SalesOrderLinesFact_InvoicedQty_Update.txt] for session [PLP_SalesOrderLinesFact_InvoicedQty_Update].]."

What does this mean? Do i need to perform any post installation steps? If yes, what are those? Were can i find the information on what needs to be done for loading the data?

Error Log:

INFO : LM_36435 : (8588|-1567704144) Starting execution of workflow [PLP_SalesOrderLinesFact_InvoicedQty_Update] in folder [PLP] last saved by user [Administrator].
INFO : LM_36330 [Tue Feb 26 23:46:06 2008] : (8588|-1567704144) Start task instance [Start]: Execution started.
INFO : LM_36318 [Tue Feb 26 23:46:06 2008] : (8588|-1567704144) Start task instance [Start]: Execution succeeded.
INFO : LM_36505 : (8588|-1567704144) Link [Start --> PLP_SalesOrderLinesFact_InvoicedQty_Update]: empty expression string, evaluated to TRUE.
INFO : LM_36330 [Tue Feb 26 23:46:06 2008] : (8588|-1567704144) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: Execution started.
INFO : LM_36522 : (8588|-1567704144) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: Started DTM process [pid = 9081] for this session instance.
INFO : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: LM_36033 [Connected to repository [Oracle_BI_DW_Base] running on server:port [PUNITP85528D.ad.infosys.com]:[5001] user [Administrator]].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: CMN_1761 [Timestamp Event: [Tue Feb 26 23:46:14 2008]].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: VAR_27015 [Cannot find specified parameter file [/opt/oracle/informatica/server/SrcFiles/PLP.PLP_SalesOrderLinesFact_InvoicedQty_Update.txt] for session [PLP_SalesOrderLinesFact_InvoicedQty_Update].].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: CMN_1761 [Timestamp Event: [Tue Feb 26 23:46:14 2008]].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: TM_6269 [Error: The session cannot open the parameter file.].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: CMN_1761 [Timestamp Event: [Tue Feb 26 23:46:14 2008]].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: TM_6163 [Error initializing variables and parameters for the paritition.].
ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: CMN_1761 [Timestamp Event: [Tue Feb 26 23:46:14 2008]].

ERROR : TM_6292 : (9081|-1249401152) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: TM_6226 [ERROR: Failed to initialize session [PLP_SalesOrderLinesFact_InvoicedQty_Update]].
ERROR : LM_36320 [Tue Feb 26 23:46:16 2008] : (8588|-1578194000) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update]: Execution failed.
WARNING : LM_36331 : (8588|-1578194000) Session task instance [PLP_SalesOrderLinesFact_InvoicedQty_Update] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [PLP_SalesOrderLinesFact_InvoicedQty_Update] will be failed.
ERROR : LM_36320 : (8588|-1578194000) Workflow [PLP_SalesOrderLinesFact_InvoicedQty_Update]: Execution failed.


Thanks,
Prasad Narvekar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2008
Added on Feb 26 2008
#business-intelligence-applications
17 comments
12,562 views