Siebel Enterprise Integration Manager Administration Guide > Running EIM > Viewing the EIM Log File >

Trace Flag Settings

This topic provides Trace Flag setting information as follows:

• Trace Flag 1
• Trace Flag 2
• Trace Flag 4
• Trace Flag 8
• Trace Flag 32

Trace Flag 1

Setting the Trace Flags parameter to 1 creates a step-oriented log of the task. This can be used to determine the amount of time EIM spends on each step of the EIM task, or for each EIM table processed. The following sample shows an EIM Trace Flag 1 output:

Initializing

Loading configuration file imacct.ifb 0s

Opening server database ora_dev 6s

Loading Siebel dictionary 15s

Initializing 21s

Import Accounts 14

Importing EIM_ACCOUNT

Step 1: initializing IF Table 0s

Step 4: resolving foreign keys S_ORG_EXT 0s

Step 5: locating existing row S_ORG_EXT 0s

Step 7: finding new foreign keys 4s

Step 9: inserting new rows S_ORG_EXT 2s

Importing EIM_ACCOUNT 15s

Updating primaries

Step 10: updating primary keys S_ORG_EXT 3s

Updating primaries 3s

Import Accounts 14 18s

Trace Flag 2

Setting the Trace Flags parameter to 2 creates a file log that traces all substitutions of user parameters. The following example shows an EIM Trace Flag 2 output:

[TRC01] Parameter Set << AFTER RESOLUTION >>

[TRC01] UserParams = IFTABLE=EIM_ACCOUNT

[TRC01] [0] $IFTABLE = EIM_ACCOUNT

[TRC01] [1] $CURRENT_USER = wgong

[TRC01] [2] $CURRENT_DATETIME = 4/6/01 13:17

[TRC01] [Siebel Integration Manager]

[TRC01] log transactions = false

[TRC01] $COLUMN_VALUE = 'EIM ins_acct Test%'

[TRC01] [ins_acct_shell]

[TRC01] TYPE = SHELL

[TRC01] INCLUDE = del_acct

[TRC01] INCLUDE = ins_acct

[TRC01] [del_acct]

[TRC01] SESSIONSQL = DELETE FROM DEV50.EIM_ACCOUNT WHERE IF_ROW_BATCH_NUM=21

[TRC01] TYPE = DELETE

[TRC01] BATCH = 20

[TRC01] TABLE = EIM_ACCOUNT

[TRC01] $COLUMN_NAME = NAME

[TRC01] DELETE MATCHES = EIM_ACCOUNT,(NAME LIKE 'EIM ins_acct Test%')

[TRC01] [ins_acct]

[TRC01] SESSIONSQL = INSERT INTO DEV50.EIM_ACCOUNT (IF_ROW_STAT, ROW_ID, IF_ROW_BATCH_NUM, ACCNT_NAME, ACCNT_LOC) SELECT 'X', ROW_ID, 21, 'EIM ins_acct Test ' || ROW_ID, 'Loc' FROM DEV50.S_SYS_PREF

[TRC01] TYPE = IMPORT

[TRC01] BATCH = 21

[TRC01] TABLE = EIM_ACCOUNT

Trace Flag 4

Setting the Trace Flags parameter to 4 creates a file log that traces all user-key overrides. The following example shows an EIM Flag 4 output for a user key override to the EIM_ACCOUNT table:

[TRC02] ------------------------------------------------------

[TRC02] ***** IF TABLE <EIM_ACCOUNT> uses USER_KEY_COL *****

[TRC02] Action: No Move & Insert

[TRC02] overriding UK Index (S_TERR_ITEM_U1) at position (0)

[TRC02] ##### Destination TABLE (S_TERR_ITEM) index vector: [S_TERR_ITEM_U1]

[TRC02] --- Column (T_TERITE_OUID) index vector: [S_TERR_ITEM_U1]

[TRC02] --- Column (T_TERITE_TERID) index vector: [S_TERR_ITEM_U1]

[TRC02] ------------------------------------------------------

Trace Flag 8

Setting the Trace Flags parameter to 8 creates a file log that traces all Interface Mapping warnings. The following example shows an EIM Flag 8 output for an Interface Mapping warning between the EIM_ACCOUNT and S_TERR_ITEM tables:

[TRC03] --------------------------------------------------------

[TRC03] IF table EIM_ACCOUNT destination S_TERR_ITEM

[TRC03] IF column EIM_ACCOUNT.T_TERITE_TERID:

[TRC03] imports to: S_TERR_ITEM.TERR_ID

[TRC03] exports from: S_TERR_ITEM.TERR_ID

[TRC03] Column NAME of join isn't in table!

[TRC03] Missing join to user key NAME

[TRC03] --------------------------------------------------------

Trace Flag 32

Setting the Trace Flags parameter to 32 creates a file log that traces all file attachment status. The trace file contains four labels, three of which are used to trace file attachment processes as described in Table 18.

The following sample shows an EIM Flag 32 output for an opportunity file attachment:

[TRC32] Attachment Imported: E:\V50\output\openpost.doc -> \\BALTO\SIEBFILE\ORADEV50\S_OPTY_ATT_10+413+1_10-41R-0.saf

[TRC32] Attachment (Old) Deleted: \\BALTO\SIEBFILE\ORADEV50\S_OPTY_ATT_10+413+1_10-40Y-0.saf

[TRC32] Attachment Not Found: E:\V50\output\openpost.doc

[TRC32] Attachment Identical: E:\V50\output\openpost.doc IDENTICAL TO \\BALTO\SIEBFILE\ORADEV50\S_OPTY_ATT_10+413+1_10-41R-0.saf