Log Name: Application Source: MicrosoftDynamicsNavServer$DynamicsNAV71 Date: 16/9/2015 12:10:46 μμ Event ID: 216 Task Category: (13) Level: Error Keywords: Classic User: N/A Computer: proderp.icap.gr Description: Server instance: DynamicsNAV71 Tenant ID: default Session type: Background Session ID: 3082 User: ICAP\DYNAMIC Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException Remappable: True ErrorCode: 22926089 ErrorNumber: 54025 ModuleNumber: 93 SuppressMessage: False FatalityScope: None Message: Your activity was deadlocked with another user modifying the Job Queue Entry table. StackTrace: at Microsoft.Dynamics.Nav.Runtime.RecordImplementationHelper.MapException(NavCSideException originalException, NCLMetaTable metaTable, IRecordBuffer recordBuffer, Boolean makeNewExceptionRemappable) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequest(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.FindFirstRecord(DataError errorLevel) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ALFindFirst(DataError errorLevel) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.GetNextRequest_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.GetNextRequest(INavRecordHandle jobQueueEntry) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.HandleRequest_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.JobQueueLoop_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.OnRun_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.OnRun(INavRecordHandle εrec) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRun(DataError errorLevel, NavRecord record) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.InvokeRun(Int32 objectId, Object[] args) at Microsoft.Dynamics.Nav.Runtime.ALSession.RunCodeunitAndDisposeSession(NavSession session, Int32 codeUnitId, NavRecord record) Source: Microsoft.Dynamics.Nav.Ncl HResult: -2146233088 ---------------------------------- Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException Remappable: True ErrorCode: 22926089 ErrorNumber: 54025 ModuleNumber: 93 SuppressMessage: False FatalityScope: None Message: Your activity was deadlocked with another user modifying the Job Queue Entry table. StackTrace: at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.CheckAndthrowTrapableErrors(Int32 errorNumber, NavSqlException navSqlException) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.MapException(SqlException exception, NavSqlCommand command) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunction[T](Func`1 function, NavSqlCommand command) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[T](EventTask task, Func`1 function, NavSqlCommand command) at Microsoft.Dynamics.Nav.Runtime.NavSqlCommand.ReadNextRow() at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.ExecuteFindTop(FilterExpression filter, Boolean onlyCurrentKeyFieldsNeeded) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccess[T](NavSqlCommandCacheKey commandKey, Func`1 createFunc, Func`2 executeFunc) at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.FindTop1(NavDatabase database, NCLMetaTable table, Int32 companyIndex, Byte findMethod, Boolean locking, Boolean onlyCurrentKeyFieldsNeeded, FieldList orderByFields, FilterExpression filter) at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.FindTop1(NavDatabase database, PositionedFindProviderRequest request, Boolean onlyCurrentKeyFieldsNeeded) at Microsoft.Dynamics.Nav.Runtime.SqlTableDataProvider.TableFindFromPosition(NCLMetaTable table, PositionedFindProviderRequest request, Func`1 onlyCurrentKeyNeededForNextRow) at Microsoft.Dynamics.Nav.Runtime.DataAccess.InnerFind(FindCacheRequest request, Boolean fromPosition, Func`1 onlyCurrentKeyNeededForNextRow) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequest(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache) Source: Microsoft.Dynamics.Nav.Ncl HResult: -2146233088 Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="MicrosoftDynamicsNavServer$DynamicsNAV71" /> <EventID Qualifiers="0">216</EventID> <Level>2</Level> <Task>13</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2015-09-16T09:10:46.000000000Z" /> <EventRecordID>494072</EventRecordID> <Channel>Application</Channel> <Computer>proderp.icap.gr</Computer> <Security /> </System> <EventData> <Data>Server instance: DynamicsNAV71 Tenant ID: default Session type: Background Session ID: 3082 User: ICAP\DYNAMIC Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException Remappable: True ErrorCode: 22926089 ErrorNumber: 54025 ModuleNumber: 93 SuppressMessage: False FatalityScope: None Message: Your activity was deadlocked with another user modifying the Job Queue Entry table. StackTrace: at Microsoft.Dynamics.Nav.Runtime.RecordImplementationHelper.MapException(NavCSideException originalException, NCLMetaTable metaTable, IRecordBuffer recordBuffer, Boolean makeNewExceptionRemappable) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequest(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.FindFirstRecord(DataError errorLevel) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ALFindFirst(DataError errorLevel) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.GetNextRequest_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.GetNextRequest(INavRecordHandle jobQueueEntry) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.HandleRequest_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.JobQueueLoop_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.OnRun_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.OnRun(INavRecordHandle εrec) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRun(DataError errorLevel, NavRecord record) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.InvokeRun(Int32 objectId, Object[] args) at Microsoft.Dynamics.Nav.Runtime.ALSession.RunCodeunitAndDisposeSession(NavSession session, Int32 codeUnitId, NavRecord record) Source: Microsoft.Dynamics.Nav.Ncl HResult: -2146233088 ---------------------------------- Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException Remappable: True ErrorCode: 22926089 ErrorNumber: 54025 ModuleNumber: 93 SuppressMessage: False FatalityScope: None Message: Your activity was deadlocked with another user modifying the Job Queue Entry table. StackTrace: at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.CheckAndthrowTrapableErrors(Int32 errorNumber, NavSqlException navSqlException) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.MapException(SqlException exception, NavSqlCommand command) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunction[T](Func`1 function, NavSqlCommand command) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[T](EventTask task, Func`1 function, NavSqlCommand command) at Microsoft.Dynamics.Nav.Runtime.NavSqlCommand.ReadNextRow() at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.ExecuteFindTop(FilterExpression filter, Boolean onlyCurrentKeyFieldsNeeded) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccess[T](NavSqlCommandCacheKey commandKey, Func`1 createFunc, Func`2 executeFunc) at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.FindTop1(NavDatabase database, NCLMetaTable table, Int32 companyIndex, Byte findMethod, Boolean locking, Boolean onlyCurrentKeyFieldsNeeded, FieldList orderByFields, FilterExpression filter) at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.FindTop1(NavDatabase database, PositionedFindProviderRequest request, Boolean onlyCurrentKeyFieldsNeeded) at Microsoft.Dynamics.Nav.Runtime.SqlTableDataProvider.TableFindFromPosition(NCLMetaTable table, PositionedFindProviderRequest request, Func`1 onlyCurrentKeyNeededForNextRow) at Microsoft.Dynamics.Nav.Runtime.DataAccess.InnerFind(FindCacheRequest request, Boolean fromPosition, Func`1 onlyCurrentKeyNeededForNextRow) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequest(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache) Source: Microsoft.Dynamics.Nav.Ncl HResult: -2146233088 </Data> </EventData> </Event>
Comments
Setup SQL Extended Events to log information about the deadlocks. This will identify the offending SQL statements and help you to isolate the issue.