Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Altiris Console after installing Altiris Client Management Suite fails with an Exception

Updated: 21 May 2010 | 1 comment
ansis.developer's picture
0 0 Votes
Login to vote

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?

 

Comments

jharings's picture
10
Jul
2009
0 Votes 0
Login to vote

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.