7.0 - Routing Media Service logs showing SQL errors regarding an...

Expand / Collapse
 

7.0 - Routing Media Service logs showing SQL errors regarding an object that does not exist in CCMRouting database


Article ID: 52119 - Last Review: February 28, 2014

PROBLEM

After an installation, the Routing Media service log is throwing repeated SQL errors. 

No functional errors encountered in MCC.


SYMPTOMS

Routing Media Service Logs will be full of errors like the following:

Error: 1/17/2014 2:48:13 PM   SqlException Error Index # 0 | Message: The object '0.8' does not exist in database 'CCMRouting' or is invalid for this operation. | LineNumber: 117 Source: .Net SqlClient Data Provider | Procedure: proc_DatabaseUsageMonitor
--- Start Exception Stack ---
System.Data.SqlClient.SqlException (0x80131904): The object '0.8' does not exist in database 'CCMRouting' or is invalid for this operation.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, MergeOption mergeOption, Object[] parameters)
   at System.Data.Entity.Internal.InternalContext.ExecuteSqlQuery[TElement](String sql, Object[] parameters)
   at System.Data.Entity.Internal.InternalContext.ExecuteSqlQueryAsIEnumerable[TElement](String sql, Object[] parameters)
   at System.Data.Entity.Internal.InternalContext.ExecuteSqlQuery(Type elementType, String sql, Object[] parameters)
   at System.Data.Entity.Internal.InternalSqlNonSetQuery.GetEnumerator()
   at System.Data.Entity.Internal.InternalSqlQuery`1.GetEnumerator()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at prairieFyre.Routing.Common.WorkflowExtensions.Tracking.RouterDbTracker.AuditCcmRoutingDb()
ClientConnectionId:2d594386-d750-4474-8ae4-2478f6b53018
--- End Exception Stack ---



CAUSE

The proc_DatabaseUsageMonitor stored procedure did not successfully run in the CCMRouting database. 



RESOLUTION

Code is being added to ensure the correct execution of this stored procedure in our 7.0.1 release.

If you encounter this issue before 7.0.1 is available, restart the Routing Media Service.  This will re-run the stored procedure.



APPLIES TO

7.0 

Keywords: 7.0 routing media service sql error ccmrouting object exist



Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Monday, March 03, 2014
Last Modified By: andrew_montpetit
Type: FIX
Article not rated yet.
Article has been viewed 11,186 times.
Options