Getting error "Failed to refresh the LinkRegion 'ViewPanel' " in the NS logs when trying to run Reports on NS7.
search cancel

Getting error "Failed to refresh the LinkRegion 'ViewPanel' " in the NS logs when trying to run Reports on NS7.

book

Article ID: 151990

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

When running Reports in the Altiris Console, the following error appeared after changing the AppID account:

Priority: 1
Date: 12/15/2009 4:12:30 PM
Tick Count: 2557843
Host Name: ServerName
Process: w3wp (6256)
Thread ID: 50
Module: w3wp.exe
Source: Altiris.Reporting.Common.ControlLinking.Controls.LinkRegion.RaiseCallbackEvent
Description: Failed to refresh the LinkRegion 'ViewPanel'.

( Exception Details: Altiris.DataSource.Exceptions.DataSourceRunException: An error occurred attempting to run the raw SQL DataSource. ---> Altiris.NS.Exceptions.DatabaseNotReadyException: Failed to construct DatabaseContext object. Connection to database failed. ---> Altiris.NS.Exceptions.AeXException: Failed to open database connection. Current user is DOMAIN\JohnDoe. Error: Login failed for user 'myOldUser'. ---> System.Data.SqlClient.SqlException: Login failed for user 'myOldUser'.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Altiris.NS.Utilities.DbUtils.OpenConnection(SqlConnection dbConn)
   --- End of inner exception stack trace ---
   at Altiris.NS.Utilities.DbUtils.OpenConnection(SqlConnection dbConn)
   at Altiris.NS.Utilities.DbUtils.CreateConnection(String server, String catalog, String user, String password)
   at Altiris.NS.Utilities.DbUtils.CreateReportConnection()
   at Altiris.NS.ContextManagement.ReportingDatabaseContext.OpenDbConnection()
   at Altiris.Database.DatabaseContext`1.Initialize(Boolean beginTransaction, IsolationLevel isolationLevel)
   --- End of inner exception stack trace ---
   at Altiris.NS.ContextManagement.ReportingDatabaseContext.ThrowDatabaseNotReadyException(String exceptionDetails, Exception innerException)
   at Altiris.Database.DatabaseContext`1.Initialize(Boolean beginTransaction, IsolationLevel isolationLevel)
   at Altiris.Database.DatabaseContext`1.GetContext(Boolean createNewTransaction, IsolationLevel isolationLevel, Boolean independentContext)
   at Altiris.Database.DatabaseContext`1.GetContext(Boolean createNewTransaction, IsolationLevel isolationLevel)
   at Altiris.Database.DatabaseContext`1.GetContext(Boolean createNewTransaction)
   at Altiris.Database.DatabaseContext`1.GetContext()
   at Altiris.NS.ContextManagement.DatabaseContext.GetContext(ContextIdentity identity)
   at Altiris.Reporting.DataSource.RawSqlDataSource.GetDatabaseContext()
   at Altiris.Reporting.DataSource.RawSqlDataSource.Run()
   --- End of inner exception stack trace ---
   at Altiris.Reporting.DataSource.RawSqlDataSource.Run()
   at Altiris.Reporting.Report.Run()
   at Altiris.Reporting.UI.ReportViewControl.DataBind(Boolean raiseOnDataBinding, DataBindMode mode)
   at Altiris.Reporting.Controls.StandardReportViewControl.DataBind(Boolean raiseOnDataBinding, DataBindMode mode)
   at Altiris.Reporting.Controls.StandardReportViewControl.DataBind(DataBindMode mode)
   at Altiris.Reporting.Controls.StandardReportViewControl.reportViewPanel_Refresh(Object sender, LinkRegionRefreshArgs e)
   at Altiris.Reporting.Common.ControlLinking.Controls.LinkRegion.OnRefresh(LinkRegionRefreshArgs args)
   at Altiris.Reporting.Common.ControlLinking.Controls.LinkRegion.RaiseCallbackEvent(String eventArgument) )
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.Diagnostics.Logging.EventLog.ReportException(String strMessage, String category, Exception exception)
   at Altiris.NS.Logging.EventLog.ReportException(String strMessage, Exception exception)
   at Altiris.Reporting.Common.ControlLinking.Controls.LinkRegion.RaiseCallbackEvent(String eventArgument)
   at Altiris.Reporting.Common.ControlLinking.Controls.LinkRegion.System.Web.UI.ICallbackEventHandler.GetCallbackResult()
   at System.Web.UI.Page.RenderCallback()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.report_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
   at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
   at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
 )
( Extra Details:  Type=Altiris.DataSource.Exceptions.DataSourceRunException Src=Altiris.Reporting.DataSource

  Inner Extra Details:  Type=Altiris.NS.Exceptions.DatabaseNotReadyException Src=Altiris.NS

  Inner Extra Details:  Type=Altiris.NS.Exceptions.AeXException Src=Altiris.NS

  Inner Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient Data Provider )

Cause

After changing the AppID account for your Notification Server there is a setting that may be still pointing to the old account rather than having the 'Use application credentials' selected for accessing Reports.

Resolution

Please verify the following:

1. Under the Altiris Console>Settings>Notification Server>Database Settings, under the 'Reports' tab verify that 'Use application credentials' is selected. You may have selected 'Use these credential' and the old account or password is still been used.

2. Check in the coreSettings.config file under "<customSetting key="ReportsUser" ...." setting that is has not the old AppID user in the value:
 <customSetting key="ReportsUser" type="local" value="myOldUser" />

If you are using 'application credentials' it should be empty:
 <customSetting key="ReportsUser" type="local" value="" />


Applies To
Symantec Management Platform 7.0

Powered by Wolken Software