GP Customer Internet Information Field is Overwritten with NULL
book
Article ID: KB0076864
calendar_today
Updated On:
Products
Versions
TIBCO Scribe Insight
7.9.3
Description
We have a DTS where one of the steps inserts or updates the customer email address in Microsoft Dynamics GP. When we add an email address to the CC field in the UI, the CC field is overwritten with a NULL value each time the DTS runs.
Resolution
Verify Force_Update_Preseek is set to "Y" in the GP metadata for the Internet Information entity.
This issue was fixed in TIBCO Scribe® Insight Adapter For Dynamics GP version 4.4.3, available with TIBCO Scribe® Insight version 7.9.3. Please see release notes Resolved Issues for detail regarding D28392: Release Notes - Scribe Adapter For Dynamics GP
To resolve for prior versions, run the following SQL script in the GP company database, substituting the GP company database name for "TWO":
UPDATE [TWO].[dbo].[KSYNCOBJECTS] SET [FORCE_UPDATE_PRESEEK] = 'Y' WHERE [TABLENAME] = 'Internet Information'
This prevents overwriting the field(s) when the fields are not mapped. The GP Metadata information is stored in the KSYNC tables in each GP company database.
Ensure the DTS step operation is either “Update” or “Update/Insert”.
This symptom can occur when operation is set to “Insert/Update”
Steps to change the operation:
Open DTS and go to Configure Steps
Select the Step with the Internet Information Insert/Update
Select the Operations tab
Click on the dropdown arrow and change the operation from "Insert/Update" to “Update/Insert"
Save the DTS
Issue/Introduction
This article provides resolution steps when running a DTS with the TIBCO Scribe® Insight Adapter For Dynamics GP entity “Internet Information” overwrites existing values with NULL.