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 9.0.1 Repository Service Shutdown Error when Running ETL in DAC

Sheng Lv-OracleAug 10 2011 — edited Aug 12 2011
Hi All,

When I executed the ETL in DAC client for full data load, I got this error from log "PLP_LoyMemberTierMovementQtrAggr.log".
"Failed to connect to the repository on Host : hkhgc01dvapp01, Port : 6315. System Error (errno = 111): Connection refused.)"

Does it relate to the "Minimun Port Number" and "Maximun Port Number", I set both of them to 6315 in the node01's "Advanced Properties".

Here list the full log:
INFO : LM_36435 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Starting execution of workflow [PLP_LoyMemberTierMovementQtrAggr] in folder [PLP] last saved by user [Administrator].
INFO : LM_44206 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Workflow PLP_LoyMemberTierMovementQtrAggr started with run id [481], run instance name [], run type [Concurrent Run Disabled].
INFO : LM_44195 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Workflow [PLP_LoyMemberTierMovementQtrAggr] service level [SLPriority:5,SLDispatchWaitTime:1800].
INFO : VAR_27085 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Parameter file [u01/app/oracle/biapps/dev/Informatica/9.0.1/server/infa_shared/Temp/PLP_LoyMemberTierMovementQtrAggr_5U627E] is opened for [workflow [PLP_LoyMemberTierMovementQtrAggr]].
INFO : LM_44253 : (19218|1327462720) Workflow started. Clients will be notified
INFO : LM_36330 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Start task instance [Start]: Execution started.
INFO : LM_36318 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Start task instance [Start]: Execution succeeded.
INFO : LM_36505 : (19218|1327462720) Link [Start --> PLP_LoyMemberTierMovementQtrAggr]: empty expression string, evaluated to TRUE.
INFO : LM_36388 [Tue Aug 02 17:03:02 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] is waiting to be started.
INFO : LM_36682 [Tue Aug 02 17:03:02 2011] : (19218|1344248128) Session task instance [PLP_LoyMemberTierMovementQtrAggr]: started a process with pid [19492] on node [node01_hkhgc01dvapp01].
INFO : LM_36330 [Tue Aug 02 17:03:02 2011] : (19218|1344248128) Session task instance [PLP_LoyMemberTierMovementQtrAggr]: Execution started.
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [TM_6793 Fetching initialization properties from the Integration Service. : (Tue Aug 02 17:03:03 2011)]
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [DISP_20305 The [Preparer] DTM with process id [19492] is running on node [node01_hkhgc01dvapp01].
: (Tue Aug 02 17:03:03 2011)]
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [PETL_24036 Beginning the prepare phase for the session.]
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [TM_6721 Started [Connect to Repository].]
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [TM_6722 Finished [Connect to Repository]. It took [1.89204] seconds.]
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [TM_6794 Connected to repository [Oracle_BI_DW_Base] in domain [Domain_hkhgc01dvapp01] as user [Administrator] in security domain [Native].]
INFO : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [TM_6721 Started [Fetch Session from Repository].]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:03:05 2011]]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_51490] Communication with client application on host [10.32.64.75] and port [6315] has failed because of network errors. [System Error (errno = 11): Resource temporarily unavailable].)]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:03:05 2011]]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12014 An error occurred while accessing the repository]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:03:05 2011]]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error (Connection to the Repository Service [Oracle_BI_DW_Base] is broken.)]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:03:05 2011]]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_55101] Connection to the Repository Service [Oracle_BI_DW_Base] is broken.)]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:03:05 2011]]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_55114] Reconnecting to the Repository Service [Oracle_BI_DW_Base]. The resilience time is 180 seconds.)]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:03:05 2011]]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_51147] Failed to connect to the repository on Host : hkhgc01dvapp01, Port : 6315. System Error (errno = 111): Connection refused.)]
ERROR : LM_36488 [Tue Aug 02 17:04:09 2011] : (19218|1327462720) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:04:09 2011]]
WARNING : LM_36371 : (19218|1335855424) Workflow [PLP_LoyMemberTierMovementQtrAggr] is aborting.
ERROR : REP_12400 : (19218|1335855424) Repository Error ([REP_12164] Domain-related error: [[DOM_10164] [DOM_10164] Service [Oracle_BI_DW_Base] is disabled in domain [Domain_hkhgc01dvapp01]. [FAULT_PCSFINTERNALEXCEPTION]].)
ERROR : REP_12400 : (19218|1335855424) Repository Error (Failed to connect to repository service [Oracle_BI_DW_Base].)
ERROR : REP_12014 : (19218|1335855424) An error occurred while accessing the repository
ERROR : REP_12400 : (19218|1335855424) Repository Error (Failed to connect to repository service [Oracle_BI_DW_Base].)
ERROR : REP_12400 : (19218|1335855424) Repository Error ([REP_55102] Failed to connect to repository service [Oracle_BI_DW_Base].)
ERROR : LM_36060 : (19218|1335855424) Detected a failure on the repository connection(s).
ERROR : LM_36028 : (19218|1335855424) Failed to get a repository connection.
ERROR : LM_36110 : (19218|1335855424) Folder [id = 8] not found.
ERROR : REP_12400 : (19218|1335855424) Repository Error ([REP_12164] Domain-related error: [[DOM_10164] [DOM_10164] Service [Oracle_BI_DW_Base] is disabled in domain [Domain_hkhgc01dvapp01]. [FAULT_PCSFINTERNALEXCEPTION]].)
ERROR : REP_12400 : (19218|1335855424) Repository Error (Failed to connect to repository service [Oracle_BI_DW_Base].)
ERROR : REP_12014 : (19218|1335855424) An error occurred while accessing the repository
ERROR : REP_12400 : (19218|1335855424) Repository Error (Failed to connect to repository service [Oracle_BI_DW_Base].)
ERROR : REP_12400 : (19218|1335855424) Repository Error ([REP_55102] Failed to connect to repository service [Oracle_BI_DW_Base].)
ERROR : LM_36060 : (19218|1335855424) Detected a failure on the repository connection(s).
ERROR : LM_36028 : (19218|1335855424) Failed to get a repository connection.
ERROR : LM_36110 : (19218|1335855424) Folder [id = 8] not found.
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_55115] Still trying to connect to the Repository Service [Oracle_BI_DW_Base]. The remaining resilience time is 116 seconds.)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:04:15 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_12164] Domain-related error: [[DOM_10051] [DOM_10051] Service [Oracle_BI_DW_Base] is not available in domain [Domain_hkhgc01dvapp01]. [FAULT_PCSFTIMEOUTEXCEPTION]].)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:05:16 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_55115] Still trying to connect to the Repository Service [Oracle_BI_DW_Base]. The remaining resilience time is 49 seconds.)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:05:23 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_12164] Domain-related error: [[DOM_10051] [DOM_10051] Service [Oracle_BI_DW_Base] is not available in domain [Domain_hkhgc01dvapp01]. [FAULT_PCSFTIMEOUTEXCEPTION]].)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:06:06 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_55112] Unable to connect to the Repository Service [Oracle_BI_DW_Base] since the resilience time is up.)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:06:06 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error (Failed to connect to repository service [Oracle_BI_DW_Base].)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:06:06 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12014 An error occurred while accessing the repository]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:06:06 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error (Failed to connect to repository service [Oracle_BI_DW_Base].)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:06:06 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [REP_12400 Repository Error ([REP_55102] Failed to connect to repository service [Oracle_BI_DW_Base].)]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [CMN_1761 Timestamp Event: [Tue Aug 02 17:06:06 2011]]
ERROR : LM_36488 [Tue Aug 02 17:09:24 2011] : (19218|1335855424) Session task instance [PLP_LoyMemberTierMovementQtrAggr] : [TM_6224 Failed to fetch session information from the repository in folder [PLP] for session [PLP_LoyMemberTierMovementQtrAggr.PLP_LoyMemberTierMovementQtrAggr]...Unable to Fetch Mapping associated with the session
.]
ERROR : LM_44131 : (19218|1335855424) Failed to process the handle prepare done request for task [Session task instance [PLP_LoyMemberTierMovementQtrAggr]] since the task is in a terminating state.
WARNING : LM_36322 [Tue Aug 02 17:09:34 2011] : (19218|1361033536) Session task instance [PLP_LoyMemberTierMovementQtrAggr]: Execution aborted.
WARNING : LM_36322 [Tue Aug 02 17:09:35 2011] : (19218|1361033536) Workflow [PLP_LoyMemberTierMovementQtrAggr]: Execution aborted.



Could any one help, thank you very mcuh!

Best regards,
Ryan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2011
Added on Aug 10 2011
#business-intelligence-applications
8 comments
6,447 views