Invalid object name 'mydatabase.dbo.ASPStateTempApplications' RSS

• • Reply
  

  gmsaiful

  Member

  2 Points

  2 Posts

  Invalid object name 'mydatabase.dbo.ASPStateTempApplications'

  Sep 02, 2008 05:21 AM|LINK

  I have a database locally named "mydatabase". I take a backup and restored on Production server named as "mydb". Everything is fine but I am getting following error on a page which uses SQL CLR functions.

  System.Data.SqlClient.SqlException: Invalid object name 'mydatabase.dbo.ASPStateTempApplications'
  

     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 System.Web.SessionState.SqlSessionStateStore.SqlPartitionInfo.InitSqlInfo(SqlConnection sqlConnection)
     at System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo)
     at System.Web.SessionState.SqlSessionStateStore.GetConnection(String id, Boolean& usePooling)
     at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
     at System.Web.SessionState.SqlSessionStateStore.GetItemExclusive(HttpContext context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
     at System.Web.SessionState.SessionStateModule.GetSessionStateItem()
     at System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData)
     at System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

   Any Solution?

  Saiful
• • Reply
  

  bhadelia.imr...

  Contributor

  3191 Points

  533 Posts

  Re: Invalid object name 'mydatabase.dbo.ASPStateTempApplications'

  Sep 04, 2008 03:55 AM|LINK

  Do one thing, Remove the session tables and add it again.

  To Remove, use following command: [open visual studion command prompt]

  aspnet_regsql -ssremove -S [SERVER] -U [USER] -P [PWD] -d [DATABASE] -sstype c

  Then add them again by following command

  aspnet_regsql -ssadd -S [SERVER] -U [USER] -P [PWD] -d [DATABASE] -sstype c

   

  Imran
  [MCTS]
  Born to fly High
  http://knowledgebaseworld.blogspot.com/
  • Marked as answer by Wencui Qian - MSFT on Sep 08, 2008 11:17 AM