Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

error 2147217833

(0) ShareShare
ReportReport
Posted on by 690

Good day all I currently have a client that is getting this error when making a payment to a customer account, any suggestion

>thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: error 2147217833

    same here, if you have a noob that scanned barcode in qty, then you are doomed, you need to update all db tables related to that entry...STUPID MS can't even block that error at the source, it kills me every time,

    also if you run the new Items in Transit you can get it too...i get -2147217900 Invalid length parameter passed to the SUBSTRING function...

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: error 2147217833

    All errors in RMS return you to the Desktop.

  • Craig Harris Profile Picture
    Craig Harris 795 on at
    Re: error 2147217833

    Just installed SP4 and HotFix 31.  Customer received the following error when attempting to edit a QUANTITY ORDERED amount on a PO.   I have screenshots and it appears that a scanning error placed a "barcode" number (076208450) where the Quantity Ordered should be. The Error 2147217833 occured when the customer attempted to edit the large value back to a value of 24.  Clicking OK on the error produces a Run-time Error '5'; Invalid procedure call or arguement.  

    Thoughts? or is this simply a "normal" termination because of the rror.

    Thanks,

    Craig

  • Suggested answer
    Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: error 2147217833

    Interesting! That is an ado truncation error, meaning one of the fields is larger that the receiving table's field.

    Maybe Trent can weigh in on this one.

    Silly question, but are there any ';' or ',' or ':' in the customer info? These can cause a skip to the next field and confuse sql server, and although RMS does a pretty good job on handling this stuff, you never know.

    -Jerry

    jerry@jrdata.us

  • Clint Skog Profile Picture
    Clint Skog on at
    Re: error 2147217833

    What is the entire Error Message?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: error 2147217833

    Not enough info, but start with doing a database re-index and a database check in Admin.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans