SQL database error

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Interested
Rating: 32
Joined: Oct 27, 2011
Company: Abaco Soluciones S.A.

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..

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

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

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.