Forum

Hi all,

I have a strange behavior. After update of configuration on the server I got an error trying to resave, delate or repost document. It only appears while trying to work with this document.
I dumped the infobase and work with it locally and it seems that everything is fine. I delete the document and tried to upload modificated locally infobase, but got the same error:

Attempt to ins ert nonunique values into unique index:
Microsoft OLE DB Provider for SQL Server: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccRgAT2123' and the index name '_AccRgA2123_ByPeriod_TRRRRR'. The duplicate key val ue is (Nov  1 5999 12:00AM, 0xb87133dbfd8a687b477828fa69b2c4a7, 0x00000000000000000000000000000000, 0x00000000000000000000000000000000, 0x08, 0x0000001d, 0xa37f2837371ca71711e119826094fd69, <NULL>, <NULL>, <NULL>).
HRESULT=80040E2F, SQLSrvr: SQLSTATE=23000, state=1, Severity=10, native=1505, line=1

Any ideas how to get it to work at the server again?
p.s. Tried all functions of designer to restore db integrity etc..

It seems like you have deleted one of attributes making record unique. Find duplicated register records and delete them.