The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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

maba
1111
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
8.7k377106
accept rate: 40%

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"):

ALTER TABLE dbo.product DROP PRIMARY KEY;
ALTER TABLE dbo.product ADD PRIMARY KEY(id);
permanent link

answered 12 Mar '15, 07:41

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646
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
26.8k420580826
accept rate: 20%

Your answer
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:

×83

question asked: 12 Mar '15, 07:12

question was seen: 498 times

last updated: 12 Mar '15, 09:38