Skip to Main Content

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 session fails

user12295121Dec 29 2009 — edited Jan 13 2010
Hi everybody,
I have problem with Oracle Business Intelligence Applications 7.9.5.1 installed on WinXP, including Informatica 8.1.1. SP5 and DAC 7.9.5.1. I have just installed and configured it just like it is described in installation guide. Now I am trying to make full load, but it fails on "Load into Run Table" Task. In Details I see that Informatica's SIL_InsertRowInRunTable workflow fails. I tried to start it manually in Informatica Workflow Manager or even in console like
pmcmd startworkflow -u Administrator -p **** -s <myhost>:4008 -f SILOS -lpf C:\oracle\bise1\bi\DAC\Informatica\parameters\SILOS.SIL_InsertRowInRunTable.txt SIL_InsertRowInRunTable
The result is the same - it fails.
So it is not a DAC configuration problem.
Moreover, I tried to run some other random workflows in Workflow Manager and the result is the same, so I suppose it is not a problem of a single SIL_InsertRowInRunTable workflow, but something concerning whole Informatica configuration.
My OLTP and OLAP sources are two different Oracle databases and it seems that connections to them both are configured properly in Workflow Manager. At least the same connection string represented by tns_name, schema and pass all together works fine for example in SQLDeveloper. The strange thing is that after a workflow running attempt there is no session log of it.
The workflow log is following:

