ExecuteRequest failed: An exception System.FormatException was thrown while trying to convert input value '#ERROR!' to attribute 'productpricelevel.uomid

ExecuteRequest failed: An exception System.FormatException was thrown while trying to convert input value '#ERROR!' to attribute 'productpricelevel.uomid

book

Article ID: KB0078515

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

The error below has been seen on some TIBCO Scribe® Insight systems after importing the TIBCO Scribe® Insight Template for Microsoft Dynamics NAV to Microsoft Dynamics CRM when attempting to integrate Sales Prices from Microsoft Dynamics NAV to Microsoft Dynamics CRM.

ExecuteRequest<retrievemultiplerequest></retrievemultiplerequest> failed: An exception System.FormatException was thrown while trying to convert input value '#ERROR!' to attribute 'productpricelevel.uomid'. Expected type of attribute value: System.Guid. Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

Issue/Introduction

Error seen on some TIBCO Scribe® Insight systems when attempting to integrate Sales Prices from Microsoft Dynamics NAV to Microsoft Dynamics CRM

Resolution

Open the SalesPriceToCRM DTS imported with the template.
Under File > Properties > Target, uncheck the Use Existing Connection flag and save.