Sql error 2601
Posted on 2004-11-12
I am in the process of completing a upgrade of a database in Sql 2000. This upgrade is for an application named Maximo. I have completed the database upgrade procedure according to the manual supplied by Maximo. There is a final step after the upgrade to check the database for integrity. A utility is supplied to excute this integrity check plus insert some information in some of the tables in the database. I am receiving this error during the integrity check process:
SQL(2) Insert Into maxsysindexes (name, tbname, uniquerule, clusterrule, changed, storagepartition)
Values (:sName, :sTbName, :sUniqueRule, :sClustered, 'N', :sSegment)
SQL ERROR: #20030
Microsoft SQL Server:2601[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'maxsysindexes' with unique index 'MAXSYSINDEX_NDX1'.Microsoft SQL Server:3621
ERROR [002E]: An error occurred in RefreshMAXIMOIndexTables().
This is the output from sp_helpindex 'maxsysindexes'
MAXSYSINDEX_NDX1 clustered, unique located on PRIMARY
MAXSYSINDEX_NDX2 nonclustered located on PRIMARY
After some research I think I need to run (drop existing index), then run the integrity check, then restore the indexes. I am a novice to Sql so I do not now how to complete this process if it is correct. Also could it be possible that this is a case sensitive issue? (collation name: Latin1_General_Bin).