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:
 
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