web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

  • Jeff @ Check Point Software Profile Picture
    13,382 on at

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

  • Clint Skog Profile Picture
    Microsoft Employee on at

    What is the entire Error Message?

  • Suggested answer
    Gerald Rothaus Profile Picture
    2,934 on at

    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

  • Craig Harris Profile Picture
    797 on at

    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

  • Jeff @ Check Point Software Profile Picture
    13,382 on at

    All errors in RMS return you to the Desktop.

  • Community Member Profile Picture
    on at

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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans