Hi Siva,

Could you send more details like your version of Infa (SP if any) and logs if any have been generated.
Also make sure that you haven't received any installation errors/warnings

Regards,
mb

Hi Siva,

Please post the Mapping log, if any.
Probably the session execution fails because it is dependent on the mapping that fails.

Also please post more of the Workflow log if there is anything relevant.

Regards,
mb

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