Trace data configuration

This property specifies a list with one or more values which should be traced during XDM task processing. If multiple values are specified, these should be separated by semicolons. The specified values are reported in a trace data report at the end of a task stage in which the value was detected. Reported are the rows of a table in which one of the specified values occurs in any of the row’s columns, whenever that row is part of an INSERT, UPDATE, DELETE, or SELECT action.

If a specified value is detected in a stage as part of one of the above named actions, then the row in which it occurs is reported in the trace data report at the end of that stage. In the event that a specified value is affected by a modification method, the row in which it occurs is reported in the trace data modification report.

Example

The example uses the following tables to show how this property can be used.

Table 1. TEST.ADDRESS
ID STREET TOWN POSTCODE

1001

21 Smith Street

Newtown

12345

1002

19 Watson Avenue

Newtown

12345

1003

3 Johnson Street

Nottsville

12356

1004

456 Rawson Road

Calderwood

56781

1005

88 South Terrace

Calderwood

56781

1006

125 Langdon Drive

Nottsville

12356
Table 2. TEST.PERSON
ID Last Name First_Name Address

2001

Smith

John

1001

2002

Smith

Mary

1001

2003

Schmidt

Olivia

1002

2004

Williams

Charlotte

1006

2005

Williams

Emil

1006

2006

Williams

Maximilian

1006

2007

Johnson

Philipp

1005

2008

Swindon

Sarah

1004

2009

Schwarz

Michael

1003

Scenario 1:

We have a compatibility table copy task that copies the data from these two tables. The Trace Data Configuration for the task is set to Johnson;Smith.

The resulting trace data report after stage 5 contains the following data:

Schema Table Trace data expression Row data

TEST

ADDRESS

Smith

1001;21 Smith Street;Newtown;12345

TEST

ADDRESS

Johnson

1003;3 Johnson Street;Nottsville;12356

TEST

PERSON

Smith

2001;Smith;John;1001

TEST

PERSON

Smith

2002;Smith;Mary;1001

TEST

PERSON

Johnson

2007;Johnson;Philipp;1005

For stage 6 there should be an equivalent, possibly identical, trace data report.

Scenario 2

The same tables are to be copied. In this case, however, the task also modifies the POSTCODE for Newtown from 12345 to 23456. The modification set used has scope source. The Trace Data Configuration is set to: Johnson;Smith;12345.

When the task is run TraceDataReport for stage 5 contains an extra row:

TEST

ADDRESS

12345

1002;19 Watson Avenue;Newtown;12345

There will now also be a TraceDataModificationReport for stage 5 containing the following data:

Schema Table Trace data expression Row data

TEST

ADDRESS

Smith

1001;21 Smith Street;Newtown;23456

TEST

ADDRESS

12345

1001;21 Smith Street;Newtown;23456

TEST

ADDRESS

12345

1002;19 Watson Avenue;Newtown;23456

Note that the Row data column contains the modified row.