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).

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
 

Issue/Introduction

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