The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

Hallo, the following error message ame up at customer's installation: Error -189: Unable to find in index 'PDataEntry_750BG' for table 'PDataEntry_750BG' (WI005) call CreateDataEntryFromPGM

SQL anywhere documentation says: This is an internal error. If it can be reproduced, it should be reported to Sybase. You should be able to work around the error by dropping and recreating the index.

Weird is, that the error message doesn't report an index name and a table name but twice the table name

We dropped the (only) index on the concerned table abd re created it, but this didn't help. The error is permanently reproduceable

The database structure is used by hundreds of customers, so there is no general problem

We run a DB check without results.

The system is Sybase 7

asked 12 Mar '15, 07:12

maba's gravatar image

accept rate: 0%

The index whose name matches the name of the table is the primary key. You would need to drop and recreate the primary key. Of course, you may also have foreign keys to that which would be problematic. If unload/reload is an option, you could consider that too.

permanent link

answered 12 Mar '15, 07:39

John%20Smirnios's gravatar image

John Smirnios
accept rate: 39%

This seems to be an automatically created index, probably for the primary key of that table.

AFAIK, in older versions these automatically created indexes (for primary keys and unique constraints) are not listed in sys.sysindex. They cannot be dropped via DROP INDEX. However, they will be shown in DBISQL in the "Stats" pane when you access a row via its PK value and an index retrieval is done.

To drop and re-create such an automatically created index, you have to drop and re-create the PK constraint, i.e. something like (here for the sample database's table "product"):

permanent link

answered 12 Mar '15, 07:41

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

Take a backup of your database before making any irreversible changes.

permanent link

answered 12 Mar '15, 09:38

Breck%20Carter's gravatar image

Breck Carter
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 12 Mar '15, 07:12

question was seen: 970 times

last updated: 12 Mar '15, 09:38