If I try the select, I don’t have any record where realindex is null Nico Speleers Team Lead Analyse & Consultancy
Carfac bvba [Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]<http://www.carfac.be/>Driving on experience Ambachtstraat 8 | 9700 Oudenaarde Tel. +32 55 23 00 00 | Fax +32 55 31 00 95 [email protected]<mailto:[email protected]> | www.carfac.be<http://www.carfac.be/> [Facebook]<http://www.facebook.com/groups/120709181286476/>[LinkedIn]<http://www.linkedin.com/company/hdc-software-nv>[Twitter]<https://twitter.com/carfacbvba> Van: 'Paul Beach' [email protected] [firebird-support] [mailto:[email protected]] Verzonden: vrijdag 22 december 2017 13:16 Aan: [email protected] Onderwerp: RE: [firebird-support] info Try the following... Partner index description not found (175)) internal gds software consistency check (partner index description not found. Missing index for a primary or a foreign key. The problem may be caused by physical database corruption or by a bug. Recovery process: To find the missing index, use following SELECT statement: select R.RDB$CONSTRAINT_NAME, R.RDB$INDEX_NAME as REFINDEXNAME, I.RDB$INDEX_NAME as REALINDEX, I.RDB$RELATION_NAME, I.RDB$INDEX_INACTIVE from RDB$INDICES I RIGHT JOIN RDB$RELATION_CONSTRAINTS R on I.RDB$INDEX_NAME = R.RDB$INDEX_NAME where R.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY' or R.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY' order by R.RDB$CONSTRAINT_NAME The contraint that is missing an index (where column REALINDEX is empty) will be corrupted. Try and recreate this constraint. Paul [Non-text portions of this message have been removed]
