Error in Log_DataTransformation "Error Msg: Incorrect syntax near ','. Line Number: 3"

Products

• Information Centric Analytics
• Data 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:

1. Edit the Integration Mapping to make sure that all columns being mapped are part of the current Data Source Query.
2. Delete the existing Integration Mapping and Data Source Query and recreate them so that only the desired columns are listed as options