Product Feature: Advanced Matcher Transform
The user may see following error when executing AMT module:
Cause:
The issue is related to limitation of AMT with the special characters and date field.
Workaround:
Internal error: Access violation [Sagent error code: DC -- 0x1, DC -- 0xD0] {SADCAGNT.EXE - 000000F1 - 12/23/2013 10:36:13.920} Structured Exception: 0xC0000005 Exception occurred at program address 0x0000000042C52545 Attempted to read from location 0x00000000000000AC [Sagent error code: DC -- 0x1, DC -- 0xD0] {SADCAGNT.EXE - 000000F2 - 12/23/2013 10:36:13.920} Error while calculating the output schema for the step 'Advanced Matcher' [Sagent error code: DC -- 0x1, DC -- 0x83] {SADCAGNT.EXE - 000000F3 - 12/23/2013 10:36:13.920}
Cause:
The issue is related to limitation of AMT with the special characters and date field.
Workaround:
- change column name having #, &, / characters in Delimited Text Source in both sources.
- change the data type of 'Insert Date' column to string and 'Ins Revenue' column to decimal with precision 10 & scale 5.
- open AMT and do default mapping.
- click on OK.
- in the plan properties, decimal math option should be checked.
UPDATED:
September 5, 2017