asked on August 25, 2019 Show version history

We are having an issue after a rebuild of an index for 10.3. Images are not able to be imported into a Laserfiche Repository and the users are receiving a corrupt image/document message in the client.

Server side we are seeing the following with varying delicate key values. 

An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=1652; Dialog ID=463892; Repository="CNI-Internal"; Function=SysJournalAppend; Message="[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'journal_entry_pk'. Cannot insert duplicate key in object 'dbo.journal_entry'. The duplicate key value is (12015)."; Statement="insert into journal_entry (jentry_id, journal_id, jentry_timestamp, jentry_schema, jentry_text) values (:entryid<bigint>, :journalid<int>, :ts<timestamp>, :schema<char[255]>, :text<varchar_long>)"; SQL Variable=""; SQL State="23000".

Has anyone seen this before? Is there a way to resolve this issue without loading the last backup?

0 0