We are getting the following error while bringing up our database on sybase. We did not change anything before restarting the server so really dont know what corrupted the index.
server Error: 644, Severity: 21, State: 5
server Index row entry for data row id (1953, 0) is missing from index page 8196 of index id 2 of table 'DBH_STG_THREADS' in
database 'saptools'. Xactid is (137127,40). Drop and re-create the index.
We did the following so far:
1) We found the table to be for database 'saptools'.
2) We found the index name to be DBH_STG_THREADS~0 for table 'DBH_STG_THREADS'
3) We tried to drop and recreate this index as nonclustered as suggested by note # 1964255
4) The drop command "
drop index DBH_STG_THREADS.DBH_STG_THREADS~0
Msg 102, Level 15, State 181:
Server 'XYZ', Line 1:
Incorrect syntax near '~'.
is not able to recognize the character ~.
We understand that ~ means NEAR as mentioned in some documents, but this is not really helping.
We are unable to proceed with bringing up the server.
Thanks in advance.