GP Customer Internet Information Field is Overwritten with NULL
Article ID: KB0076864
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.
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.
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.
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:
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
Feedback
Yes
No
Powered by
