During a replication (LoadUpdates on a remote server) this error occured:

>> EEDBException, ElevateDB Error #600 An error occurred with the
statement at line 35 and column 28 (File manager error (Access denied to
the file C:\Beckersoft\Stores\Informa_EDV1_In\EDV1-2016-02-08
12-03-56.013.EDBUpd))
00bdb3b0 +0d8 Labor.exe    edbremote
TEDBRemoteSessionManager.HandleException

After a new try to load update from this file, I got many error messages
because of index violations (duplicate primary key).

Actually all new records had been inserted and were already present when
reloading the updates.
I guess that the file could not be deleted after successful loading of
the updates. I didn't dare just to delete the update file though.

My question is: How would you deal with this kind of problem and is
there a way to suppress an exception like "duplicate primary key"?

Thanks Uli

Uli,

<< My question is: How would you deal with this kind of problem and is there a way to suppress an exception like "duplicate primary key"? >>

The first step is to determine what caused the access issue (file/user privileges, etc.).

As for the duplicate key errors, you can suppress these with a LOAD UPDATE ERROR trigger:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=CREATE_TRIGGER

under "LOAD UPDATE TRIGGERS".

Tim Young
Elevate Software
www.elevatesoft.com