Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Sorting on DateTime co...
Microsoft Dynamics CRM (Archived)

Sorting on DateTime columns in Virtual Entity returns Grid Refresh Error in MSCRM Online

(0) ShareShare
ReportReport
Posted on by NILANKA SEKHAR PAUL 340

Hi All,

I am facing issue while sorting the DateTime columns of Virtual Entity . It is given Grid refresh Error and below Error. But for other columns whose type is (Single line of Text, Decimal Number) its get sorted properly.

The issue coming for the DateTime fields only.

Can anyone help me on this. I have posted the Error screenshot of the Page.

3683.Err.png

*This post is locked for comments

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Sorting on DateTime columns in Virtual Entity returns Grid Refresh Error in MSCRM Online

    Bases on following part of exception

      <ActivityId>1e405d66-a802-41ff-aa88-161a65e44f56</ActivityId>

      <ErrorCode>-2147155357</ErrorCode>

      <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />

      <Message>An OData error occurred.</Message>

      <Timestamp>2018-02-16T08:35:44.3395029Z</Timestamp>

      <ExceptionRetriable>false</ExceptionRetriable>

      <ExceptionSource i:nil="true" />

      <InnerFault i:nil="true" />

      <OriginalException i:nil="true" />

    I assume that you have issues in your odata feed. Can you please check that your odata feed returns data when you call it with sorting by mentioned field?

  • NILANKA SEKHAR PAUL Profile Picture
    NILANKA SEKHAR PAUL 340 on at
    RE: Sorting on DateTime columns in Virtual Entity returns Grid Refresh Error in MSCRM Online

    Thanks Andrew Butenko for your reply.

    Please find below my Log File details.

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Xml.XmlException: Microsoft.Crm.CrmException: An OData error occurred.

      at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

      at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

      at Microsoft.Crm.ApplicationQuery.ExecuteQuery()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

      at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.GetRefreshResponseHtml(IGridUIProvider uiProvider, StringBuilder sbTemp)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Refresh(String gridXml, StringBuilder sbXml, StringBuilder sbHtml, Boolean returnJsonData)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context) ---> Microsoft.Crm.CrmException: An OData error occurred.

      at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

      at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

      at Microsoft.Crm.ApplicationQuery.ExecuteQuery()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

      at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.GetRefreshResponseHtml(IGridUIProvider uiProvider, StringBuilder sbTemp)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Refresh(String gridXml, StringBuilder sbXml, StringBuilder sbHtml, Boolean returnJsonData)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)

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

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)

      at Microsoft.Crm.Application.AppHttpHandler.ProcessRequest(HttpContext context)

      at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously): Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #8F525882Detail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance&quot; xmlns="schemas.microsoft.com/.../Contracts&quot;>

     <ActivityId>1e405d66-a802-41ff-aa88-161a65e44f56</ActivityId>

     <ErrorCode>-2147220970</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

     <Message>System.Xml.XmlException: Microsoft.Crm.CrmException: An OData error occurred.

      at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

      at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

      at Microsoft.Crm.ApplicationQuery.ExecuteQuery()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

      at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.GetRefreshResponseHtml(IGridUIProvider uiProvider, StringBuilder sbTemp)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Refresh(String gridXml, StringBuilder sbXml, StringBuilder sbHtml, Boolean returnJsonData)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context) ---> Microsoft.Crm.CrmException: An OData error occurred.

      at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

      at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

      at Microsoft.Crm.ApplicationQuery.ExecuteQuery()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

      at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.GetRefreshResponseHtml(IGridUIProvider uiProvider, StringBuilder sbTemp)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Refresh(String gridXml, StringBuilder sbXml, StringBuilder sbHtml, Boolean returnJsonData)

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)

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

      at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)

      at Microsoft.Crm.Application.AppHttpHandler.ProcessRequest(HttpContext context)

      at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously): Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #8F525882</Message>

     <Timestamp>2018-02-16T08:35:44.3395029Z</Timestamp>

     <ExceptionRetriable>false</ExceptionRetriable>

     <ExceptionSource i:nil="true" />

     <InnerFault>

       <ActivityId>1e405d66-a802-41ff-aa88-161a65e44f56</ActivityId>

       <ErrorCode>-2147155357</ErrorCode>

       <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

       <Message>An OData error occurred.</Message>

       <Timestamp>2018-02-16T08:35:44.3395029Z</Timestamp>

       <ExceptionRetriable>false</ExceptionRetriable>

       <ExceptionSource i:nil="true" />

       <InnerFault i:nil="true" />

       <OriginalException i:nil="true" />

       <TraceText>

    [Microsoft.Xrm.DataProvider.Odata.V4.Plugins: Microsoft.Xrm.DataProvider.Odata.V4.Plugins.ODataRetrieveMultiplePlugin]

    [5baba25f-5cda-e711-a953-000d3a361a17: External plug-in implementation]

    </TraceText>

     </InnerFault>

     <OriginalException i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

  • a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Sorting on DateTime columns in Virtual Entity returns Grid Refresh Error in MSCRM Online

    Hello,

    Can you please click "Download Log File" and provide content?

  • NILANKA SEKHAR PAUL Profile Picture
    NILANKA SEKHAR PAUL 340 on at
    RE: Sorting on DateTime columns in Virtual Entity returns Grid Refresh Error in MSCRM Online

    Hi All,

    Can anyone help on the above.

    Thanks in advance.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans