This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I think this issue was fixed in 7.1.1.4 fix pac...but maybe I missed it or upgrade 7.1.1.7 did not fix it. but.....
Integrityui error...is
BMXAA0405I - Rebuild index tables. Wed Apr 24 09:39:45 EDT 2013
truncate table maxsysindexes
go
truncate table maxsyskeys
go
Commit
go
Insert Into maxsysindexes (name, tbname, uniquerule, changed, storagepartition, clusterrule, required, textsearch,maxsysindexesid)
Values ('ACCOUNTDEFAULT_NDX', 'ACCOUNTDEFAULTS', 'U', 'N', 'PRIMARY', 0, 0, 0, 1)
go
Insert Into maxsyskeys (ixname, colname, colseq, ordering, changed, maxsyskeysid) Values ('ACCOUNTDEFAULT_NDX', 'ACCOUNTDEFAULTSID', 1, 'A', 'N', 1)
go
Insert Into maxsysindexes (name, tbname, uniquerule, changed, storagepartition, clusterrule, required, textsearch,maxsysindexesid)
Values ('ACCTDFLT_NDX1', 'ACCOUNTDEFAULTS', 'U', 'N', 'PRIMARY', 0, 0, 0, 2)
go
Insert Into maxsyskeys (ixname, colname, colseq, ordering, changed, maxsyskeysid) Values ('ACCTDFLT_NDX1', 'ORGID', 1, 'A', 'N', 2)
go
Insert Into maxsyskeys (ixname, colname, colseq, ordering, changed, maxsyskeysid) Values ('ACCTDFLT_NDX1', 'DFLTGROUP', 2, 'A', 'N', 2)
go
com.inet.tds.at: Msg 2601, Level 14, State 1, Line 1, Sqlstate 23000
[CWSCOSOHSQ006]Cannot insert duplicate key row in object 'dbo.maxsyskeys' with unique index 'maxsyskeys_ndx1'. The duplicate key value is (2).