ado.net version 16.0.0.20764 (framework 4.5) Continued to raise for 3 hours (same method call) and them gone.

asked 14 Jul '16, 03:18

shs4u's gravatar image

shs4u
11222
accept rate: 0%

1

So what is your question?

That error (SQLCODE -197) has the following explanation (taken from the docs):

Probable cause

You attempted to perform an operation on the current row of a cursor, but the cursor is not positioned on a row. The cursor is before the first row of the cursor, after the last row, or is on a row that has since been deleted.

(14 Jul '16, 04:03) Volker Barth

not relevant! i am not using cursor :-) Now the problem is more than an odd.

(14 Jul '16, 05:17) shs4u
Replies hidden
2

Maybe it will help if you were to describe some things about 'the method( )' call you are making -OR- if it is on a class of your own design then maybe explain what it is attempting to do.

Under the covers of the .Net Framework APIs, anything that deals with the database will be done using Dynamic SQL and anything that returns data from any query will probably be using a cursor. So knowing more about what that interaction looks like can only help in identifying your question as being down to something more specific and basic.

If I had to guess, since this was persistent (for 3 hours) but transient (it went away) I would guess you had either:

  • a keyset plan opened and some rows were deleted by other actions (possibly on other connections)
  • or the result set is empty

But I must repeat that is only a guess. I could tell a lot more if I had access to a detailed request log from the time when/while this was occuring ... and some details about the applications code line.

(14 Jul '16, 09:01) Nick Elson S...
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×35

question asked: 14 Jul '16, 03:18

question was seen: 321 times

last updated: 14 Jul '16, 09:01