Quantcast

36401 error- session Task Instance[m1]:Execution terminated unexpectedly

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

36401 error- session Task Instance[m1]:Execution terminated unexpectedly

susheel_informatica
 I have two tables in source emp and dept and one table in target deptno is the primary field in source tables. I am trying to load both source records in target using source qualifier. Am getting 36401 error. I tried in many ways to get rid of these unfortunately no luck.

Here is the Session Log:-


Severity Timestamp Node Thread Message Code Message
INFO 2/21/2013 9:34:31 PM node01_kool-66997ce0f6 DIRECTOR TM_6228 Writing session output to log file [C:\Informatica\PowerCenter8.6.0\server\infa_shared\SessLogs\m1.log].
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6014 Initializing session [m1] at [Thu Feb 21 21:34:32 2013].
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6683 Repository Name: [rep_01]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6684 Server Name: [int_01]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6686 Folder: [Infa_Training]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6685 Workflow: [wf_m1] Run Instance Name: [] Run Id: [21]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6101 Mapping name: m1.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6964 Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR TM_6703 Session [m1] is run by 32-bit Integration Service  [node01_kool-66997ce0f6], version [8.6.0], build [0612].
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MANAGER PETL_24058 Running Partition Group [1].
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MANAGER PETL_24000 Parallel Pipeline Engine initializing.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MANAGER PETL_24001 Parallel Pipeline Engine running.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MANAGER PETL_24003 Initializing session run.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING CMN_1569 Server Mode: [ASCII]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING CMN_1570 Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TM_6151 The session sort order is [Binary].
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TM_6156 Using low precision processing.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TM_6180 Deadlock retry logic will not be implemented.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TM_6307 DTM error log disabled.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TE_7022 TShmWriter: Initialized
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TM_6007 DTM initialized successfully for session [m1]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR PETL_24033 All DTM Connection Info: [<NONE>].
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MANAGER PETL_24004 PETL_24004 Starting pre-session tasks. : (Thu Feb 21 21:34:32 2013)
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MANAGER PETL_24027 PETL_24027 Pre-session task completed successfully. : (Thu Feb 21 21:34:32 2013)
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 DIRECTOR PETL_24006 Starting data movement.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 MAPPING TM_6660 Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 DBG_21438 Reader: Source is [oracle], user [scott]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 BLKR_16003 Initialization completed successfully.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8147 Writer: Target is database [oracle], user [scott], bulk mode [OFF]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8124 Target Table EMP_BKP :SQL INSERT statement:
INSERT INTO EMP_BKP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,DNAME,LOC)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8124 Target Table EMP_BKP :SQL UPDATE statement:
UPDATE EMP_BKP SET EMPNO = ?, ENAME = ?, JOB = ?, MGR = ?, HIREDATE = ?, SAL = ?, COMM = ?, DNAME = ?, LOC = ? WHERE DEPTNO = ?
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8124 Target Table EMP_BKP :SQL DELETE statement:
DELETE FROM EMP_BKP WHERE DEPTNO = ?
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8270 Target connection group #1 consists of target(s) [EMP_BKP]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8003 Writer initialization complete.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 BLKR_16007 Reader run started.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8005 Writer run started.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8158

*****START LOAD SESSION*****

Load Start Time: Thu Feb 21 21:34:32 2013

Target tables:

     EMP_BKP


INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 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, DEPT.DNAME, DEPT.LOC FROM EMP, DEPT WHERE EMP.DEPTNO = DEPT.DEPTNO]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 RR_4049 RR_4049 SQL Query issued to database : (Thu Feb 21 21:34:32 2013)
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 RR_4050 RR_4050 First row returned from database to reader : (Thu Feb 21 21:34:32 2013)
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 BLKR_16019 Read [14] rows, read [0] error rows for source table [EMP] instance name [EMP]
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 READER_1_1_1 BLKR_16008 Reader run completed.
INFO 2/21/2013 9:34:32 PM node01_kool-66997ce0f6 WRITER_1_*_1 WRT_8167 Start loading table [EMP_BKP] at: Thu Feb 21 21:34:32 2013

Please let me know where is the issue is.

Thanks in advance

Loading...