Invalid object name 'dbo.Object Tracking'.

manisharma31

When i am trying to start the RTC service i am getting the below error logged in the event viewer.

Service: MicrosoftDynamicsNavServer$ClientLIVE
User: domain\userid
Type: System.Data.SqlClient.SqlException
Class: 16
LineNumber: 1
Number: 208
Server: Navision
State: 1
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
Message: Invalid object name 'dbo.Object Tracking'.StackTrace:
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.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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.ExecuteReader()
at Microsoft.Dynamics.Nav.Runtime.NavDatabaseChangeListener.RegisterNotification()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

What could be the issue.

mohana_cse06

is it a 3tier on 3 machines?
if yes, have u activated change listenert?
did u try y compiling all objects?

manisharma31

No its not a three tier.

Yes i have compiled all the objects.

Actually,
I have restored the backup without application objects & after i have imported the objects.

mohana_cse06

try this
http://msdn.microsoft.com/en-us/library/dd568739.aspx