Error from the session log between Informatica and SAP BI

[Former Member]

HI friends,

I am working extraction from bi by Informatica 8.6.1.

now, I start the process Chain from bi, and I got a error from Informatica's session log.Pls help me to figure out what's going on during me execution.

Severity Timestamp Node Thread Message Code Message

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6228 Writing session output to log file [D:\Informatica\PowerCenter8.6.1\server\infa_shared\SessLogs\s_taorh.log].

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6014 Initializing session [s_taorh] at [Fri Dec 17 11:01:31 2010].

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6683 Repository Name: [RepService_dcinfa01]

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6684 Server Name: [IntService_dcinfa01]

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6686 Folder: [xzTraining]

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6685 Workflow: [wf_taorh] Run Instance Name: [] Run Id: [43]

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6101 Mapping name: m_taorh.

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6964 Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR TM_6703 Session [s_taorh] is run by 32-bit Integration Service [node01_dcinfa01], version [8.6.1], build [1218].

INFO 2010-12-17 11:01:31 node01_dcinfa01 MANAGER PETL_24058 Running Partition Group [1].

INFO 2010-12-17 11:01:31 node01_dcinfa01 MANAGER PETL_24000 Parallel Pipeline Engine initializing.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MANAGER PETL_24001 Parallel Pipeline Engine running.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MANAGER PETL_24003 Initializing session run.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING CMN_1569 Server Mode: [UNICODE]

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING CMN_1570 Server Code page: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TM_6151 The session sort order is [Binary].

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TM_6156 Using low precision processing.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TM_6180 Deadlock retry logic will not be implemented.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING SDKS_38029 Loaded plug-in 300320: [PowerExchange for SAP BW - OHS reader plugin 8.6.1 build 183].

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING SDKS_38024 Plug-in 300320 initialization complete.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING PCCL_97003 [WARNING] Real-time session is not enabled for source [AMGDSQ_IS_TAORH]. Real-time Flush Latency value must be 1 or higher for a session to run in real time.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING SDKS_38016 Reader SDK plug-in intialization complete.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TM_6307 DTM error log disabled.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TE_7022 TShmWriter: Initialized

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TM_6007 DTM initialized successfully for session [s_taorh]

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR PETL_24033 All DTM Connection Info: [<NONE>].

INFO 2010-12-17 11:01:31 node01_dcinfa01 MANAGER PETL_24004 PETL_24004 Starting pre-session tasks. : (Fri Dec 17 11:01:31 2010)

INFO 2010-12-17 11:01:31 node01_dcinfa01 MANAGER PETL_24027 PETL_24027 Pre-session task completed successfully. : (Fri Dec 17 11:01:31 2010)

INFO 2010-12-17 11:01:31 node01_dcinfa01 DIRECTOR PETL_24006 Starting data movement.

INFO 2010-12-17 11:01:31 node01_dcinfa01 MAPPING TM_6660 Total Buffer Pool size is 1219648 bytes and Block size is 65536 bytes.

INFO 2010-12-17 11:01:31 node01_dcinfa01 READER_1_1_1 OHS_99013 [INFO] Partition 0: Connecting to SAP system with DESTINATION = sapbw, USER = taorh, CLIENT = 800, LANGUAGE = en

INFO 2010-12-17 11:01:32 node01_dcinfa01 READER_1_1_1 OHS_99016 [INFO] Partition 0: BW extraction for Request ID [163] has started.

Edited by: bi_tao on Dec 18, 2010 11:46 AM

[Former Member]

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8167 Start loading table [VENDOR] at: Fri Dec 17 11:01:32 2010

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8168 End loading table [VENDOR] at: Fri Dec 17 11:01:32 2010

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8141

Commit on end-of-data Fri Dec 17 11:01:32 2010

===================================================

WRT_8036 Target: VENDOR (Instance Name: [VENDOR])

WRT_8044 No data loaded for this target

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8143

Commit at end of Load Order Group Fri Dec 17 11:01:32 2010

===================================================

WRT_8036 Target: VENDOR (Instance Name: [VENDOR])

WRT_8044 No data loaded for this target

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8035 Load complete time: Fri Dec 17 11:01:32 2010

LOAD SUMMARY

============

WRT_8036 Target: VENDOR (Instance Name: [VENDOR])

WRT_8044 No data loaded for this target

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8043 ****END LOAD SESSION****

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8006 Writer run completed.

INFO 2010-12-17 11:01:33 node01_dcinfa01 MANAGER PETL_24031

• RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****

