Internal Server Error 2119

[former_member230550]

My organization is in the process of upgrading from ADS 8 to ADS 11 (11.10.0.24).

We are getting ADS internal errors in the Windows Event Log, for code that has been running fine on ADS 8. I have been able to reproduce the internal error (2119) with the following SQL.

Windows 2012 Server

ADS 11.10.0.24

Free Tables / DBF

OEM character set

Remote server connection

Deleted records hidden

Date format: DD/MM/YYYY

The error only occurs when the numeric value in the table is zero. When the value is non-zero there is no error.

-- execution block 1

drop table test;

CREATE TABLE TEST (KEYCOL CHAR(5), VALUE NUMERIC(8,0));

INSERT INTO TEST VALUES ('COL1', 0);

select * from test;

-- execution block 2

DECLARE @Cursor1 CURSOR;

DECLARE @OtherRecs NUMERIC(5,0);

OPEN @Cursor1 AS SELECT * FROM TEST WHERE KEYCOL = 'COL1';

WHILE FETCH @Cursor1 DO

   @OtherRecs = (SELECT COUNT(*) FROM TEST WHERE KEYCOL = 'COL1' AND 2 < @Cursor1.VALUE);

END WHILE;

Any tips how I can get the error to stop appearing, as our support teams are complaining about it? Cheers.

[HakanHaslaman]

Will forward this to the engineering and come asap back, if I get any news.