1
Errors regarding table name prefix in v10.2.5364
Problem reported by Cem Alacayir - September 18, 2014 at 6:18 AM
Resolved
Hi,
In previous versions (since v7.x), I had changed default table name prefix from "st_" to "st" and now I am stuck with it. I could change table names in SQL Server, however it seems the prefix is also used in other object names like indexes so I didn't want to mess it up.
 
The problem with v10.2.5364 is, some assemblies contains st_ThreadTags and st_Threads table names hardcoded as strings so I receive the below errors in my Errors.log. Also because of these errors Community does not work properly, ie. can not search, threads not listed properly etc. For your reference, I found these hardcoded table names in SmarterTrack.Data.dll and SmarterTrack.HelperClasses.dll.
 
Here are the errors:
Cache problem
Invalid object name 'st_ThreadTags'.
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'st_ThreadTags'.
   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.SqlDataReader.TryConsumeMetaData()
   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   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(CommandBehavior behavior)
   at SmarterTrack.Data.SqlHelperInternal.ExecuteReader(SqlConnection , SqlTransaction , CommandType , String , SqlParameter[] , #XZc )
   at SmarterTrack.Data.SqlHelperInternal.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at SmarterTrack.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at SmarterTrack.HelperClasses.Indexing.SearchHelper.ProcessData(String query, List`1 parameters, typeOfRead type)
   at SmarterTrack.HelperClasses.Indexing.ThreadSearchHelper.#9uf(ThreadSearchItem )
ClientConnectionId:b9684d81-6109-462c-84a7-ba78923e208f
 
Problem with the CommunityManagementThread
Invalid object name 'st_Threads'.
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'st_Threads'.
   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.SqlDataReader.TryConsumeMetaData()
   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   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.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at SmarterTrack.Data.EntityBase.GetListFromQueryInternal[T](IDbConnection& connection, String query, IDbDataParameter[] parameters)
   at SmarterTrack.Data.EntityBase.GetListFromQueryInternal[T](String query, IDbDataParameter[] parameters)
   at SmarterTrack.Data.ThreadUserFlagEntity.SubscriptionsToSendDigest()
   at SmarterTrack.HelperClasses.Threads.CommunityManagementThread.DoWork()
ClientConnectionId:633766a6-b9b2-4a1a-b18e-bd24de55b835
 
 
 

1 Reply

Reply to Thread
0
Employee Replied
November 13, 2014 at 4:11 PM
Employee Post
Hello,
I was able to find some coded in st_ prefix's. It will be fixed in the next minor. If you need the fix sooner contact support for a custom build. Let me know if its fixed for you!
Thanks,
-Ashley

Reply to Thread