We are logging to an external MS SQL database and it stopped working 3 days ago. The following information was found in the Server event log:
Log Name: Adaxes
Source: Adaxes Service
Date: 2/24/2017 4:12:59 PM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: ADAXES01.co.wake.nc.us
Description:
Softerra.Adaxes.Logger+LogMessageWrappingException: Failed to save log records to the external database. ---> System.OverflowException: Arithmetic operation resulted in an overflow.
at System.Data.SQLite.SQLite3.GetBytes(SQLiteStatement stmt, Int32 index, Int32 nDataOffset, Byte[] bDest, Int32 nStart, Int32 nLength)
at System.Data.SQLite.SQLiteDataReader.GetBytes(Int32 i, Int64 fieldOffset, Byte[] buffer, Int32 bufferoffset, Int32 length)
at #9k.#al.Convert(IDataRecord dataRecord)
at #9k.#1l.ExecuteSelectQuery[T](String query, IList1 parameters, IDataRecordConverter1 converter, IDbCommand command)
at #9k.#4l.ExecuteSelectQuery[T](String query, IList1 parameters, IDataRecordConverter1 converter)
at Softerra.Adaxes.Logging.SQLiteAccessProvider.ExecuteSelectQuery[T](String query, IList1 queryParameters, IDataRecordConverter1 converter)
at Softerra.Adaxes.Logging.SQLiteAccessProvider.GetExecutionLog(Guid logRecordId)
at Softerra.Adaxes.Logging.DBAccessProvider.LoadExecutionLog(Guid logRecordId)
at Softerra.Adaxes.Logging.AdmLogRecord.GetExecutionLog()
at #Kl.#Pl.InsertRecord(ISqlQueryExecutor queryExecutor, AdmLogRecord record, Guid initiatorId, Guid targetObjectId)
at Softerra.Adaxes.Logging.DBAccessProvider.InsertRecord(ISqlQueryExecutor queryExecutor, AdmLogRecord record)
at #9k.#zl.#i.#Al.#0wb()
at #9k.#zl.#i.#Al.#Zwb()
--- End of inner exception stack trace ---
Event Xml:
">
0
2
0
0x80000000000000
150460
Adaxes
ADAXES01.co.wake.nc.us
Softerra.Adaxes.Logger+LogMessageWrappingException: Failed to save log records to the external database. ---> System.OverflowException: Arithmetic operation resulted in an overflow.
at System.Data.SQLite.SQLite3.GetBytes(SQLiteStatement stmt, Int32 index, Int32 nDataOffset, Byte\[\] bDest, Int32 nStart, Int32 nLength)
at System.Data.SQLite.SQLiteDataReader.GetBytes(Int32 i, Int64 fieldOffset, Byte\[\] buffer, Int32 bufferoffset, Int32 length)
at #9k.#al.Convert(IDataRecord dataRecord)
at #9k.#1l.ExecuteSelectQuery\[T\](String query, IList`1 parameters, IDataRecordConverter`1 converter, IDbCommand command)
at #9k.#4l.ExecuteSelectQuery\[T\](String query, IList`1 parameters, IDataRecordConverter`1 converter)
at Softerra.Adaxes.Logging.SQLiteAccessProvider.ExecuteSelectQuery\[T\](String query, IList`1 queryParameters, IDataRecordConverter`1 converter)
at Softerra.Adaxes.Logging.SQLiteAccessProvider.GetExecutionLog(Guid logRecordId)
at Softerra.Adaxes.Logging.DBAccessProvider.LoadExecutionLog(Guid logRecordId)
at Softerra.Adaxes.Logging.AdmLogRecord.GetExecutionLog()
at #Kl.#Pl.InsertRecord(ISqlQueryExecutor queryExecutor, AdmLogRecord record, Guid initiatorId, Guid targetObjectId)
at Softerra.Adaxes.Logging.DBAccessProvider.InsertRecord(ISqlQueryExecutor queryExecutor, AdmLogRecord record)
at #9k.#zl.#i.#Al.#0wb()
at #9k.#zl.#i.#Al.#Zwb()
\--- End of inner exception stack trace ---
Also, the size of the AdaxesLog.db3 is 633MB. Please let me know if you want me to send it to you.
Thanks