Example Log File for Transaction Merger

For the example in this topic, the remote client is SADMIN and the DX file is 00000009.dx. The VALUES line contains a series of question marks and each question mark is bound to a parameter value. The line that displays immediately following the line that contains the question marks includes the value for each question mark. For example:

INSERT INTO dbo.S_EMPLOYEE(NAME, AGE, SEX)
VALUES(?,?,?)
NAME:  Bill
AGE:  40
SEX:  M

Example Log File

The following text is an example of a log file for Transaction Merger:

[TRC35] >>> Processing Client: SADMIN

[TRC35] File: C:\siebel\ses\siebsrvr\docking\SADMIN\inbox\00000009.dx

[TRC33] 2017-03-04 12:09:51 Client: SADMIN, File: 
C:\siebel\ses\siebsrvr\docking\SADMIN\inbox\00000009.dx.

[DBG33] 2017-03-04 12:09:51 Message: Generated SQL statement:,

Additional Message: SQLExecute: INSERT INTO dbo.S_OPTY_PROD_X (ATTRIB_01, ATTRIB_02, 
ATTRIB_03, ATTRIB_04, ATTRIB_05, ATTRIB_06, ATTRIB_07, ATTRIB_08, ATTRIB_09, 
ATTRIB_10, ATTRIB_11, ATTRIB_12, CONFLICT_ID, CREATED, CREATED_BY, LAST_UPD, 
LAST_UPD_BY, MODIFICATION_NUM, PAR_ROW_ID, ROW_ID)

VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[DBG33] 2017-03-04 12:09:51 Message: Error: An ODBC error occurred,

Additional Message: Function: DICInsRowExecStmt; ODBC operation: SQLExecute

For more information, see Naming Conventions for Log Files.