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 / 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

I have the same question (0)
  • NILANKA SEKHAR PAUL Profile Picture
    NILANKA SEKHAR PAUL 340 on at

    Hi All,

    Can anyone help on the above.

    Thanks in advance.

  • a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

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

  • NILANKA SEKHAR PAUL Profile Picture
    NILANKA SEKHAR PAUL 340 on at

    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>

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    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?

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 > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans