Security Role Problem in Dynamics CRM 2015 RRS feed

  • Question

  • Hi All,

    We have a problem about security roles. A person who have Department role and its team has User role cannot see the contact and some entity's record. Log is below.

    Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Error Number: 0x80044150

    Error Message: Generic SQL error.

    Error Details: Generic SQL error.

    Source File: Not available

    Line Number: Not available

    Request URL: http://localhost/Server/_root/homepage.aspx?etc=10044&pagemode=iframe&sitemappath=SFA%7cCustomers%7cps_pensioncontract

    Stack Trace Info: [CrmException: Generic SQL error.]

    Thursday, March 5, 2015 10:19 AM

All replies

  • Hello,

    It is not enough to help you. Generic SQL Error doesn't give much context. To get context you should do following:

    1. Turn on Trace.

    2. Recycle CRM App pool.

    3. Reproduce error.

    4. Recheck Trace file for explanation of exception.

    Dynamics CRM MVP
    My blog

    Thursday, March 5, 2015 10:23 AM
  • This block belongs Trace. Error is below. There is a syntax error. SQL cannot create the correct query.

    Exception: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.

    Thursday, March 5, 2015 12:11 PM
  • you could copy a role where it is visible and add them and take away the permision, there you see on what point when it is happening

    gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

    • Proposed as answer by Daniel Ovadia Monday, March 9, 2015 9:47 AM
    Thursday, March 5, 2015 12:57 PM
  • We find the error point. It occurs when user has a department role and its team has user role.
    Friday, March 6, 2015 9:02 AM