4 Replies Latest reply on Jun 24, 2010 7:25 AM by 772497

    Unable to login Informatica Admin console

    694627
      Hi All,

      I have installed Informatica Server and Client successfully. But i'm not able to login Admin console for Informatica. i could see the webpage but when i click the login button with the domain username and password, its keep loading........

      Plz help me on this, i installed Informatica in Win 2003 and repository created on Oracle 9i..



      Thanks in advance,
      Siva
        • 1. Re: Unable to login Informatica Admin console
          679808
          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
            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
              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
                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