HELP! After Restore of MAXDB 7.6.06.03 I get sql error duplicate secondary key and the database can't go ONLINE.
I tried to restore a complete backup with initialization. When the restore is finished and I click on Restart the error comes up.
Is there a chance to fix that error? I dont have access to an older backup right now.
EDIT: The error log says this:
2014-05-27 05:36:54 0x308 ERR 5 Catalog Catalog update failed,IFR_ERROR=250,DESCRIPTION=POS(1) Duplicate secondary key:INDEX001
2014-05-27 05:36:55 ___ Stopping GMT 2014-05-27 03:36:55 7.6.06 Build 003-123-202-135
I also tried to switch AUTO_RECREATE_BAD_INDEXES from NO to YES but no difference. Any ideas?