1 2 Previous Next 17 Replies Latest reply on May 30, 2017 1:15 PM by Sreedhar Vecireddy

    First Error Code: 36401.....Execution Terminated Unexpectedly

    siva k New Member

      Hi,

       

      I am getting below error even for a simple pass through mapping.

      First Error Code: 36401

      First Error: Session task instance<s_test> : Execution Terminated Unexpectedly

       

      Informatica Version: 8.6

      Source and Target are imported using DataDirect 5.2:Oracle Wired Protocol

      OS: Windows 2003

       

      wkf and session logs are initializing and creating as well.but apart from the above error i could not see any other error messages in logs.

      i tried to check the pmserver logs for any clue of this problem but unfortunately could not able to figure out such kind of file anywhere.

       

      Please suggest me...............................

       

       

      Session Log:

      Severity    Timestamp    Node    Thread    Message Code    Message

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6228    Writing session output to log file [E:\Informatica\server\infa_shared\SessLogs\s_test.log].

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6014    Initializing session [s_test] at [Tue Mar 10 00:24:36 2009].

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6683    Repository Name: [INFATEST]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6684    Server Name: [INTSER1]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6686    Folder: [Training]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6685    Workflow: [w_s_test] Run Instance Name: [] Run Id: [244]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6101    Mapping name: m_test [version CheckedOut].

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6964    Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    DIRECTOR    TM_6703    Session [s_test] is run by 32-bit Integration Service  [node01_sony-5cb494xs2k], version [8.6.0 HotFix5], build [1125].

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MANAGER    PETL_24058    Running Partition Group [1].

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MANAGER    PETL_24000    Parallel Pipeline Engine initializing.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MANAGER    PETL_24001    Parallel Pipeline Engine running.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MANAGER    PETL_24003    Initializing session run.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    CMN_1569    Server Mode: [ASCII]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    CMN_1570    Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TM_6151    The session sort order is [Binary].

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TM_6156    Using low precision processing.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TM_6180    Deadlock retry logic will not be implemented.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TM_6307    DTM error log disabled.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TE_7022    TShmWriter: Initialized

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TM_6007    DTM initialized successfully for session [s_test]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    DIRECTOR    PETL_24033    All DTM Connection Info: [<NONE>].

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MANAGER    PETL_24004    PETL_24004 Starting pre-session tasks. : (Tue Mar 10 00:24:37 2009)

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MANAGER    PETL_24027    PETL_24027 Pre-session task completed successfully. : (Tue Mar 10 00:24:37 2009)

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    DIRECTOR    PETL_24006    Starting data movement.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    MAPPING    TM_6660    Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    READER_1_1_1    DBG_21438    Reader: Source is [TSTWRHS], user [SCOTT]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    READER_1_1_1    BLKR_16003    Initialization completed successfully.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    WRITER_1_*_1    WRT_8147    Writer: Target is database [TSTWRHS], user [SCOTT], bulk mode [OFF]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    WRITER_1_*_1    WRT_8124    Target Table T_AGG :SQL INSERT statement:

      INSERT INTO T_AGG(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?)

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    WRITER_1_*_1    WRT_8124    Target Table T_AGG :SQL UPDATE statement:

      UPDATE T_AGG SET ENAME = ?, JOB = ?, MGR = ?, HIREDATE = ?, SAL = ?, COMM = ?, DEPTNO = ? WHERE EMPNO = ?

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    WRITER_1_*_1    WRT_8124    Target Table T_AGG :SQL DELETE statement:

      DELETE FROM T_AGG WHERE EMPNO = ?

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    WRITER_1_*_1    WRT_8270    Target connection group #1 consists of target(s) [T_AGG]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    WRITER_1_*_1    WRT_8003    Writer initialization complete.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    READER_1_1_1    BLKR_16007    Reader run started.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    READER_1_1_1    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]

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    READER_1_1_1    RR_4049    RR_4049 SQL Query issued to database : (Tue Mar 10 00:24:37 2009)

       

      Workflow Log:

       

      Severity    Timestamp    Node    Thread    Message Code    Message

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36435    Starting execution of workflow [w_s_test] in folder [Training] last saved by user [admin].

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_44206    Workflow w_s_test started with run id [244], run instance name [], run type [Concurrent Run Disabled].

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_44195    Workflow [w_s_test] service level [SLPriority:5,SLDispatchWaitTime:1800].

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_44253    Workflow started. Clients will be notified

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36330    Start task instance [Start]: Execution started.

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36318    Start task instance [Start]: Execution succeeded.

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36505    Link [Start --> s_test]: empty expression string, evaluated to TRUE.

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36388    Session task instance [s_test] is waiting to be started.

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36682    Session task instance [s_test]: started a process with pid [3176] on node [node01_sony-5cb494xs2k].

      INFO    3/10/2009 12:24:33 AM    node01_sony-5cb494xs2k    8128    LM_36330    Session task instance [s_test]: Execution started.

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6793 Fetching initialization properties from the Integration Service. : (Tue Mar 10 00:24:35 2009)]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [DISP_20305 The [Preparer] DTM with process id [3176] is running on node [node01_sony-5cb494xs2k].

      : (Tue Mar 10 00:24:36 2009)]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [PETL_24036 Beginning the prepare phase for the session.]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6721 Started [Connect to Repository].]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6722 Finished [Connect to Repository].  It took [0.3125] seconds.]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6794 Connected to repository [INFATEST] in domain [Domain_sony-5cb494xs2k] as user [admin] in security domain [Native].]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6721 Started [Fetch Session from Repository].]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6722 Finished [Fetch Session from Repository].  It took [0.296875] seconds.]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6721 Started [Partition Group Formation].]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6722 Finished [Partition Group Formation].  It took [0.046875] seconds.]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [PETL_24037 Finished the prepare phase for the session.]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Tue Mar 10 00:24:36 2009)]

      INFO    3/10/2009 12:24:36 AM    node01_sony-5cb494xs2k    8124    LM_36488    Session task instance [s_test] : [TM_6228 Writing session output to log file [E:\Informatica\server\infa_shared\SessLogs\s_test.log].]

      ERROR    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    8144    LM_36320    Session task instance [s_test]: Execution failed.

      INFO    3/10/2009 12:24:37 AM    node01_sony-5cb494xs2k    8144    LM_36318    Workflow [w_s_test]: Execution succeeded.

       

       

      Thanks in advance!

      Siva

        1 2 Previous Next