Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Collaboration > SQL Server Error Received when Adding external user
Ask a questionAsk a question
Search Forums:
 

AnswerSQL Server Error Received when Adding external user

  • Monday, October 19, 2009 12:57 PMTrimus Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    When a user attempts to add a new External User they get the following message on screen:

    Exception from HRESULT: 0x80040E14   at Microsoft.SharePoint.Library.SPRequestInternalClass.GetAllRolesForCurrentUser(String bstrUrl, Guid guidScopeId, UInt32& pdwRowCount, Object& pvarRoleData)
       at Microsoft.SharePoint.Library.SPRequest.GetAllRolesForCurrentUser(String bstrUrl, Guid guidScopeId, UInt32& pdwRowCount, Object& pvarRoleData)
    Looking in the log files the following error appears relevant:

    <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->

    10/19/2009 11:21:08.42 w3wp.exe (0x0D6C)                         0x125C      CMS                                  Publishing                          8tvn  Unexpected  Unable to retrieve parent node for item at: /peopleservices/FRT/north/vitry_johnson of type: Area. This may be expected if changes have been made as the System Account, or if this is a POST request, request type: GET     

    10/19/2009 11:21:08.88 w3wp.exe (0x0D6C)                         0x142C      CMS                                 Publishing                          8tvn  Unexpected  Unable to retrieve parent node for item at: /peopleservices/FRT/north/vitry_johnson of type: Area. This may be expected if changes have been made as the System Account, or if this is a POST request, request type: GET     

    10/19/2009 11:21:08.89 w3wp.exe (0x0D6C)                         0x142C      Windows SharePoint Services     Database                             6f8g  Unexpected  Unexpected query execution failure, error code 102. Additional error information from SQL Server is included below. "Incorrect syntax near ')'." Query text (if available): "SELECT DISTINCT ra.RoleId FROM RoleAssignment AS ra WHERE ra.ScopeId = '7307286E-DCAE-4319-B096-F6FD02FF665E' AND ra.PrincipalId IN (SELECT DISTINCT ra.RoleId FROM RoleAssignment AS ra WHERE ra.ScopeId = '7307286E-DCAE-4319-B096-F6FD02FF665E' AND ra.PrincipalId IN (1,1506,1546,1549,1552,1553,1596,1654,1675,1689,1690,1694,1707,1708,1747,1748,1803,1924,1925,1929,1930,1932,1933,1935,1936,2079,2080,2087,2105,2106,2475,2476,2478,2479,2482,2483,2506,2507,2522,2523,2525,2526,2528,2580,2581,2583,2584,2585,2649,2650,2653,2654,2673,2674,2763,2764,2806,2807,2808,2814,3078,3079,3081,3082,3084,3085,3087,3088,3096,3097,3098,3109,3110...   

    10/19/2009 11:21:08.89* w3wp.exe (0x0D6C)                         0x142C      Windows SharePoint Services     Database                            6f8g  Unexpected      ...,3111,3220,3221,3240,3241,1480 )"     

    10/19/2009 11:21:08.89 w3wp.exe (0x0D6C)                         0x142C      Windows SharePoint Services     General                             8e2s  Medium      Unknown SPRequest error occurred. More information: 0x80040e14     


    There appears to be a missing closing brace in the sql statemant.
    Is this a known issue?
    Regards
    Alan
     

Answers

All Replies