Missing Stored Procedure "spPreLoadResourceCache" from the Symantec_CMDB

Updated: 23 May 2010 | 13 comments

0 0 Votes

Hello,

I receive an exception all the time when I try to open some specific tabs from "Altiris Console 7.0". It looks that "spPreLoadResourceCache" stored procedure is missing from "ALTIRIS-CLIENT\Databases\Symantec_CMDB\Programmability\Stored Procedures" path and any of it's subfolders. Other procedures still are there. Any workarounds? I just installed a fresh instance of Client Management Suite, but it simply does not work. Here is the exception:

Server Error in '/Altiris/NS' Application.
--------------------------------------------------------------------------------

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) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
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) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Utilities_DataAccessLayerDbUtilsDAL.spPreLoadResourceCache__Flattened(String entityGuids) +333
Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Utilities_DataAccessLayerDbUtilsDAL.spPreLoadResourceCache(List`1 entityGuids) +590
Altiris.NS.Utilities.ResourceHelper.PreLoadResourceCache(IEnumerable`1 entityGuids) +439
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) +408
Altiris.NS.Tree.TreeBuilder.ApplyFilter(ITreeFilter filter, TreeFragment tree, ISet`1 newNodes) +44
Altiris.NS.Tree.TreeBuilder.ApplyFilters(TreeFragment tree, ISet`1 newNodes) +84
Altiris.NS.Tree.QueryItemTreeBuilder.RetrieveTreeFragmentRecursive(TreeFragment tree, IList`1 nodes, Int32 depth, IDictionary`2 overridesUsed) +4111
Altiris.NS.Tree.TreeBuilder.RetrieveFragment(IList`1 nodes, Int32 depth) +672
Altiris.NS.Tree.TreeBuilder.RetrieveFragment(Int32 depth) +29
Altiris.NS.UI.DataProviders.NSScopedTreeViewProvider.GetNode(IList`1 nodesList, Int32 depth) +124
Altiris.NS.UI.DataProviders.NSTreeViewProvider.GetTreeNodes(Int32 depth) +46
Altiris.WebControls.TreeViewControl.BindTreeControl() +293
Altiris.WebControls.TreeViewControl.DataBindControl() +88
Altiris.WebControls.TreeViewControl.OnPreRender(EventArgs e) +16
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

discussion Filed Under:

Endpoint Management, Symantec Management Platform (Notification Server)

Comments RSS Feed

Comments

Jul

2009

0 Votes 0

jharings

Trusted Advisor

How are you logged on when you install?

I haven't seen this with v7, however installing while logged directly onto a server, or using a /admin "console 0" session in RDP is the preferred method. Any other way of installing can lead to database issues.

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.

Jul

2009

0 Votes 0

ansis.developer

What do you mean by

What do you mean by "installing while logged directly onto a server, or using a /admin "console 0" session in RDP" ?

I installed Client Management Suite directly while being logged on as a Local Administrator. Also I used Symantec Installation Manager to install CMS.

Are there any other option to install CMS?

Thank you!

Jul

2009

0 Votes 0

jharings

Trusted Advisor

Logged on directly

= being physically in front of a server, with the blue\green glow from the screen lighting your face, and the hum of the air conditoners (if you are in a data center) slowly lulling you to sleep.

/admin or console 0 is achieved by running mstsc.exe /admin (or /console, depending on your version of Windows). When you open Terminal Services manager, you can see the session id's in use. If you use the following method the session id will be "0".

This, and logging on as the account used to run Altiris prevents system impersonation issues, which can cause trouble with database tables.

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.

Jul

2009

0 Votes 0

ansis.developer

Symantec products s**k?

I was installing it directly with my feet very near to the PC, because I wanted to kick off that f****g box, which did not install properly CMS.

The sad part of this is that I am not the only one encountering these installation issues with CMS(or SMS) and Symantec SUPPORT REALLY DO NOT CARE ABOUT IT! Here is another post: https://www-secure.symantec.com/connect/forums/bug... . Also I received some private mails, so there are lot more people who failed to install CMS.

I would like to hear from Altiris support If they suceed installing fresh CMS within last 4 weeks. Well I and many others didn't! Is Symantec trying to sell non working software?

Jul

2009

0 Votes 0

jharings

Trusted Advisor

Ok, I was trying to add a little humor

and you didn't take it well. I'll have to let you know this is primarily a USER supported forum. Some of us work for partners, and occasionaly support will stop by to lend a hand. NS\CMS7 is relatively new, so there some bugs to be expected. I agree, there have been some frustrations with the new version. I can assure you there are many people who have installed CMS7 fresh, unfortunately, most of them won't take time to PM.

If you don't like the support here, I suggest you call Symantec. Thanks for your time.

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.

Jul

2009

0 Votes 0

ansis.developer

No it is OK, If you are not

No it is OK, If you are not from Symantec Support then you are my friend :)

At least from what I have observed Symantec employees also take a look into these forums. At least for other products like Backup Exec. Unfortunately Altiris do not have a such good support :(

Jul

2009

0 Votes 0

jharings

Trusted Advisor

I have asked support to take a look at this

which as you have noticed, sometimes they will. Did you see my other comment about the .net version (3.5SP1)? It has been know to break a great many things.

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.

Jul

2009

0 Votes 0

ansis.developer

Yes, I have .NET 3.5 with SP1

Yes, I have .NET 3.5 with SP1 installed.

I am really looking forward to cooperate with symantec to solve this issue.

Jul

2009

0 Votes 0

jharings

Trusted Advisor

SP1 is not supported and can cause some serious issues

Try following the directions posted here. 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.

Jul

2009

0 Votes 0

ansis.developer

Just removed .NET 3.5 with

Just removed .NET 3.5 with SP1 and installed .NET 3.5.

Now there is a issue, that port 80 do not accept incoming connections - so Altiris Console 7.0 do not work at all. I am wondering if this might have to do something with IIS.

Jul

2009

0 Votes 0

ansis.developer

Here is a screenshot, that

Here is a screenshot, that confirms, that IIS is serving the Altiris Console Web page, but it is not responsive to th Browswe or SIM. imagebrowser image

Jul

2009

0 Votes 0

ansis.developer

I will try it out

Ok, I will try to install without .NET 3.5 SP1. Then I will report whatever I suceeded.

Jul

2009

0 Votes 0

jharings

Trusted Advisor

Check the web service extensions and make sure

that ASP.NET v2.0.50727 is allowed. The removal and reinstall disables this.

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.

Missing Stored Procedure "spPreLoadResourceCache" from the Symantec_CMDB

Comments

Would you like to reply?

Links

Technical Support

Symantec.com

Store

Community Stats