• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Variable Length Strings - Effective Retrieval Size Limit Issue


OK- hopefully someone out there has some insight or solution to my issuehere.

I have a virtual table (database view described as a JDE Table) that has a large Variable Length String (defined as nvarchar(max) or nText).
I created a DD Item to describe this column to JDE as a Variable Length String (Type 20, Class VARLEN) with a defined size of 99999 (FYI size seems to be immaterial to the issue).

The Issue:
In a simple test UBE I can retrieve the values in this field... but only up to 1695 characters. It gets truncated past that point.
Querying the DB View external to JDE has no such issues. The entire string is retrieved.

Any ideas on what could be causing the issue?