Hello,

 

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()
ClientConnectionId:1073d36a-5669-49f5-b837-be566abc1aa7

 

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?

 

Regards