Skip to Content
author's profile photo Former Member
Former Member

Internal Server Error 2119

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 03, 2016 at 10:00 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.