In DataServer nvarchar(MAX) vs nvarchar(4000) creating a problem with buffers in ABL query and returning inconsistent results.

In DataServer nvarchar(MAX) is creating a problem with buffers in ABL query and returning inconsistent results where as nvarchar(4000) is returning consistent and expected results while using buffers in the ABL queries.

Jan 9, 2025
Knowledge

Title

URL Name

in-dataserver-nvarchar-max-vs-nvarchar-4000-creating-a-problem-with-buffers-in-abl-query-and-returning-inconsistent-results

Article Number

000268770

Environment

Product:OpenEdge Version:11.7.20 OS: All supported platforms Other:DataServer

Question/Problem Description

In DataServer nvarchar(MAX) vs nvarchar(4000) creating a problem with buffers in ABL query and returning inconsistent results.
An issue where data discrepancies were caused by the SQL column definition being varchar(max) vs varchar(4000).

Steps to Reproduce

Have more than 50 records in any nvarchar(MAX) field in an MSSQL database. Create a new schema holder database and pull the schema to the newly created Progress Schema Holder database. Afterward, when executing an ABL query with buffers, we can notice that data manipulations occur, causing incorrect records or data to be fetched.

Clarifying Information

Error Message

Defect Number

OCTA-71693

Enhancement Number

Cause

Resolution

Fixed version(s): OpenEdge 13.0

The information provided here may reference versions that are not generally available at the time of writing. If any questions, then please contact Technical Support.

Workaround

Can use the DataServer startup parameter
-Dsrv PRGRS_LHDC_CML

EXCLUSIVE-LOCK instead of NO-LOCK in the ABL queries.

Use filters/conditions in the ABL query exactly to fetch the required records which will give the expected data without any discrepancies.

Notes

For further information refer to Progress Article: What does parameter PRGRS_LHDC_CML do ?

Keyword Phrase

Last Modified Date

1/9/2025 9:48 AM

In DataServer nvarchar(MAX) vs nvarchar(4000) creating a problem with buffers in ABL query and returning inconsistent results.

Files(0)

Was this article helpful?

Was this article helpful?

In DataServer nvarchar(MAX) vs nvarchar(4000) creating a problem with buffers in ABL query and returning inconsistent results.

Information

Related Articles