External Logging Error

Question

Good afternoon Support,
I've recently reinstalled Adaxes on one of our nodes to update to the 2015.1 version. Upon bringing services online the node is no longer able to write to the database because of the following error.

I can't say that I am very good with MS SQL but have your team seen these issues before?

Adaxes service 'ADAXES02.contoso.com' cannot save log records to the external database.
Error Details: Softerra.Adaxes.Logging.ExternalDatabaseException (0x80072035): Violation of PRIMARY KEY constraint 'PKOperations'. Cannot insert duplicate key in object 'dbo.Operations'. The duplicate key value is (0375804f-6879-4f0d-a8ad-3d605f691d31).
The statement has been terminated.
Database: Adaxes (ADAXESDB.contoso.com)
Username: CONTOSO\svc.Adaxes ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PKOperations'. Cannot insert duplicate key in object 'dbo.Operations'. The duplicate key value is (0375804f-6879-4f0d-a8ad-3d605f691d31).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at #Tk.#Kl.ExecuteNonQuery(String query, IList1 parameters, IDbCommand command) at #Tk.#Ll.ExecuteNonQuery(String query, IList1 parameters)
at #Tk.#Ll.ExecuteNonQuery(String query, IList`1 parameters)
at #tl.#yl.InsertRecord(ISqlQueryExecutor queryExecutor, AdmLogRecord record, Guid initiatorId, Guid targetObjectId)
at Softerra.Adaxes.Logging.DBAccessProvider.InsertRecord(ISqlQueryExecutor queryExecutor, AdmLogRecord record)
at #Tk.#il.#i.#jl.#9ub()
at #Tk.#il.#i.#jl.#8ub()

Answer 1

Hello,

It looks like there is a time synchronization issue between the local (SQLite) database and the external (Microsoft SQL) databases. Or you've changed some time settings on the computer where Adaxes service is installed so that older log records have more recent time stamps than newer ones.

In any case, the easiest way to resolve the issue is to delete the local database. In this case, you will lose the events that occurred since you've upgraded, but the service will be able to write log records to the external database. If this OK with, you can do as follows:

1. Stop Softerra Adaxes Service.
2. Delete the local SQLite database file. It is called AdaxesLog.db3 and located in the LogDB subfolder of the folder where the Adaxes service is installed.
3. Start Softerra Adaxes Service. When the service starts, it will create a new local logging database file.

Comments

In the current situation that method acceptable. Thank you very much, worked like a charm!