Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / kingsway error SSIS pa...
Microsoft Dynamics CRM (Archived)

kingsway error SSIS package

(0) ShareShare
ReportReport
Posted on by sdnd2000 2,397

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

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    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. 

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: kingsway error SSIS package

    Hi declan.mahon@transforminglives.co.uk,

    It is the default solution

    pastedimage1666688655477v1.png

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: kingsway error SSIS package

    Where can you find the SDK Message Processing Steps?

  • Verified answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    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.

  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: kingsway error SSIS package

    Yes, in plugin registration tool.

  • sdnd2000 Profile Picture
    sdnd2000 2,397 on at
    RE: kingsway error SSIS package

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

  • Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    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

  • Suggested answer
    M I Mostafa Profile Picture
    M I Mostafa 4,257 on at
    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!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans