Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Question tags:
question asked: 14 Jul '16, 03:18
question was seen: 1,785 times
last updated: 14 Jul '16, 09:01
So what is your question?
That error (SQLCODE -197) has the following explanation (taken from the docs):
not relevant! i am not using cursor :-) Now the problem is more than an odd.
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:
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.