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..
The 1C:Enterprise developers forum