Error in Log_DataTransformation "Error Msg: Incorrect syntax near ','. Line Number: 3"
book
Article ID: 188871
calendar_today
Updated On:
Products
Information Centric AnalyticsData Loss Prevention Core Package
Issue/Introduction
Error in Log_DataTransformation "Error Msg: Incorrect syntax near ','. Line Number: 3"
Integration Data does not get populated into the RiskFabric database as expected
Environment
6.5.x
Cause
When a Data Source query is created then later modified to have different columns, both the old and new columns remain in the staging table.
This error occurs when the Integration Mapping that is using the Data Source is not updated to match the new columns that were defined in the Data Source Query
Resolution
There are two ways to resolve this:
Edit the Integration Mapping to make sure that all columns being mapped are part of the current Data Source Query.
Delete the existing Integration Mapping and Data Source Query and recreate them so that only the desired columns are listed as options