web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Role center: error accessing database

(0) ShareShare
ReportReport
Posted on by 345

Greetings,

After installing SP and EP.

From AX when I open the Role Center from System Administrator => User Profiles and then View Role Center. It give following error:

An unhandled error has occured. To vide details about this error, enable debugging in tehweb.config file or
view the windows event logs.

Event log as follows :

An unhandled error has occurred. To view details about this error, enable debugging in the web.config file or view the Windows event logs.

Either the user, domain\axadmin, does not have access to the Dynamics AX initial database, or the database does not exist.

Microsoft SQL Server 2014 Analysis Services

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.AnalysisServerHelper.FillTable(DataTable table, IDbCommand cmd)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.AnalysisServerHelper.ExecuteQuery(String mdxQuery, IEnumerable`1 userParameters)
at CustCashInflowvsCashOutflow.GetCompanyAccountingCurrency()
at CustCashInflowvsCashOutflow.SetDefaultReportParameterValues()
at CustCashInflowvsCashOutflow.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

*This post is locked for comments

I have the same question (0)
  • Mazherullah Profile Picture
    345 on at
    RE: Role center: error accessing database

    Hi Juan,

    Yes..its same.

    REgards

  • Juan Rafael Profile Picture
    405 on at
    RE: Role center in AX 2012 r3

    Hi.

    The account assigned to the AOS must be the same as the SSAS administrator account.

    Regards,

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans