Error In TIBCO Scribe® Online When Storing DateTime Data In Dynamics CRM
Article ID: KB0078649
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
When using Dynamics CRM as a target, the following error is generated if DateTime data from the source contains milliseconds:
Error reported in Scribe Online: Unable to get the next page of data. Dynamics CRM has not advanced the page cookie for Entity:
Error reported in Scribe Online: Unable to get the next page of data. Dynamics CRM has not advanced the page cookie for Entity:
Issue/Introduction
When using Dynamics CRM as a target, an error is generated if DateTime data from the source contains milliseconds.
Resolution
Options to resolve this error:
NOTE: Any option that truncates the milliseconds in a DateTime field affects the Most Recent Record Processed setting. That setting is based on the date and time of the last record processed by the Map. If milliseconds are truncated, some records may be processed again on a subsequent execution of your Map.
Note: Microsoft Dynamics CRM is now known as Microsoft Dynamics 365.
- If you are using Dynamics CRM Online, best practice is to contact Microsoft to help resolve the issue.
- If you are using Dynamics CRM On Premise, best practice is to work with their CRM and/or SQL expert to resolve this matter.
- Use a formula in the target field for the Field mappings in your Map to truncate the DateTime data so it no longer contains milliseconds. For example, you could use the DATE and DATEPART functions, as shown below, to extract only the portions of the original DateTime stamp that are needed.
DATE ( DATEPART ("yyyy",lead.createdon), DATEPART ("m",lead.createdon), DATEPART ("d",lead.createdon), DATEPART (“h”,lead.createdon), DATEPART (“n”,lead.createdon), DATEPART (“s”,leadcreatedon) )
NOTE: Any option that truncates the milliseconds in a DateTime field affects the Most Recent Record Processed setting. That setting is based on the date and time of the last record processed by the Map. If milliseconds are truncated, some records may be processed again on a subsequent execution of your Map.
Note: Microsoft Dynamics CRM is now known as Microsoft Dynamics 365.
For additional information, see the following in the TIBCO Scribe® Online Help: TIBCO Scribe Online Connector For Microsoft Dynamics 365, DATE Function, DATEPART Function, Most Recent Record Processed
Feedback
Yes
No
Powered by
