Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

(could be) possible duplicate with An inconsistency was detected

I have small table that returns from query

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]An inconsistency was detected during an internal operation. Please contact technical support. (SQLSTATE=HY000, SQLERRORCODE=5243)

  • before any further steps on my side I want to ask if is there another way as is described in linked thread,

  • and in this case there isn't any issue to re_creating table with proper contents on fly

share|improve this question
up vote 3 down vote accepted

The error message looks like it is coming from a DB2 linked server. I would check to make sure the consistency error is not being passed back from DB2.

share|improve this answer
.............thanks +1, there were AS400 replacement, then catalog id changed – mKorbel Nov 19 '12 at 18:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.