V
V
vampire3332016-05-08 22:43:06
1C
vampire333, 2016-05-08 22:43:06

How to fix database loading error 1s?

base 1c in the file version. size 25 GB. 10 people work in the base. accounting 2.0 standard configuration. the task of switching to sql arose, since it is already unrealistic to endure the brakes of the file version (carriage of an incoming order ~ 10 minutes). when uploading the database to the 1c + PostgreSQL server, an error occurs

Infobase loading error. The information base loaded, not all the data
for a reason:
Trying to insert a non-unique value in a unique index: the
ERROR: Could not the create unique index "_docume1458_bydatakey_rr" the
DETAIL: Key (_idrref, _nodetref, _noderref) = (\ xa6fc14dae9b1cbaf11e508ef2a672372, \ x00000004, \ xa746c1641f48a0a911e0f75662bec052) is duplicated.

I tried date shift 2000. no result. Googled, can't find an answer. advise to cancel the posting of problematic documents, but do not tell how to find them(

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
vampire333, 2016-05-11
@vampire333

the issue was resolved by processing to search for documents by uid.
infostart.ru/public/118578
uploaded 4 documents, deleted them, uploaded them back after the transfer. thank you all for your help

A
Artem Labutin, 2016-05-08
@artem_labutin

Are you seriously?!! )) How did you manage to survive on the file version to such a volume without falling? ) I can't even believe it.
Googled badly. Use GetDatabaseStorageStructure and look for the table you need. I'm not sure, but it's possible to get the object by UID - this is a long series of numbers in the second line.
There are ready-made processings on the infostart, look.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question