Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Query Error

  • 1.  Query Error

    Posted Aug 15, 2019 09:15 AM
    Hi All,

    I am trying to run a query on my local inside of visual studio from a dynamics entity. Each time I try to preview inside of VS it is giving me this error.

    "Am error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'dataset name' The entity with a name = 'entity name' with namemapping = 'Logical' was not found in the MetadataCache. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=53523682, MinActiveRowVersion=53523682"

    Could someone please help with this error?

    Thanks,
    Sam

    ------------------------------
    Samuel Hulitt
    Vertex Aerospace
    Madison
    ------------------------------
    Conference-CRMUG_200x200


  • 2.  RE: Query Error

    GOLD CONTRIBUTOR
    Posted Aug 19, 2019 04:29 PM

    Hi Samuel,

    Did you managed to resolve your error?

    Otherwize, could you send more information about the query you are trying to run ?

    Berst Regards



    ------------------------------
    Laurent Maneville
    N Media
    Drummondville QC
    ------------------------------

    Conference-CRMUG_200x200


  • 3.  RE: Query Error

    Posted Aug 20, 2019 07:24 AM
    Hi Samuel,

    Please make sure that in the query the names of entities and attributes used are logical names (all lower case), not schema names.

    Thanks,
    Sheena

    ------------------------------
    Sheena Samuel
    Technology Services Group
    Newcastle upon Tyne
    ------------------------------

    Conference-CRMUG_200x200


  • 4.  RE: Query Error

    Posted Aug 26, 2019 11:14 AM
    That issue happens when you are trying to retrieve a field(column) that don't exist, make sure that you are writing right the logical field name. e.g: new_field (correct), new_fied (incorrect).
    regards.

    ------------------------------
    PABLO CESAR ROLDAN PEREZ
    RhinoSystems SA de CV
    CUAUHTEMOC, Mexico DF
    ------------------------------

    Conference-CRMUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role