Answer the question
In order to leave comments, you need to log in
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.
Answer the question
In order to leave comments, you need to log in
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
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 questionAsk a Question
731 491 924 answers to any question