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) / CRM 2015 - Hierarchy R...
Microsoft Dynamics CRM (Archived)

CRM 2015 - Hierarchy Rule Defined Entities

(0) ShareShare
ReportReport
Posted on by Ahmet Sancar 195

We performed a fresh installation of CRM 2015. Systemuser entity comes with a default Hierarchy Rule defined and when we try to access systemuser list it gives the following error:

=====================================================

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6.12.2014 11:19:28
Event time (UTC): 6.12.2014 09:19:28
Event ID: bb450d204a6243bf8ab2433d77f02bdd
Event sequence: 127
Event occurrence: 4
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT-1-130623304179102831
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: DEVCRM01

Process information:
Process ID: 1740
Process name: w3wp.exe
Account name: MERKEZ\SVC_CRMAPP

Exception information:
Exception type: CrmException
Exception message: Invalid character specified for alias: HierarchyDataParentID6dcd9e4c001441b09237d51a34853d55. Only characters within the ranges [A-Z], [a-z] or [0-9] or _ are allowed. The first character may only be in the ranges [A-Z], [a-z] or _.
at Microsoft.Crm.Query.Expression.ValidateAlias(String alias)
at Microsoft.Crm.Query.ColumnSetExpression.AddColumnWithAlias(String attributePlatformName, String alias)
at Microsoft.Crm.ApplicationQuery.HierarchyAwareRetrieveMultipleCommand.DecorateQuery()
at Microsoft.Crm.ApplicationQuery.BuildQuery()
at Microsoft.Crm.ApplicationQuery.GetViewData()
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.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)
at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)
at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at Microsoft.Crm.Web.EntityHomepage.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)



Request information:
Request URL: http://devcrm01/TEST/_root/homepage.aspx?etc=8&pagemode=iframe
Request path: /TEST/_root/homepage.aspx
User host address: 172.30.4.26
User: MERKEZ\ahmet.sancar 
Is authenticated: True
Authentication Type: Negotiate
Thread account name: MERKEZ\SVC_CRMAPP

Thread information:
Thread ID: 15
Thread account name: MERKEZ\SVC_CRMAPP
Is impersonating: False
Stack trace: at Microsoft.Crm.Query.Expression.ValidateAlias(String alias)
at Microsoft.Crm.Query.ColumnSetExpression.AddColumnWithAlias(String attributePlatformName, String alias)
at Microsoft.Crm.ApplicationQuery.HierarchyAwareRetrieveMultipleCommand.DecorateQuery()
at Microsoft.Crm.ApplicationQuery.BuildQuery()
at Microsoft.Crm.ApplicationQuery.GetViewData()
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.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)
at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)
at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at Microsoft.Crm.Web.EntityHomepage.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

==========================================================

Team entity doesn't comes with a default Hierarchy Rule defined, i added a Hierarchy Rule then same error occured Team entity lists.

Btw i can access user list via Advanced Find. We tried to reinstall many times but always get the same error with same alias.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Hosk Profile Picture
    Hosk on at

    I think you should raise a bug with Microsoft support, of you are getting errors without any customisation

  • Verified answer
    kadiresen Profile Picture
    kadiresen 30 on at

    Hi Ahmet,

    Please check CRM Application Service user's regional settings. They must be English (United States). Check them and try again.

    Kadir ESEN

  • Ugur YILMAZ Profile Picture
    Ugur YILMAZ 5 on at

    hi, we are having same issue here. we change the system user's region settings to US but still getting the same error. Are there any other way to resolve this problem?

  • Ahmet Sancar Profile Picture
    Ahmet Sancar 195 on at

    can you try changing language for non-unicode programs (system local) to english as well?

  • ISMAIL TUTUMLUER Profile Picture
    ISMAIL TUTUMLUER 399 on at

    Hi all,

    Does anynone solve this issues?

    language of  the installation MSCRM 2015 is  English,

    also language  of MSCRM Application Server non-unicode  is English,

    check all settings but the error occurred.

  • kadiresen Profile Picture
    kadiresen 30 on at

    Yes, we've solved. But interesting thing is that, you have installed english version of CRM and you are still having trouble, right? We've logged in CRM App Server as AppService user of CRM. And changed this users regional settings to English (USA).

    In Turkish: Selam İsmail, çok şükür biz sorunu çözdük, dilerseniz yardımcı olabiliriz. Engin Bey ve Mehmet Bey'e çok selamlar. İletişim bilgilerim kendilerinde mevcut. İyi çalışmalar.

  • ISMAIL TUTUMLUER Profile Picture
    ISMAIL TUTUMLUER 399 on at

    Kadir thanks for your an advanced.  For a crm application server , Current Language for non- Unicode programs is English, the printscreen is below.  I have completed installation ,both of languages(English,Turkish) . but  an error occurred on these pages(useradd ,.. eg). I will check  domain controller's non-unicode.

     

  • ISMAIL TUTUMLUER Profile Picture
    ISMAIL TUTUMLUER 399 on at

    I've temporarily disabled HierarchyRule  then the error disappeared

    update [CRM_MSCRM].[dbo].[HierarchyRuleLogicalAsIfPublished] set ComponentState = 1

    update [CRM_MSCRM].[dbo].[HierarchyRuleLogical] set ComponentState = 1

    update[CRM_MSCRM].[dbo].[HierarchyRuleAsIfPublished] set ComponentState = 1

    update [CRM_MSCRM].[dbo].[HierarchyRule] set ComponentState = 1

  • ISMAIL TUTUMLUER Profile Picture
    ISMAIL TUTUMLUER 399 on at

    I tried some scenarios -

    SQL Server Collation Turkish_CI_AS ,

    CRM Application Server Setup Language Turkish

    Organization Collation Latin1_General_CI_AI

    CRM Application Server Setup  Unicode English

    an error occurred

    SQL Server Collation Turkish_CI_AS ,

    CRM Application Server Setup Language Turkish

    Organization Collation Turkish_CI_AI

    CRM Application Server Setup  Unicode English

    an error occurred

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Kadir thanks for the advice. I also solved. I changed regional before you reinstall the CRM 2015. I think the important point here, we must pay attention to the user in the application service.

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