Skip to main content

Notifications

Customer Service forum
Unanswered

getting error while using the kingsway soft component in SSIS with entity changes options(including lookup columns)

Posted on by 5

Hello,

I am getting issue with CRM kingsway component in SSIS packages . currently  I am updating the CRM configuration from SOAP2011 to WEBAPI .

We are getting issues at source CRM kingsway component in our package . SSIS package is extracting the data from CRM and loading it to SQL table. but In CRM source connection we are using the entity changes source type. and also some columns are lookups . it is failing on each lookup columns with the below error when we try to execute the package. 

[Dynamics CRM Source [1631]] Error: An error occurred with the following error message: "KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest, Detailed Message: {"error":{"code":"0x0","message":"Could not find a property named 'createdbyexternalparty' on type 'Microsoft.Dynamics.CRM.account'."}}) (SSIS Integration Toolkit for Microsoft Dynamics 365, v20.1.1.2391 - DtsDebugHost, v13.0.5888.11)System.Net.WebException

  and below is the snip for CRM connection in ssis package

pastedimage1626437509516v1.png

Please suggest any inputs to resolve this as this needs to be done in our production environment ASAP.

Appreciated if anyone wants to discuss with me   on this . 

Thanks,

Ganesh Kandi 

+91-9553444334

  • Ganesh Kandi Profile Picture
    Ganesh Kandi 5 on at
    RE: getting error while using the kingsway soft component in SSIS with entity changes options(including lookup columns)

    Thanks Prateek for your response.

    we can see all the UNIQUE identifiers are used as lookups in CRM. So we tried to unmap the lookup columns an retriggered the job. still it is failed and the error is going by property by property . and as you said, I tried to unmap the createdbyexternalparty column, even the issue is still there. Below are the list of columns we tried to unmap and rerun . But NO LUCK.

    Thanks,

    Ganesh Kandi

    +91-9553444334

  • prt33k Profile Picture
    prt33k 6,907 on at
    RE: getting error while using the kingsway soft component in SSIS with entity changes options(including lookup columns)

    What are column selected in the source? If createdbyexternalparty is present - did you try removing it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans