I used dbvalid for checking a copy of my productiv database in Sybase 10. Today i got an error like this
Foreign key "XXXXX_FK" has invalid or duplicate index entries SQL error (-300) Run-time SQL error - Validation of the Table "XXXXXXXXX" failed
So i try to reoganize the database to get the error number. ** SQL-Fehler: Interal Database Eroor FEHLER *** Assertion failed: 101412 (10.0.1.3990) Page number on page does not match page requested - Transaktion rolled back
So i lookup but don't find the error number http://wiki.scn.sap.com/wiki/display/SQLANY/Handling+an+Assertion+Failure
The Database is still online but with these error. Anyone know what to do to fix that? Anyone know the cause of these failure?
asked 23 Sep '14, 03:38
I've got the solution!
I opend SQL Anyhwere go to the Table>Indizies>recreate Index
An Again i checked the database with dbvalid... no errors.
answered 23 Sep '14, 07:43