INFO : LM_36435 [Tue Dec 29 10:17:19 2009] : (5772|5264) Starting execution of workflow [SIL_InsertRowInRunTable] in folder [SILOS] last saved by user [Administrator].
INFO : LM_44195 [Tue Dec 29 10:17:19 2009] : (5772|5264) Workflow [SIL_InsertRowInRunTable] service level [SLPriority:5,SLDispatchWaitTime:1800].
TRACE : LM_36491 [Tue Dec 29 10:17:19 2009] : (5772|5264) The task [Start task instance [Start]] is being initialized for execution.
INFO : LM_36330 [Tue Dec 29 10:17:19 2009] : (5772|5264) Start task instance [Start]: Execution started.
TRACE : LM_36492 [Tue Dec 29 10:17:19 2009] : (5772|5264) The task [Start task instance [Start]] is about to start.
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.Status], Value [STARTED].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.PrevTaskStatus], Value [<null>].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.StartTime], Value [12/29/200910:17:19].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.EndTime], Value [<null>].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.ErrorCode], Value [<null>].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.ErrorMsg], Value [<null>].
TRACE : LM_36493 [Tue Dec 29 10:17:19 2009] : (5772|5264) The task [Start task instance [Start]] is being de-initialized
after execution.
INFO : LM_36318 [Tue Dec 29 10:17:19 2009] : (5772|5264) Start task instance [Start]: Execution succeeded.
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.Status], Value [SUCCEEDED].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.PrevTaskStatus], Value [SUCCEEDED].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.StartTime], Value [12/29/200910:17:19].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.EndTime], Value [12/29/2009 10:17:19].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.ErrorCode], Value [0].
TRACE : LM_36379 : (5772|5264) Workflow [SIL_InsertRowInRunTable]. Variable [$Start.ErrorMsg], Value [].
INFO : LM_36505 : (5772|5264) Link [Start --> SIL_InsertRowInRunTable]: empty expression string, evaluated to TRUE.
TRACE : LM_36491 [Tue Dec 29 10:17:19 2009] : (5772|5264) The task [Session task instance [SIL_InsertRowInRunTable]] is being initialized for execution.
TRACE : LM_44100 : (5772|5264) The task [Session task instance [SIL_InsertRowInRunTable]] is being prepared for execution.
TRACE : LM_44104 : (5772|5264) Successfully submitted the task [Session task instance [SIL_InsertRowInRunTable]] to the load balancer. The task consists of the following requests [Preparer].
INFO : LM_36388 [Tue Dec 29 10:17:19 2009] : (5772|5264) Session task instance [SIL_InsertRowInRunTable] is waiting to be started.
INFO : LM_36682 [Tue Dec 29 10:17:19 2009] : (5772|4712) Session task instance [SIL_InsertRowInRunTable]: started a process with pid [2147483647] on node [node01_myname-mysurname].
INFO : LM_36330 [Tue Dec 29 10:17:19 2009] : (5772|4712) Session task instance [SIL_InsertRowInRunTable]: Execution started.
TRACE : LM_36492 [Tue Dec 29 10:17:19 2009] : (5772|4712) The task [Session task instance [SIL_InsertRowInRunTable]] is about to start.
TRACE : LM_36493 [Tue Dec 29 10:17:19 2009] : (5772|4712) The task [Session task instance [SIL_InsertRowInRunTable]] is being de-initialized after execution.
ERROR : LM_36320 [Tue Dec 29 10:17:19 2009] : (5772|4712) Session task instance [SIL_InsertRowInRunTable]: Execution failed.
TRACE : LM_36379 : (5772|4712) Workflow [SIL_InsertRowInRunTable]. Variable [$SIL_InsertRowInRunTable.Status], Value [FAILED].
TRACE : LM_36379 : (5772|4712) Workflow [SIL_InsertRowInRunTable]. Variable [$SIL_InsertRowInRunTable.PrevTaskStatus], Value [FAILED].
TRACE : LM_36379 : (5772|4712) Workflow [SIL_InsertRowInRunTable]. Variable [$SIL_InsertRowInRunTable.StartTime], Value [12/29/2009 10:17:19].
TRACE : LM_36379 : (5772|4712) Workflow [SIL_InsertRowInRunTable]. Variable [$SIL_InsertRowInRunTable.EndTime], Value [12/29/2009 10:17:19].
TRACE : LM_36379 : (5772|4712) Workflow [SIL_InsertRowInRunTable]. Variable [$SIL_InsertRowInRunTable.ErrorCode], Value [36320].
TRACE : LM_36379 : (5772|4712) Workflow [SIL_InsertRowInRunTable]. Variable [$SIL_InsertRowInRunTable.ErrorMsg], Value [ERROR: Session task instance [SIL_InsertRowInRunTable]: Execution failed.].
WARNING : LM_36331 : (5772|4712) Session task instance [SIL_InsertRowInRunTable] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SIL_InsertRowInRunTable] will be failed.
ERROR : LM_36320 [Tue Dec 29 10:17:19 2009] : (5772|4712) Workflow [SIL_InsertRowInRunTable]: Execution failed.
DEBUG : LM_44202 : (5772|4712) Calling releaseLock() from SWorkFlow::unlockInRepo() with Object Type=Workflow Display Name=SIL_InsertRowInRunTable Extra Name= Repo Conn Id=5
Part of DAC server log concerning the problem:
=====================================
STD OUTPUT
=====================================
Informatica(r) PMCMD, version [8.1.1 SP5], build [135.0129], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2008
All Rights Reserved.
Invoked at Tue Dec 29 10:17:39 2009
Connected to Integration Service at [myname-mysurname:4008]
Folder: [SILOS]
Workflow: [SIL_InsertRowInRunTable] version [4].
Workflow run status: [Failed]
Workflow run error code: [36331]
Workflow run error message: [WARNING: Session task instance [SIL_InsertRowInRunT
able] failed and its "fail parent if this task fails" setting is turned on. So,
Workflow [SIL_InsertRowInRunTable] will be failed.]
Start time: [Tue Dec 29 10:17:19 2009]
End time: [Tue Dec 29 10:17:19 2009]
Workflow log file: [C:\Informatica\PowerCenter8.1.1\server\infa_shared\WorkflowL
ogs\SIL_InsertRowInRunTable.log]
Workflow run type: [User request]
Run workflow as user: [Administrator]
Integration Service: [PowerCenter_Integration_Service]
Disconnecting from Integration Service
Completed at Tue Dec 29 10:17:39 2009
=====================================
ERROR OUTPUT
=====================================
Error Message : Unknown reason for error code 36331
ErrorCode : 36331
29-Dec-2009 10:17:40 com.siebel.etl.engine.core.SessionHandler notifySessionHand
lerOfCompletion
SEVERE: ETL seems to have completed. Invoking shut down dispatcher after the no
tification from the last running task.
16 SEVERE Tue Dec 29 10:17:40 EET 2009 ETL seems to have completed. Invoking
shut down dispatcher after the notification from the last running task.

So, most likely workflow session can not be started, but I can not find the reason of the problem.

Some more usefull information. I have set 4008 port number for integration services, not default 4006. I have done it to avoid some conflicts on 4006 port. I have done it in Informatica admin console and in DAC. I log into Windows as Administrator, so there shouldn't be file permission problems.

Any suggestions?
Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2010
Added on Dec 29 2009
6 comments
7,283 views