This content has been marked as final.
Show 4 replies
-
1. Re: Unable to login Informatica Admin console
679808 Apr 7, 2009 9:06 AM (in response to 694627)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 -
2. Re: Unable to login Informatica Admin console
694627 Apr 8, 2009 5:11 PM (in response to 679808)Hi Michal,
Thanks for your quick reply. Sorry for the inconvenience, actually i forget to enable Java script execution in my IE. Now my admin console working fine.
I have installed Informatica 8.1.1, As of now I'm facing the problem with data loading in Oracle DB. Informatica gave the below mentioned error msg when i was running the workflow which contain tables (Src & Trg) in Oracle 9i.
Error Code : 36401
+Error Msg: Session task instance [[ses_name]]: Exectuion terminated unexpectedly.+
I can load data in DB2 database without any issue. Plz let me know what i should do to load data in Oracle DB.
Thanks,
Siva -
3. Re: Unable to login Informatica Admin console
679808 Apr 13, 2009 8:20 AM (in response to 694627)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 -
4. Terminated with Error-36401.(Informatica -8.6)
772497 Jun 24, 2010 7:25 AM (in response to 679808)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