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

Notifications

Announcements

No record found.

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... / When open Item List or...
Small and medium business | Business Central, N...
Suggested Answer

When open Item List or Item Table Dynamics NAV get crashed.

(0) ShareShare
ReportReport
Posted on by ShanAbeywicrema 948

Dear All, 

When I open Item List or Run Item table Dynamics NAV will close. This is the Event Log. Anyone got this error or similar issue ? Could you please share how you solved it

Server instance: NAVTEST
Tenant ID:
<ii>User: xxxxxxxxx\NAVAdmin2
Type: System.IndexOutOfRangeException
Message: <ii>Invalid index 0 for this SqlParameterCollection with Count=0.</ii>
StackTrace:
at System.Data.SqlClient.SqlParameterCollection.RangeCheck(Int32 index)
at System.Data.SqlClient.SqlParameterCollection.GetParameter(Int32 index)
at System.Data.SqlClient.SqlParameterCollection.get_Item(Int32 index)
at Microsoft.Dynamics.Nav.Runtime.Media.NavMediaHelper.<>c__DisplayClass6_1.<SerializeMediaSet>b__3(NavSqlCommand cmd)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccess[T](NavSqlCommandCacheKey commandKey, Func`1 createFunc, Func`2 commandTextFunc, Action`1 parameterCreateFunc, Action`1 setParametersAction, Func`2 executeFunc)
at Microsoft.Dynamics.Nav.Runtime.Media.NavMediaHelper.SerializeMediaSet(Guid referenceValue, String companyName, Int32 systemTableId, NavMediaDescriptionCollection navMediaDescriptionCollection)
at Microsoft.Dynamics.Nav.Runtime.Media.NavMediaHelper.BuildMediaDescriptionCollection(Int32 parentId, Guid referenceValue, Boolean referenceIsSet)
at Microsoft.Dynamics.Nav.Runtime.NavMediaSet.get_ClientObject()
at Microsoft.Dynamics.Nav.Service.NSRecordBase.SetCLRCellFromTableField(NsDataAccess recDataAccess, NCLMetaField metaField, Int32 fieldIndex, NavDataRow dataRow)
at Microsoft.Dynamics.Nav.Service.NSRecordBase.PopulateCLRTable(NavDataTable dataTable, NsDataAccess recDataAccess, NavDataRow dataRow)
at Microsoft.Dynamics.Nav.Service.NSPage.PopulateNextRows(NavDataTable dataTable, NsDataAccess recDataAccess, ReadDirection readDirection, Int32 pageSize)
at Microsoft.Dynamics.Nav.Service.NSPage.PopulateSpecificPage(NavDataSet dataSet, NsDataAccess recDataAccess, Boolean& moreDataInReadDirection, Boolean& moreDataInOppositeDirection)
at Microsoft.Dynamics.Nav.Service.NSPage.PopulateCLRDataSet(NavDataSet dataSet, NsDataAccess recDataAccess, Boolean& moreDataInReadDirection, Boolean& moreDataInOppositeDirection)
at Microsoft.Dynamics.Nav.Service.NSPage.GetPageData(NavSession session)
at Microsoft.Dynamics.Nav.Service.NSPage.GetPage(NavSession session)
at Microsoft.Dynamics.Nav.Service.NSService.Microsoft.Dynamics.Nav.Types.INavService.GetPage(PageRequestDefinition pageRequestDefinition, NavRecordState state)
at SyncInvokeGetPage(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.RunInTransactionCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, String syncMethodName, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass23_0.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.TransientErrorRetryCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, String syncMethodName, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass23_0.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.ErrorMappingCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, String syncMethodName, Object[] inputs, Object[]& outputs)
Source: System.Data
HResult: -2146233080
</ii>

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,245 Super User 2025 Season 2 on at

    Did you insert data into table using SQL ?

  • ShanAbeywicrema Profile Picture
    ShanAbeywicrema 948 on at

    Hi Suresh,

    No . I have Dev DB, TestDB and LiveDB. same object I have in all three databases, but only in Test DB system get crashed. But it is working fine in DevDB and LiveDB. I am just only open the Item List.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,245 Super User 2025 Season 2 on at

    I am not referring the objects, It is something with data and it is wrong,  any media set or images assigned to Item might be in wrong format or corrupted

  • ShanAbeywicrema Profile Picture
    ShanAbeywicrema 948 on at

    Please correct me if I wrong here, something wrong in item picture ( only available filed contains MediaSet) might be high capacity or wrong format.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,245 Super User 2025 Season 2 on at

    Yes, that is what i think based on the event log and usually if you can't even open the table it means there is something wrong with data.

  • ShanAbeywicrema Profile Picture
    ShanAbeywicrema 948 on at

    Another thing i could not mentioned here. once open table I can scroll down / up. Suddenly system get crashed. same in item List.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,245 Super User 2025 Season 2 on at

    I think it is crashing at the item record where there is invalid data, try to identify that and you might have to delete that record from SQL.

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

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 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans