locked
MDS Review Validation Issues - An unhandled exception has occurred RRS feed

  • Question

  • I am having issues with MDS - Review Validation Issues.

    getting unknown error.

    Event code: 3005

    Event message: An unhandled exception has occurred.

    Event time: 9/13/2012 4:34:37 PM

    Event time (UTC): 9/13/2012 11:34:37 PM

    Event ID: 0126efe54d9548a3a0860c95e05c2f49

    Event sequence: 532

    Event occurrence: 24

    Event detail code: 0

     

    Application information:

        Application domain: /LM/W3SVC/1/ROOT/MDSOCR-2-129920511140786156

        Trust level: Full

        Application Virtual Path: /MDSOCR

        Application Path: C:\Program Files\Microsoft SQL Server\Master Data Services\WebApplication\

        Machine name: MDS2008

     

    Process information:

        Process ID: 3056

        Process name: w3wp.exe

        Account name: <>\<service account> 

    Exception information:

        Exception type: ServiceAdapterException

        Exception message: An error occurred while processing message request type 'ValidationGetRequest'. See exception details for more information.

     

    Request information:

        Request URL: <mds url>

        Request path: /MDSOCR/Explorer/ExplorerValidations.aspx

        User host address: <>

        User: <>

        Is authenticated: True

        Authentication Type: Negotiate

    <>\<service account>

     

    Thread information:

        Thread ID: 10

        Thread account name: <>\<service account> 

        Is impersonating: False

        Stack trace:    at Microsoft.MasterDataServices.WebUI.ServiceAdapter.InspectResponseForErrors(MessageRequest request, MessageResponse response)

       at Microsoft.MasterDataServices.WebUI.ServiceAdapter.ExecuteRequest[TRequestType,TResponseType](MdmServiceOperation`2 operation, TRequestType request)

       at Microsoft.MasterDataServices.WebUI.ServiceAdapter.GetValidationStatus(Int32 modelInternalId, Int32 versionInternalId, Nullable`1 entityInternalId, Nullable`1 memberType, String notificationUserName)

       at Microsoft.MasterDataServices.WebUI.UserControls.Common.Validations.LoadGrid()

       at Microsoft.MasterDataServices.WebUI.UserPages.Explorer.Validations.Page_Load(Object sender, EventArgs e)

       at System.Web.UI.Control.OnLoad(EventArgs e)

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    Tuesday, September 18, 2012 6:45 PM

Answers

  • Hi Sjupuddi68,

    Based on the error message, this issue might be caused by the accounts are not granted the VIEW SERVER STATE permission. To work around this problem, use an account that is a member of the system administrator fixed server role to manually grant permissions to the account designated to run the MDS application pool.
    For example, to manually grant the permissions, run the following commands:

    USE Master;
    GO
    GRANT VIEW SERVER STATE TO <<var>domain\MdsWebAppAccount</var>>;

    For more information, please refer to the following KB article:
    The MDS Validate Version command fails with a server error in SQL Server 2012: http://support.microsoft.com/kb/2711671

    Regards,


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Thursday, September 27, 2012 12:28 AM
    Sunday, September 23, 2012 10:38 AM