Thread [READER_1_1_1] created for [the read stage] of partition point [AMGDSQ_IS_TAORH] has completed. The total run time was insufficient for any meaningful statistics.

Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [AMGDSQ_IS_TAORH] has completed. The total run time was insufficient for any meaningful statistics.

Thread [WRITER_1_*_1] created for [the write stage] of partition point [VENDOR] has completed. The total run time was insufficient for any meaningful statistics.

INFO 2010-12-17 11:01:33 node01_dcinfa01 MANAGER PETL_24005 PETL_24005 Starting post-session tasks. : (Fri Dec 17 11:01:33 2010)

INFO 2010-12-17 11:01:33 node01_dcinfa01 MANAGER PETL_24029 PETL_24029 Post-session task completed successfully. : (Fri Dec 17 11:01:33 2010)

INFO 2010-12-17 11:01:33 node01_dcinfa01 MAPPING SDKS_38025 Plug-in 300320 deinitialized and unloaded with status [-1].

INFO 2010-12-17 11:01:33 node01_dcinfa01 MAPPING SDKS_38018 Reader SDK plug-ins deinitialized with status [-1].

INFO 2010-12-17 11:01:33 node01_dcinfa01 MAPPING TM_6018 The session completed with [0] row transformation errors.

INFO 2010-12-17 11:01:33 node01_dcinfa01 MANAGER PETL_24002 Parallel Pipeline Engine finished.

INFO 2010-12-17 11:01:33 node01_dcinfa01 DIRECTOR PETL_24013 Session run completed with failure.

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR TM_6022

SESSION LOAD SUMMARY

================================================

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR TM_6252 Source Load Summary.

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR CMN_1537 Table: [AMGDSQ_IS_TAORH] (Instance Name: [AMGDSQ_IS_TAORH]) with group id[1] with view name [Group1]

Rows Output [0], Rows Affected [0], Rows Applied [0], Rows Rejected[0]

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR TM_6253 Target Load Summary.

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR CMN_1740 Table: [VENDOR] (Instance Name: [VENDOR])

Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR TM_6023

===================================================

INFO 2010-12-17 11:01:34 node01_dcinfa01 DIRECTOR TM_6020 Session [s_taorh] completed at [Fri Dec 17 11:01:33 2010].

[Former Member]

Request ID [163] has started.

INFO 2010-12-17 11:01:32 node01_dcinfa01 WRITER_1_*_1 WRT_8146 Writer: Target is database [infa], user [infa], bulk mode [ON]

INFO 2010-12-17 11:01:32 node01_dcinfa01 WRITER_1_*_1 WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8221 Target database connection [oracle_infa] code page: [UTF-8 encoding of Unicode]

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8124 Target Table VENDOR :SQL INSERT statement:

INSERT INTO VENDOR(PURCH_ORG,INCO1,INCO2,VERKF,ZTERM,VENDOR,OHREQUID,DATAPAKID,RECORD,CURRENCY) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8124 Target Table VENDOR :SQL UPDATE statement:

UPDATE VENDOR SET PURCH_ORG = ?, INCO1 = ?, INCO2 = ?, VERKF = ?, ZTERM = ?, VENDOR = ?, CURRENCY = ? WHERE OHREQUID = ? AND DATAPAKID = ? AND RECORD = ?

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8124 Target Table VENDOR :SQL DELETE statement:

DELETE FROM VENDOR WHERE OHREQUID = ? AND DATAPAKID = ? AND RECORD = ?

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8270 Target connection group #1 consists of target(s) [VENDOR]

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8003 Writer initialization complete.

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8005 Writer run started.

INFO 2010-12-17 11:01:33 node01_dcinfa01 WRITER_1_*_1 WRT_8158

****START LOAD SESSION****

Load Start Time: Fri Dec 17 11:01:32 2010

Target tables:

VENDOR

INFO 2010-12-17 11:01:33 node01_dcinfa01 READER_1_1_1 OHS_99009 [INFO] Partition 0: Reading packet with packet id 1 to 1 from SAP BW.

ERROR 2010-12-17 11:01:33 node01_dcinfa01 READER_1_1_1 OHS_99019 [ERROR] The BW InfoSpoke metadata has changed since it was imported as a BW OHS source definition. Reimport the source definition.

ERROR 2010-12-17 11:01:33 node01_dcinfa01 READER_1_1_1 PCCL_97019 [FATAL] Fatal error occurred while fetching messages.

ERROR 2010-12-17 11:01:33 node01_dcinfa01 READER_1_1_1 SDKS_38200 Partition-level [AMGDSQ_IS_TAORH]: Plug-in #300320 failed in run().