0 Replies Latest reply on Jun 24, 2010 7:26 AM by 772497

    Terminated with Error-36401.(Informatica -8.6)

    772497
      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