Data Map SQL Missing or Blank

Issue:
Upon constructing a new data map, either by injection or manually typing, the feed will not execute with success. When trying to print the SQL to trouble shoot the data map, no SQL is generated.

See example:

Cause:
This issue is caused by nulls in the "Advanced_Transformation" field in the CONFIG_DMAP table.

Solution:
For the given feed, populate the "Advanced_Transformation" field in table CONFIG_DMAP table with a value of "None".   You can use the following SQL Statement:

update CONFIG_DMAP
set Advanced_Transformation = 'None'
where isnull(Advanced_Transformation, 'Y') = 'Y'


To prevent this from happening again, in SQL Server, goto:
Tables -> dbo.CONFIG_DMAP -> Constraints

Ensure the constraint "DF_CONFIG_DMAP_Advanced_Transformation" is in place. If it is missing, run the following script on the BPMC database to add it:

ALTER TABLE [dbo].[CONFIG_DMAP] ADD CONSTRAINT [DF_CONFIG_DMAP_Advanced_Transformation] DEFAULT ('None') FOR [Advanced_Transformation]
GO

This will ensure a value of "None" is always populated.