dbg_21699 Severity Timestamp Node Thread Message Code Message INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6014 Initializing session [s_m_MASKED_SID_POC] at [Tue Jan 26 17:52:31 2016]. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6683 Repository Name: [PC_REPO_DEV] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6684 Server Name: [PC_INT_DEV] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6686 Folder: [DEVDATASTORE] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6685 Workflow: [wkf_MASKED_SID_POC] Run Instance Name: [] Run Id: [41] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6101 Mapping name: MASKED_SID_POC [version 1]. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6964 Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6708 Using configuration property [EnableDataEncryption,no] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6708 Using configuration property [StoreHAPersistenceInDB,no] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR TM_6703 Session [s_m_MASKED_SID_POC] is run by 64-bit Integration Service [node_powercenter-dev.umd.edu], version [9.6.1 HotFix3], build [0611]. dbg_21699 How to use it? dbg_21699 INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MANAGER PETL_24058 Running Partition Group [1]. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MANAGER PETL_24000 Parallel Pipeline Engine initializing. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MANAGER PETL_24001 Parallel Pipeline Engine running. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MANAGER PETL_24003 Initializing session run. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING CMN_1569 Server Mode: [UNICODE] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING CMN_1570 Server Code page: [UTF-8 encoding of Unicode] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TM_6151 The session sort order is [Binary]. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TM_6156 Using low precision processing. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TM_6180 Deadlock retry logic will not be implemented. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TM_6187 Session target-based commit interval is [10000]. dbg_21699 PasteShr dbg_21699 INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING SDKS_38029 Loaded plug-in 307600: [PowerExchange bulk reader - Reader plugin [9.6.1 HotFix3] build [0611]]. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING PWXPC_12191 [INFO] The session is running with PowerExchange version [9.6.1]. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING SDKS_38024 Plug-in 307600 initialization complete. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING SDKS_38016 Reader SDK plug-in initialization complete. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TM_6307 DTM error log disabled. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TE_7022 TShmWriter: Initialized INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MAPPING TM_6007 DTM initialized successfully for session [s_m_MASKED_SID_POC] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu DIRECTOR PETL_24033 All DTM Connection Info: []. INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu MANAGER PETL_24004 PETL_24004 Starting pre-session tasks. : (Tue Jan 26 17:52:31 2016) INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu PRE-SESS DBG_21349 No load constraints for Target [DB500_NAM]. It does not reference any primary table from the same active source or transaction generator. dbg_21699 How to get it? dbg_21699 INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu PRE-SESS DBG_21104 Determining truncate order for [DB500_NAM] [instance id:3] INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu PRE-SESS DBG_21531 Truncate order for [DB500_NAM] [instance id:3] determined successfully INFO 1/26/2016 5:52:31 PM node_powercenter-dev.umd.edu PRE-SESS WRT_8365 WRT_8365 Starting truncate for target table [DB500_NAM]. : (Tue Jan 26 17:52:31 2016) INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu PRE-SESS WRT_8022 WRT_8022 Truncate table for table [DB500_NAM] succeeded. : (Tue Jan 26 17:52:32 2016) INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu MANAGER PETL_24027 PETL_24027 Pre-session task completed successfully. : (Tue Jan 26 17:52:32 2016) INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu DIRECTOR PETL_24006 Starting data movement. INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu MAPPING TM_6660 Total Buffer Pool size is 98368 bytes and Block size is 3072 bytes. INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu READER_1_1_1 PWXPC_12057 [INFO] Connecting to PowerExchange with parameters: [DBTYPE [NRDB2] Location [PWXDEV] User Name [oealcs] Compression [N] Encryption Type [N] Encryption Level [1] Pacing Size [0] Interpret as Rows [Y] Confirm Network Write [Y] Offload Processing [N] Retrieve PWX log entries [Y] ] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu READER_1_1_1 PWXPC_10091 [INFO] [PWX-33304 Connection: 128.8.208.120:40776, Type: NRDB2, Task ID: 0, Operation timeout: (-) secs, Heartbeat interval: 30 secs, Session: PC_INT_DEV/wkf_MASKED_SID_POC/s_m_MASKED_SID_POC] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu READER_1_1_1 PWXPC_10091 [INFO] [PWX-33304 Connection: (1), Type: NRDB2, Task ID: 2, Operation timeout: (-) secs, Heartbeat interval: 30 secs, Session: PC_INT_DEV/wkf_MASKED_SID_POC/s_m_MASKED_SID_POC] dbg_21699 How to use it? dbg_21699 INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu READER_1_1_1 PWXPC_10023 [INFO] PowerExchange Bulk Reader prepared SQL statement [SELECT SID,TYPE,NAME_KEY,NAME,NAME_PRFX,NAME_SUFX,TRN_DT,INS_DT,MOD_DT,MOD_USR FROM db_500.nam_NAM] for the group [nam_NAM] in Source Qualifier [AMGDSQ_nam_NAM] for partition #1 INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu READER_1_1_1 PWXPC_10024 [INFO] Partition [1] initialized successfully INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8147 Writer: Target is database [sdc-itad10.umd.edu:1521/itad10_rw], user [informatica], bulk mode [OFF] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8221 Target database connection [informatica@ITAD10] code page: [UTF-8 encoding of Unicode] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8397 Appending output data to file [/export/software/informatica/9.6.1/server/infa_shared/BadFiles/db500_nam1.bad] (initial size [28601]). INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8124 Target Table DB500_NAM :SQL INSERT statement: INSERT INTO DB500_NAM(SID,TYPE,NAME_KEY,NAME,NAME_PRFX,NAME_SUFX,TRN_DT,INS_DT,MOD_DT,MOD_USR) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8124 Target Table DB500_NAM :SQL UPDATE statement: UPDATE DB500_NAM SET NAME_KEY = ?, NAME = ?, NAME_PRFX = ?, NAME_SUFX = ?, TRN_DT = ?, INS_DT = ?, MOD_DT = ?, MOD_USR = ? WHERE SID = ? AND TYPE = ? INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8124 Target Table DB500_NAM :SQL DELETE statement: dbg_21699 PasteShr dbg_21699 DELETE FROM DB500_NAM WHERE SID = ? AND TYPE = ? INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8270 Target connection group #1 consists of target(s) [DB500_NAM] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8003 Writer initialization complete. INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8005 Writer run started. INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8158 *****START LOAD SESSION***** Load Start Time: Tue Jan 26 17:52:32 2016 dbg_21699 How to dowload it? dbg_21699 Target tables: DB500_NAM INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu TRANSF_1_1_1 DBG_21075 Connecting to database [sdc-itad10.umd.edu:1521/itad10_rw], user [informatica] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu READER_1_1_1 DBG_21699 The reader is waiting for the DTM to provide buffer blocks. To improve session performance and to prevent the session from hanging, increase the DTM buffer pool size in the session properties. INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu TRANSF_1_1_1 CMN_1717 Stored procedure [GET_MASKED_SID] uses database connection [Relational:informatica@ITAD10] in code page [UTF-8 encoding of Unicode] INFO 1/26/2016 5:52:32 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8167 Start loading table [DB500_NAM] at: Tue Jan 26 17:52:32 2016 DEBUG 1/26/2016 5:53:33 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8165 TIMEOUT BASED COMMIT POINT dbg_21699 How to get it? dbg_21699 INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu MONITOR TM_6250 Received request to stop [s_m_MASKED_SID_POC] from the LM. The request has been handled. INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu DIRECTOR PETL_24007 Received request to stop session run. Attempting to stop worker threads. INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu MANAGER PETL_24007 Received request to stop session run. Attempting to stop worker threads. INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8333 Rolling back all the targets due to fatal session error. ERROR 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu READER_1_1_1 SDKC_37015 Plug-in Error: IRdrBuffer[groupNum 0] could not obtain a new block due to internal error. ERROR 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu READER_1_1_1 PWXPC_10018 [ERROR] Reader encountered an error during buffer flush ERROR 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu READER_1_1_1 SDKS_38200 Partition-level [AMGDSQ_nam_NAM]: Plug-in #307600 failed in run(). INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8325 Final rollback executed for the target [DB500_NAM] at end of load INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8035 Load complete time: Tue Jan 26 17:56:45 2016 dbg_21699 How to get it for free? dbg_21699 LOAD SUMMARY ============ WRT_8036 Target: DB500_NAM (Instance Name: [DB500_NAM]) WRT_8038 Inserted rows - Requested: 200 Applied: 200 Rejected: 0 Affected: 200 INFO 1/26/2016 5:56:45 PM node_powercenter-dev.umd.edu WRITER_1_*_1 WRT_8043 *****END LOAD SESSION***** dbg_21699