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 - 9/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?

2 Replies

Reply to Thread
Grady Werner Replied
Employee Post
What version were you running before? Was it a custom build or a production release?

In the meanwhile, you can also just create a new blank table called st_ThreadSubscriptions, as it will just get deleted with the script anyways. (it got replaced with a different table instead)
Grady Werner SmarterTools Inc. www.smartertools.com
Webio Replied
I've reverted my files (I didn't restored DB) from my daily backup and my current version is 10.1.5318.15331 (I was downloading it from ST website so I assume this is production release).

First thing which I've done was creating empty table with this name but error still occured. I'll try this again later after working hours.

Reply to Thread