News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Dynamics SL 2015 SDK E...

Microsoft Dynamics SL (Archived)

Dynamics SL 2015 SDK Error 9831 - value passed to Sparm is too Large

(0) Share

Report

Report

Posted on by Mark E

6,405

I was doing some development for a custom screen that copies Customer notes over to Sales Orders when saved. Part of the code used a call in which the Snote.sNoteText for the customer is fetched, and passed as a parm to a SQL insert statement into the SNote table. In doing this for larger notes, the following message was returned.

1680.Capture.PNG

I have since figured out a different way to accomplish the notes copy, but never ran into this before. Is there a physical limit to the size of a string parameter? If so, where is it defined?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Erich Strelow F 1,642 on at

Like (0)

Report

RE: Dynamics SL 2015 SDK Error 9831 - value passed to Sparm is too Large

I think the value you are asking is 4000 characters, or 8000 bytes. This is actually an old SQL server limit, not a SL one. It's probably been passed in recent versions, but since SL is varchar-less the limit still applies.

I'm not sure about the behavior with > 4000 long strings, but the worst scenario is truncation, in which case your data will miss all the punchlines. So, the bulletproof message makes sense.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans