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
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.
Table 18. Flag 32 Trace File Labels
|
|
Attachment Imported |
Indicates whether the file attachment was encoded, compressed, and copied to the Siebel file server with the new name. |
Attachment (Old) Deleted |
This label applies only to updates and indicates whether an existing file was replaced and deleted. |
Attachment Not Found |
Indicates that the file attachment cannot be found in the input directory. |
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
|