Servicing Director SWBC Insurance Import Event Fails With Error : 'T_SWBC_Ins_Parse: Cannot convert a char value to money'

Servicing Director SWBC Insurance Import Event Fails With Error : 'T_SWBC_Ins_Parse: Cannot convert a char value to money'

'T_SWBC_Ins_Parse: Database Error during Open :
Cannot convert a char value to money.
The char value has incorrect syntax
 

Root Cause:

As part of the SWBC Import process,  the event first truncates the 'raw' date table of all it's contents, then it imports the records as a string into the ImpExpDtl_SWBC_Raw table before parsing them, and moving the records into another work table.
If the raw table, called ImpExpDtl_SWBC_Raw is not completely truncated in the process, this type of error may occur.
 

Environment:

SWBC Insurance Import

Workaround:

As a workaround, you should have your DBA, or someone familiar with SQL databases and SQL Management Studio, truncate the table called ImpExpDtl_SWBC_Raw, and then try to run the event again.

ArticleNumber:

000042432