Latest SmarterTrack upgrade process returns error: Cannot find the object "dbo.st_ThreadSubscriptions" because it does not exist or you do not have permissions.
Problem reported by Webio - September 8, 2014 at 11:21 PM
I've downloaded latest (10.2.5364) SmarterTrack and during upgrade process I'm getting error:
Error executing the following:

Cannot find the object "dbo.st_ThreadSubscriptions" because it does not exist or you do not have permissions.

Problem: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.st_ThreadSubscriptions" because it does not exist or you do not have permissions.
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SmarterTrack.Data.DataLayerShortcut.ExecuteNonQueryWithWait(String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Database.AlterTableTask.Execute(DBProperties props)
   at SmarterTrack.HelperClasses.Threads.DatabaseUpgradeThread.ThreadFunc()
Intersting part is that when I've changed DB table prefix and restarted ST application pool it has started creating new tables in DB and there was also no table with name st_ThreadSubscriptions in clean install. Can someone from ST check this issue?

Reply to Thread