Dear All, We have a client that is running MOSS in production on a single server with SQL server 2005 installed. We are getting the following error on a regular basis and was wondering if anyone has come across this before and how to get around it.
They are NOT running WSS/MOSS SP1 but have SQL SP2 + hotfixes installed. Any thoughts? The error is as follows: ****************************************************************** A runtime exception was detected. Details follow. Message: Could not find stored procedure 'proc_ar_BumpCacheInvalidationCounter'. Techinal Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'proc_ar_BumpCacheInvalidationCounter'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.ApplicationRegistry.MetadataModel.DataAccess.AbstractMaterializer.DistributedCacheInvalidate(Type metadataObjectType, Boolean objectCache) at Microsoft.Office.Server.ApplicationRegistry.MetadataModel.DataAccess.AbstractMaterializer.DistributedCacheInvalidate() at Microsoft.Office.Server.ApplicationRegistry.Infrastructure.SqlSessionProvider.SetSharedResourceProviderToUse(String sharedResourceProviderName) at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. ****************************************************************** Cheers, Aaron Aaron Saikovski Senior Solutions Specialist – Information Worker M: +61 (0) 410 480 971 P: 02 9276 2728 F: 02 9276 2799 A: Level 7, 15-17 Young Street, Sydney NSW 2000 E: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> W: www.sdm.com.au <http://www.sdm.com.au/> strategic data management Consult ♦ Develop ♦ Integrate ♦ Deliver Microsoft Application Infrastructure Development Partner of the Year 2007 Business Performance Management l Business Consulting l Customer Relationship Management Enterprise Project Management l Information Worker l Systems Integration This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of Strategic Data Management Pty Ltd. Please consider the environment before printing this email.