Altiris Console after installing Altiris Client Management Suite fails with an Exception
Updated: 21 May 2010 | 1 comment
Altiris console always fails to start. Here is the output from IE 7.0 when I open "Start/Programs/Altiris/Altiris Console 7.0":
Could not find stored procedure 'spPreLoadResourceCache'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'spPreLoadResourceCache'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Could not find stored procedure 'spPreLoadResourceCache'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31 System.Data.SqlClient.SqlDataReader.get_MetaData() +62 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9 Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Utilities_DataAccessLayerDbUtilsDAL.spPreLoadResourceCache__Flattened(String entityGuids) +310 Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Utilities_DataAccessLayerDbUtilsDAL.spPreLoadResourceCache(List`1 entityGuids) +438 Altiris.NS.Utilities.ResourceHelper.PreLoadResourceCache(IEnumerable`1 entityGuids) +362 Altiris.NS.Security.SecurityCache.Demand(ISet`1 entityGuids, ISet`1 requiredPermissions, ISet`1 membership) +224 Altiris.NS.Tree.Filters.SecurityTreeFilter.Filter(ISet`1 nodes, TreeFragment tree) +410 Altiris.NS.Tree.TreeBuilder.ApplyFilter(ITreeFilter filter, TreeFragment tree, ISet`1 newNodes) +44 Altiris.NS.Tree.TreeBuilder.ApplyFilters(TreeFragment tree, ISet`1 newNodes) +73 Altiris.NS.Tree.QueryItemTreeBuilder.RetrieveTreeFragmentRecursive(TreeFragment tree, IList`1 nodes, Int32 depth, IDictionary`2 overridesUsed) +2899 Altiris.NS.Tree.TreeBuilder.RetrieveFragment(IList`1 nodes, Int32 depth) +468 Altiris.NS.Tree.TreeBuilder.RetrieveFragment(Guid node, Int32 depth) +72 Altiris.NS.UI.ItemListViewProvider.GetItemListView(Guid treeGuid, Guid itemGuid, Page page) +762 Altiris.NS.UI.ItemListView.GetData() +119 Altiris.NS.UI.ItemListView.Page_Load(Object sender, EventArgs e) +1119 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
I have:
1)Microsoft SQL Server 2005
2)Windows 2003 Server(x86) with latest updates
Any hints about what might be wrong? Maybe this is a issue with MS SQL not with Altiris?
discussion Filed Under:
Comments
A bit of a trend here
but you never know what'll show up in a search, and I like to cover the bases. .Net 3.5 SP1 is not supported and can cause issues. See Altiris KB46492
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
Would you like to reply?
Login or Register to post your comment.