Unanswered

Error message with Kingsway Software Connection Manager

(0) Share

Report

Posted on by PietPoelsma

Hi,

I'm using Kingsway Software to integrate between Dataverse and SSIS/SQL Server on premise. I have been able to create a connection manager. I created a Dataflow in which I have SQL Server as source and Dataverse as destination (with Kingsway Software).

I get the following error message while executing:

Error: 0xC0047062 at Data Flow Task, Dynamics CRM Destination [2]: KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity 'cr474_shpkpi_values_extended': CRM service call returned an error: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest) ---> KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest) ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
at System.Net.HttpWebRequest.GetResponse()
at myv.oxl.mko()
at nnk.slp[cs](Func`1 mpk, Int32 mpl, nnl mpm, Boolean mpn)
at myv.gvv()
at myv.gvs()
at nim.hdh(Boolean mpk, Nullable`1 mpl)
at nim.sqx.swz()
at nnk.slo[cs](Func`1 mpk, Func`2 mpl, Int32 mpm, nnl mpn)
--- End of inner exception stack trace ---
at nnk.slo[cs](Func`1 mpk, Func`2 mpl, Int32 mpm, nnl mpn)
at nim.hdc(OrganizationRequest mpk, Boolean mpl, Nullable`1 mpm, PipelineComponent mpn, Nullable`1 mpo, Int32 mpp)
at nim.hcd(String mpk, Boolean mpl)
--- End of inner exception stack trace ---
at nim.hcd(String mpk, Boolean mpl)
at nim.hbl(String mpk, Boolean mpl, Boolean mpm)
at nim.vnm(String mpk)
at nim.voj(myz mpk)
at KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmDestinationComponent.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@PietPoelsma

How are you authenticating the connection Manager? Did the Test connection succeed?

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report

Hi @Mira_Ghaly

Thanks for responding!
Authentication Method: OAuth
Test Connection was successful.

Kind regards,
Piet

Was this reply helpful? Yes No
Gowri Halan 262 on at

Like (0)

Report

Hi @PietPoelsma Check if the entity schema name is correct. error says Tool could not find metadata of entity you provided.

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report

Hi @gowrihalan04 ,

Tanks for your response.

I can't see how I could get the wrong schema name, as the table name has picked from a drop down list. Also when I try to map the columns, I get all the column names from the destination table in the Dataverse, so the meta data can be read, as you can see below

Kind regards,
Piet

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @PietPoelsma,

Can you try clicking the Refresh Metadata button on the destination component? You'll want to do that any time there may have been changes to that table in Dataverse.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report

Hi @ChrisPiasecki

Thanks for your response.

I indeed tried that without success unfortunately...

Best regards,

Piet

Was this reply helpful? Yes No
Verified answer

PietPoelsma 67 on at

Like (1)

Report

Thanks all for replying, I finally found the solution. The issue was in a Security Setting, Protection Level for the Package. This was set to "Don not save sensitive data", any other setting than that one fixed the issue..

Was this reply helpful? Yes No
Jinddiy 2 on at

Like (0)

Report

Where to find this Project Protection Level ?

Was this reply helpful? Yes No