GP Change Data Source Error
Chris.McNierney@fctg.com asked 10 years ago
SmartConnect version 20.12.2.40
Created a map with a GP Change Data Source on the PM Vendor Master File for Create, Update and Delete. Destination is a MS Sql table.
Create and Update events work with no issues.
Delete events get the following error:
"Error processing Tenent SQL Server: xyzServer Database: xyzDB – Incorrect syntax near ')'. Incorrect syntax near ')'."
I have a similar map created over the PM Vendor Address table and all actions work with no issue, including Delete.
Created a map with a GP Change Data Source on the PM Vendor Master File for Create, Update and Delete. Destination is a MS Sql table.
Create and Update events work with no issues.
Delete events get the following error:
"Error processing Tenent SQL Server: xyzServer Database: xyzDB – Incorrect syntax near ')'. Incorrect syntax near ')'."
I have a similar map created over the PM Vendor Address table and all actions work with no issue, including Delete.