Resolve "Internal error: Access violation" error of AMT in Sagent Data Flow
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
