kingsway error SSIS package

(0) Share

Report

Posted on by sdnd2000

2,510

Hi, I keep getting this error when running the package, anyone knows the details,

[Dynamics CRM Destination [2]] Error: An error occurred with the following error message: "System.Exception: Error(s) occurred when processing the batch: [7] [493981d3-ed97-e711-a81c-005056b5fefa] CRM service call returned an error: Cannot obtain lock on resource:'Incident_493981d3-ed97-e711-a81c-005056b5fefa', mode:Update - stored procedure sp_getapplock returned error code -3. (SSIS Integration Toolkit for Microsoft Dynamics 365, v8.1.0.6275 - DtsDebugHost, v11.0.5583.0)

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

M I Mostafa 4,257 on at

Like (0)

Report

RE: kingsway error SSIS package

Hi,

This to me sounds more like a Kingsway soft error, not a Dynamics error. It might be related to a record being used while your Kingswaysoft Data Import stored procedure is trying to update the same record.

The record is probably a case record (incident) and its Guid is the value starting with 49398xxx

Try to avoid including this record in your import and see if that lets you import the rest of the data or alternatively check if the record is not being used by a user or a Dynamics process (workflow?).

If all of that doesn't work, then you might want to pick this up directly with Kingswaysoft.

Hope this helps!

Was this reply helpful? Yes No
Thomas David Dayman 11,323 on at

Like (0)

Report

RE: kingsway error SSIS package

Hi,

Check these threads out:

community.dynamics.com/.../199750

community.dynamics.com/.../192865

i think its something to do with a plugin or workflow

Was this reply helpful? Yes No
sdnd2000 2,510 on at

Like (0)

Report

RE: kingsway error SSIS package

how do we disable a plugin for time being ? in the registration tool?

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: kingsway error SSIS package

Yes, in plugin registration tool.

Was this reply helpful? Yes No
Verified answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

RE: kingsway error SSIS package

You can also disable the plugin by going to your solution (or default solution), and under SDK Message Processing Steps, select the Plugin message that you want to disable, and click on the Deactivate button.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: kingsway error SSIS package

Where can you find the SDK Message Processing Steps?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

RE: kingsway error SSIS package

Hi declan.mahon@transforminglives.co.uk,

It is the default solution

You can find it using the Plugin Registration tool also.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../

Was this reply helpful? Yes No
Daniel Cai 935 on at

Like (0)

Report

RE: kingsway error SSIS package

Knowing that this is a 5-year old thread, I would like to make a clarification, this error is a platform error rather than a KingswaySoft problem. The error is thrown by the server, KingswaySoft toolkit is simply reporting it.

For your reference, in our recent releases, we have added 4 process optimization options that can be used to temporarily disable plugins, workflows, which might work better for your scenario. Please give that a try before resorting to the disabling and re-enabling of your plugin steps yourself.

Was this reply helpful? Yes No