Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV2013 - OData - Obje...
Microsoft Dynamics NAV (Archived)

NAV2013 - OData - Object reference not set to an instance of an object

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Can someone help me, Where to look for the problem? 

Get this error code in the Eventviewer. 

Server instance: NST71GWPLive

User: DOMAIN\aXXXe.rXXXXma
Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
StackTrace:
at Microsoft.Dynamics.Nav.Runtime.ALCompiler.ConvertNavValueToClrValue(NavValue navValue)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataQueryProviderToNavQuery.CreateODataResourceForNavQuery(NavValue[] queryResultRow)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataQueryProviderToNavQuery.FetchData(NavSession session)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataQueryProviderToNavQuery.GetResourcesFromNavObject(NavSession session)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.NavServiceHelper.ExecuteOperation[TResult,T1,T2](String companyName, ODataOperation`3 operation, T1 parameter1, T2 parameter2, Boolean isDefaultCompanyRequired)
Source: Microsoft.Dynamics.Nav.Ncl
HResult: -2147467261

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    Thanks 2 you all for commenting.

    This is fixed in the software of our third party.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    Hi,

    Hope this will help you out -

    saurav-nav.blogspot.com/.../nav-2015-error-while-consuming-query.html

    Let me know if it helps.

  • keoma Profile Picture
    keoma 32,675 on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    for the given filter settings there is no result (no work orders, ...):

    DEBUG in Communication(thr8): 2015-10-22 11:14:12.8552 sub result: 0 work orders received

    ERROR in Communication(thr12): 2015-10-22 11:14:14.7537 Fatal error in LoadItemsFromSourceAndDetectChanges:  

    could be a bug in that app.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    Thanks any way!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    It is an external app - called GWP - Grafical WorkOrder Planner;

    The log is from that program.

    The NAV2013R2 version.  

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    I am sorry, but i have to guess on this, as it looks like it is looking for a resource and the resource does not exist on the system while processing and it is throwing that error.

  • keoma Profile Picture
    keoma 32,675 on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    which client does this error produce: windows/web/tablet client or an external app ?

    from the log i would say the web client or an external web app.

    was the calling page customized ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    This error appears in the windows eventviewer, and it happens when -

    People are 'planning' - resources for a WorkOrder and sometimes changes from one resource to an other.

    There is no Pin pointing on which moment the error appears in eventviewer.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    When are you getting this error ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013 - OData - Object reference not set to an instance of an object

    Don't know..

    Hope the log helps?

    Foutmelding in Log - 11:14:12:

    TRACE in Communication(thr8): 2015-10-22 11:14:12.7302 nsxxxx/.../Company('OXXe

    InsXXXties')/WorkOrderGWP()?$filter=SOStatusAsInt le 3 and Duration_Time gt 0M and Starting_Date_Time gt datetime'2015-09-22T00:00:00%2B02:00' and

    Starting_Date_Time lt datetime'2016-02-19T00:00:00%2B01:00' and Source_Company eq 'OXXe InsXXXties'

    TRACE in Communication(thr12): 2015-10-22 11:14:12.7458 nsXXXX/.../Company('PrXXXer-Xier

    Installaties')/WorkOrderGWP()?$filter=SOStatusAsInt le 3 and Duration_Time gt 0M and Starting_Date_Time gt datetime'2015-09-22T00:00:00%2B02:00' and

    Starting_Date_Time lt datetime'2016-02-19T00:00:00%2B01:00' and Source_Company eq 'PrXXXXer-Xier Installaties'

    DEBUG in Communication(thr8): 2015-10-22 11:14:12.8552 sub result: 0 work orders received

    ERROR in Communication(thr12): 2015-10-22 11:14:14.7537 Fatal error in LoadItemsFromSourceAndDetectChanges:  

    System.Data.Services.Client.DataServiceQueryException: An error occurred while processing this request. --->

    System.Data.Services.Client.DataServiceClientException: {"odata.error":{"code":"","message":{"lang":"en-US","value":"Object reference not set to an

    instance of an object."}}}

      at System.Data.Services.Client.QueryResult.ExecuteQuery()

      at System.Data.Services.Client.DataServiceRequest.Execute[TElement](DataServiceContext context, QueryComponents queryComponents)

      --- End of inner exception stack trace ---

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans