Error- Violation of UNIQUE KEY -- AK_OpenDocs

If you are receiving this error in V 6.2.23 please run the following script

1. log into AO as admin

2. go to FILE--> MAINTAIN--> ADVANCED tab--> RUN DB COMMAND

3. Past this script in the box and click RUN ----------------------------------------------------------------------------------------- IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[OpenDocs]') AND name = N'AK_OpenDocs') begin ALTER TABLE [dbo].[OpenDocs] DROP CONSTRAINT [AK_OpenDocs] end ---------------------------------------------------------------------------------------------- 4. If you get a message other then " completed successfully" please contact NumberCruncher Support 866-278-6243 X 815 support@numbercruncher.com