Skip navigation
Contact Us
4407 Views 9 Replies Latest reply: Apr 23, 2012 9:14 AM by Surendra GEV RSS
Garima Garg Newbie 4 posts since
Apr 21, 2012
Currently Being Moderated

Apr 21, 2012 12:09 AM

Error 36401: Execution terminated unexpectedly

Hi,

this is the  first time I am facing this error....following are the session logs
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6228 : Writing session output to log file [C:\Informatica\PowerCenter8.6.1\server\infa_shared\SessLogs\s_MAP_BO_EAI_FIN_KSL.log].
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6014 : Initializing session [s_MAP_BO_EAI_FIN_KSL] at [Sat Apr 21 11:23:55 2012].
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6683 : Repository Name: [Repository_ubi]
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6684 : Server Name: [IS_UBI]
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6686 : Folder: [BUSINESSOBJECTS_CUSTOM]
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6685 : Workflow: [WF_test] Run Instance Name: [] Run Id: [12236]
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6101 : Mapping name: MAP_BO_EAI_FIN_KSL_FACT.
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6964 : Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : TM_6703 : Session [s_MAP_BO_EAI_FIN_KSL] is run by 32-bit Integration Service  [node01], version [8.6.1], build [1218].
2012-04-21 11:23:55 : INFO : (2660 | MANAGER) : (IS | IS_UBI) : node01 : PETL_24058 : Running Partition Group [1].
2012-04-21 11:23:55 : INFO : (2660 | MANAGER) : (IS | IS_UBI) : node01 : PETL_24000 : Parallel Pipeline Engine initializing.
2012-04-21 11:23:55 : INFO : (2660 | MANAGER) : (IS | IS_UBI) : node01 : PETL_24001 : Parallel Pipeline Engine running.
2012-04-21 11:23:55 : INFO : (2660 | MANAGER) : (IS | IS_UBI) : node01 : PETL_24003 : Initializing session run.
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : CMN_1569 : Server Mode: [ASCII]
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : CMN_1570 : Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TM_6151 : The session sort order is [Binary].
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TM_6156 : Using low precision processing.
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TM_6180 : Deadlock retry logic will not be implemented.
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TM_6307 : DTM error log disabled.
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TE_7022 : TShmWriter: Initialized
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TM_6007 : DTM initialized successfully for session [s_MAP_BO_EAI_FIN_KSL]
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : PETL_24033 : All DTM Connection Info: [<NONE>].
2012-04-21 11:23:55 : INFO : (2660 | MANAGER) : (IS | IS_UBI) : node01 : PETL_24004 : PETL_24004 Starting pre-session tasks. : (Sat Apr 21 11:23:55 2012)
2012-04-21 11:23:55 : INFO : (2660 | MANAGER) : (IS | IS_UBI) : node01 : PETL_24027 : PETL_24027 Pre-session task completed successfully. : (Sat Apr 21 11:23:55 2012)
2012-04-21 11:23:55 : INFO : (2660 | DIRECTOR) : (IS | IS_UBI) : node01 : PETL_24006 : Starting data movement.
2012-04-21 11:23:55 : INFO : (2660 | MAPPING) : (IS | IS_UBI) : node01 : TM_6660 : Total Buffer Pool size is 1622416 bytes and Block size is 87912 bytes.
2012-04-21 11:23:55 : INFO : (2660 | READER_1_1_1) : (IS | IS_UBI) : node01 : DBG_21438 : Reader: Source is [ubifin], user [appadmin]
2012-04-21 11:23:55 : INFO : (2660 | READER_1_1_1) : (IS | IS_UBI) : node01 : BLKR_16003 : Initialization completed successfully.
2012-04-21 11:23:56 : INFO : (2660 | WRITER_1_*_1) : (IS | IS_UBI) : node01 : WRT_8124 : Target Table eai_fin_ksl_ff :Writing output to: C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\EAI_SOURCE_FILES\eai_fin_ksl_ff1.out
2012-04-21 11:23:56 : INFO : (2660 | WRITER_1_*_1) : (IS | IS_UBI) : node01 : WRT_8222 : Target file [C:\Informatica\PowerCenter8.6.1\server\infa_shared\SrcFiles\EAI_SOURCE_FILES\eai_fin_ksl_ff1.out] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-04-21 11:23:56 : INFO : (2660 | WRITER_1_*_1) : (IS | IS_UBI) : node01 : WRT_8270 : Target connection group #1 consists of target(s) [eai_fin_ksl_ff]
2012-04-21 11:23:56 : INFO : (2660 | WRITER_1_*_1) : (IS | IS_UBI) : node01 : WRT_8003 : Writer initialization complete.
2012-04-21 11:23:56 : INFO : (2660 | READER_1_1_1) : (IS | IS_UBI) : node01 : BLKR_16007 : Reader run started.
2012-04-21 11:23:56 : INFO : (2660 | READER_1_1_1) : (IS | IS_UBI) : node01 : RR_4029 : SQ Instance [SQ_HTD] User specified SQL Query [SELECT SOL.BR_CODE, HTD.TRAN_DATE, HTD.TRAN_ID, HTD.part_tran_srl_num,  BAT.PARTICULARS_3, BAT.PARTICULARS_4, HTD.TRAN_AMT, BAT.PARTICULARS_5, HTD.TRAN_TYPE, HTD.REF_NUM, HTD.TRAN_PARTICULAR,  HTD.TRAN_RMKS, BAT.PARTICULARS_1, BAT.PARTICULARS_2, GAM.FORACID

FROM

HTD, GAM, BAT, HTH,SOL

WHERE

GAM.FORACID='2070000018'

AND HTD.TRAN_DATE=(select db_stat_date -1 from gct)

AND HTD.DEL_FLG<>'Y'

AND HTD.ACID=GAM.ACID

AND HTD.PART_TRAN_TYPE='C'

AND HTD.tran_id = BAT.tran_id

AND BAT.del_flg <>'Y'

AND BAT.schm_code = 'COBRS'

AND BAT.nft_type = 'OAD'

AND BAT.sol_id = '50450'

AND HTD.tran_date = BAT.tran_date

AND to_number(BAT.to_from_br_code) =(select br_code from SOL where sol_id ='50450')

AND HTD.tran_id = HTH.tran_id

AND HTD.tran_date = HTH.tran_date

AND  HTH.init_sol_id =SOL.sol_id]
2012-04-21 11:23:56 : INFO : (2660 | READER_1_1_1) : (IS | IS_UBI) : node01 : RR_4049 : RR_4049 SQL Query issued to database : (Sat Apr 21 11:23:56 2012)
2012-04-21 11:23:56 : INFO : (2660 | WRITER_1_*_1) : (IS | IS_UBI) : node01 : WRT_8005 : Writer run started.
2012-04-21 11:23:56 : INFO : (2660 | WRITER_1_*_1) : (IS | IS_UBI) : node01 : WRT_8158 :

*****START LOAD SESSION*****

Load Start Time: Sat Apr 21 11:23:56 2012

Target tables:

     eai_fin_ksl_ff

 

 

Since yesterday evening I am trying to execute it but not able to do so......plz help me

Regards
Garima

More Like This

  • Retrieving data ...

Bookmarked By (0)