Unable to import SQL BLOB to CRM Contact entity image field

Unable to import SQL BLOB to CRM Contact entity image field

book

Article ID: KB0078581

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight CRM Adapter 5.5.5

Description

Import of SQL BLOB field to CRM Contact entity image field is failing with no error message displayed.

Issue:  I am trying to move an image from a SQL BLOB field to the Dynamics CRM Contact "entityimage" field.  There are no errors when the DTS runs, but the image does not display in CRM.  When I open the DTS in the TIBCO Scribe® Insight Workbench, I notice the CRM contact "entityimage" field Type/Length is nchar(150).

Issue/Introduction

Import of SQL BLOB field to CRM Contact entity image field is failing with no error message displayed.

Resolution

This issue can occur when the “Primary image” attribute for the Contact entity in CRM is set to [None].

Steps to resolve:
  1. Modify CRM contact PrimaryImageAttribute:
  • Login to CRM and navigate to Customizations
  • Select the Contact entity
  • In the Entity Definition window, from the Primary Image dropdown list, choose “Entity image”
  • Save and Publish customizations.

kA20e000000fxURCAY_en_US_1_0
 
  1. Clear and reset the Scribe CRM metadata
  • In SQL Management Studio, select SCRIBEINTERNAL database
  • Select the ADAPTERMETADATA table  >  Select top 1000 rows
  • Find the “IDENTIFIER” column value for your CRM connection
  • Run the following query:
                DELETE FROM [SCRIBEINTERNAL].[SCRIBE].[ADAPTERMETADATA] WHERE IDENTIFIER != 'your_CRM_Connection_Identifer'
  • Launch the Workbench and open the CRM connections to reload the metadata.

kA20e000000fxURCAY_en_US_1_1
 
Powered by Wolken Software