Terminated with Error-36401.(Informatica -8.6)
Hi,
Question Tilte : Terminated with Error-36401.(Informatica -8.6)
After starting the Workflow - turnout with an error - 36401
The session log shows upto wrt_8167 and
Workflow log shows an error LM_36320.
Could you please help me in solving this.
Please find some more details
Session log
-------------
2009-05-16 23:50:58 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : DBG_21438 : Reader: Source is [ORCL], user [SCOTT]
2009-05-16 23:51:03 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : BLKR_16051 : Source database connection [SR_SRC] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2009-05-16 23:51:03 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : BLKR_16003 : Initialization completed successfully.
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8147 : Writer: Target is database [ORCL], user [SRY], bulk mode [OFF]
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8221 : Target database connection [SR_TAR] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8124 : Target Table EMP :SQL INSERT statement:
INSERT INTO EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8020 : No column marked as primary key for table [EMP]. UPDATEs Not Supported.
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8270 : Target connection group #1 consists of target(s) [EMP]
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8003 : Writer initialization complete.
2009-05-16 23:51:03 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : BLKR_16007 : Reader run started.
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8005 : Writer run started.
2009-05-16 23:51:03 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8158 :
*****START LOAD SESSION*****
Load Start Time: Sat May 16 23:51:03 2009
Target tables:
EMP
2009-05-16 23:51:03 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : RR_4010 : SQ instance [SQ_EMP] SQL Query [SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO FROM EMP]
2009-05-16 23:51:03 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : RR_4049 : RR_4049 SQL Query issued to database : (Sat May 16 23:51:03 2009)
2009-05-16 23:51:04 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : RR_4050 : RR_4050 First row returned from database to reader : (Sat May 16 23:51:04 2009)
2009-05-16 23:51:04 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : BLKR_16019 : Read [14] rows, read [0] error rows for source table [EMP] instance name [EMP]
2009-05-16 23:51:04 : INFO : (2304 | READER_1_1_1) : (IS | sur_int) : node01_suresh : BLKR_16008 : Reader run completed.
2009-05-16 23:51:04 : INFO : (2304 | WRITER_1_*_1) : (IS | sur_int) : node01_suresh : WRT_8167 : Start loading table [EMP] at: Sat May 16 23:51:04 2009
workflow log
----------------
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6794 Connected to repository [sur_rep1] in domain [Domain_suresh] as user [Administrator] in security domain [Native].]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6721 Started [Fetch Session from Repository].]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6722 Finished [Fetch Session from Repository]. It took [11.1875] seconds.]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6721 Started [Partition Group Formation].]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6722 Finished [Partition Group Formation]. It took [0.1875] seconds.]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [PETL_24037 Finished the prepare phase for the session.]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Sat May 16 23:50:53 2009)]
2009-05-16 23:50:53 : INFO : (2156 | 180) : (IS | sur_int) : node01_suresh : LM_36488 : Session task instance [S_EMP] : [TM_6228 Writing session output to log file [D:\Informatica\server\infa_shared\SessLogs\%%LINK% %].]
2009-05-16 23:51:05 : ERROR : (2156 | 2100) : (IS | sur_int) : node01_suresh : LM_36320 : Session task instance [S_EMP]: Execution failed.
2009-05-16 23:51:05 : INFO : (2156 | 2100) : (IS | sur_int) : node01_suresh : LM_36318 : Workflow [W_EMP]: Execution succeeded.
Please reply to solve the issue
Regards,
G.Suresh