Overview

The Outlook Connector fails to synchronize. The error logged is: "Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values."

The UI also shows the following error during the sync: "Failed to receive updates from GFI MailArchiver server."

The Outlook Connector debug log logfirebirdbackend.csv lists the following error:

2013-04-30,14:25:55,800,1,"#00000f90","#000005b4","error ","logfirebirdbackend","MessagesBatchOperationsHelper::InsertMessageHeaders firebird API call failed, error description *** IBPP::SQLException *** Context: Statement::Execute( INSERT INTO MESSAGES(MARID, PARENTID, DATABASEID, SUBJECT, CREATIONTIME, RECEIVEDDATE, SENTDATE, "Size", PRIORITY, "To", "From", HASATTACHEMENTS, CONVERSATION_TOPIC, CONVERSATION_INDEX) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) Message: isc_dsql_execute2 failed SQL Message : -803 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values Engine Code : 335544349 Engine Message : attempt to store duplicate value (visible to active transactions) in unique index "IDX_MESSAGES2" " 2013-04-30,14:25:55,800,1,"#00000f90","#000005b4","error ","logfirebirdbackend","MessagesBatchOperationsHelper::InsertMessageHeaders The MARID and the DatabaseID are already inserted in the backend, message data: " 2013-04-30,14:25:55,800,1,"#00000f90","#000005b4","error ","logfirebirdbackend","MessagesBatchOperationsHelper::InsertMessageHeaders Message, MARId: -2147360563, DBId: 2ec84e60-1f21-432e-af61-155516778a0b.

NOTE: The error message also contains information regarding the subject, creation time, delivery time, submit time, size, to and from; but this part of the error is not relevant to the issue.

Environment

20121204, 20130510, 20130704, 20130723

TT / JIRA ID

1215

Resolution

20130704 and 20130723: Apply this patch.

20130510: No patch available. Update and apply the patch.

20121204: Apply this patch.