web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Nullable object must h...
Small and medium business | Business Central, N...
Suggested Answer

Nullable object must have a value.

(4) ShareShare
ReportReport
Posted on by KK-08011330-0 12
Hi, 
we have On Premise installation CU: 26.0.36290 
and Quite often, our processes are stopped by an error: Nullable object must have a value.
 
most often this happens from a job queue , of course, becouse there it is logged, but it also happens when started manually.
When manually, it shut down client, ale in debuger it ends on some FIND command (FINDFIRST,FINDSET, ISEMPTY)
 
And it create record in Event log (copy below)
(We tried to init table: dbo.[Intelligent Cloud] on SQL and fill enable asi 0, but error is still same)
There is no regularity to it, it can fall on something different every time
And it happens for various tasks, although more often for those that work with "larger" amounts of data
 
 
Server instance: ROSSMANN_TEST
Category: TaskScheduling
ClientSessionId: 00000000-0000-0000-0000-000000000000
ClientActivityId: e3bba1b7-6683-479d-8a36-91e64b3c0274
ServerSessionUniqueId: ea52b043-280a-4052-8a80-6a69a1f1b6fb
ServerActivityId: 82f668b4-1a94-4532-84f6-b6cd31da313c
EventTime: 01/08/2026 11:23:56
Message (InvalidOperationException): TaskId=e4be609e-fb18-4ed4-8c59-771ce530007e, Type=Codeunit, Attempt=0, Run main codeunit=448
RootException: InvalidOperationException (HResult: 0x80131509)
Nullable object must have a value.
ExceptionStackTrace:
   at Microsoft.Dynamics.Nav.Runtime.NavTenant.get_IsIntelligentCloudReplicationEnabled()
   at Microsoft.Dynamics.Nav.Runtime.DataAccess.CheckCloudStateReadyReplicationAllowOperation(NCLMetaApplicationObject requestObject, Int32 companyToken)
   at Microsoft.Dynamics.Nav.Runtime.DataAccess.InnerFindAsync(FindCacheRequest request, Boolean fromPosition, Func`1 onlyCurrentKeyNeededForNextRow)
   at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequestAsync(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache)
   at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.FindRecordSetAsync(DataError errorLevel, Boolean forUpdate)
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit72059.AssignLayoutID(NavScope γReturnValueParent, INavRecordHandle dataLabelSL, INavRecordHandle stagePromotion, INavRecordHandle stageItem, INavRecordHandle stageStoreAssortment, Int32 layoutGroup, NavDate labelValidFromDate)
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit72059.FillDataLabelSLFromStageTables_434540303(Int32 layoutGroup, Int32 layoutID, NavCode campaignNo, NavDate labelValidFromDate, Int32 promotionType, NavText storeNo, NavText itemNo)
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit72065.OnRunAsync(INavRecordHandle εrec)
   at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRunAsync(DataError errorLevel, NavRecord record)
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit449.OnRunAsync(INavRecordHandle εrec)
   at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRunAsync(DataError errorLevel, NavRecord record)
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.HandleRequest(INavRecordHandle jobQueueEntry)
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.OnRunAsync(INavRecordHandle εrec)
   at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRunAsync(DataError errorLevel, NavRecord record)
   at System.Threading.Tasks.ValueTask`1.ValueTaskSourceAsTask.<>c.<.cctor>b__4_0(Object state)
--- End of stack trace from previous location ---
   at Microsoft.Dynamics.Nav.Runtime.TaskRunnerCodeUnit.TaskSpecificInternalRunAsync()
CallerStackTrace:
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.TaskRunnerCodeUnit.TaskSpecificInternalRunAsync()
   at _Diag_.Net._Async_Internals_()
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRunAsync(DataError errorLevel, NavRecord record)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.OnRunAsync(INavRecordHandle εrec)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit448.HandleRequest(INavRecordHandle jobQueueEntry)
   at _Diag_.Net._Async_Internals_()
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRunAsync(DataError errorLevel, NavRecord record)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit449.OnRunAsync(INavRecordHandle εrec)
   at _Diag_.Net._Async_Internals_()
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRunAsync(DataError errorLevel, NavRecord record)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit72065.OnRunAsync(INavRecordHandle εrec)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Types.ValueTaskExtensions.<>c__1`1.<AsValueTask>b__1_0(Task t, Object o)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit72059.FillDataLabelSLFromStageTables_434540303(Int32 layoutGroup, Int32 layoutID, NavCode campaignNo, NavDate labelValidFromDate, Int32 promotionType, NavText storeNo, NavText itemNo)
   at _Diag_.Net._Async_Internals_()
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.FindFirstRecordAsync(DataError errorLevel)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequestAsync(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.DataAccess.InnerFindAsync(FindCacheRequest request, Boolean fromPosition, Func`1 onlyCurrentKeyNeededForNextRow)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.SqlTableDataProvider.TableFindFromPositionAsync(NCLMetaTable table, PositionedFindProviderRequest request, Func`1 onlyCurrentKeyNeededForNextRow)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.FindTop1Async(NavSession session, NavDatabase database, NCLMetaTable table, Int32 companyIndex, Byte findMethod, DataLockState lockState, Boolean onlyCurrentKeyFieldsNeeded, SortingFieldList orderByFields, FilterExpression filter, FieldLoadInfo fieldLoadInfo)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccessAsync[T](NavSqlCommandCacheKey commandKey, Func`1 newCommandFunc, Func`2 executeFunc)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavSqlIsamQueryCommand.ExecuteFindTopAsync(FilterExpression filter, Boolean onlyCurrentKeyFieldsNeeded, NavDatabase database, Int32 companyIndex, Nullable`1 companyId)
   at _Diag_.Net._Async_Internals_()
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTraceAsync[T,TState](EventTask task, Func`3 function, String commandText, SqlCommand sqlCommand, Boolean isAdoCommand, TState state)
   at _Diag_.Net._Async_Internals_()
   at Microsoft.Dynamics.Nav.Runtime.NavSqlCommand.<>c.<<ExecuteReaderAsync>b__62_0>d.MoveNext()
   at _Diag_.Net._Async_Internals_()

ProcessId: 232028
Tag: 0000FG0
ThreadId: 17
ExecutionId: 739
CounterInformation: 
CustomParameters: {
}
GatewayCorrelationId: 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    Assisted by AI
    OussamaSabbouh Profile Picture
    OussamaSabbouh 6,978 on at
    Hello,
     
    This is a platform bug, not your code. The stack trace shows BC crashing while checking Intelligent Cloud replication state, where an internal nullable value comes back NULL and randomly breaks FIND/FINDFIRST/ISEMPTY, especially in Job Queue and large data runs. Manually tweaking SQL tables (like Intelligent Cloud) won’t fix it. The real solution is to update to the latest CU/hotfix for v26 on-prem, and ensure Intelligent Cloud is properly disabled/initialized via BC setup, not SQL. If it still happens after patching, this exact stack trace is enough to open a Microsoft support case — it’s clearly runtime/platform-level.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    KK-08011330-0 Profile Picture
    KK-08011330-0 12 on at
    Update: Yesterday we updated the platform to 26.8 and so far it seems to be a solution.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,798

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 812 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 717 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans