Smarter Track crashes AND crashes Application Pool AND crashes IIS process too
Problem reported by TechSavvySam - 1/25/2015 at 6:33 AM
Resolved
This bug started showing up out of nowhere in September 2014.  At the time I was running on 9.5.5091.
 
I just got around to tracking down the problem and trying to fix it, so I upgraded to 9.5.5318 (the last available version of 9) but the problem still keeps happening.
 
When SmarterTrack crashes, it takes out its own application pool, AND it kills IIS, which before now I thought was impossible.  I thought one of the main points of having application pools was to isolate applications from each other in IIS.  Apparently this is NOT always the case.  
 
When this issue happens, there are 3 event log entries: 2 regarding the crash of SmarterTrack and 1 regarding it taking out IIS along with it.  One other bit of information is that I've checked the weblogs and there's nothing accessing the web interface when these crashes happen, so it is coming out of some internally triggered event.
 
----------------------------------------------------------------------------------------------------
Event Log: Application
Source: ASP.NET 4.0.30319.0
Event ID: 1325
1/23/2015 7:12:06 PM

     An unhandled exception occurred and the process was terminated.
Application ID: /LM/W3SVC/2/ROOT
Process ID: 2380
Exception: System.Data.SqlClient.SqlException
Message: Violation of PRIMARY KEY constraint 'PK_st_GlobalSettings'. Cannot insert duplicate key in object 'dbo.st_GlobalSettings'. The duplicate key value is (Options, thread_indexerrunning).
The statement has been terminated.
StackTrace:    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()
   at Microsoft.ApplicationBlocks.Data.SqlHelperInternal.ExecuteReader(SqlConnection , SqlTransaction , CommandType , String , SqlParameter[] , #XZc )
   at SmarterTrack.Data.GlobalSettingEntityBase.Save_SQL(IDbConnection& connection)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save(IDbConnection& connection)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save()
   at SmarterTrack.Data.GlobalSettingEntity.SetSetting(D v, String val)
   at SmarterTrack.MRS.Global.indexEngine_ThreadLoopBeginning(Object sender, ThreadLoopEventArgs e)
   at SmarterTools.Indexing.Engine.#cac()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

----------------------------------------------------------------------------------------------------
Event Log: Application
Source: .NET Runtime
Event ID: 1026
1/23/2015 7:12:06 PM
 
     Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Data.SqlClient.SqlException
Stack:
   at Microsoft.ApplicationBlocks.Data.SqlHelperInternal.ExecuteReader(System.Data.SqlClient.SqlConnection, System.Data.SqlClient.SqlTransaction, System.Data.CommandType, System.String, System.Data.SqlClient.SqlParameter[], #XZc)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save_SQL(System.Data.IDbConnection ByRef)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save(System.Data.IDbConnection ByRef)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save()
   at SmarterTrack.Data.GlobalSettingEntity.SetSetting(D, System.String)
   at SmarterTrack.MRS.Global.indexEngine_ThreadLoopBeginning(System.Object, ThreadLoopEventArgs)
   at SmarterTools.Indexing.Engine.#cac()
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   at System.Threading.ThreadHelper.ThreadStart()

----------------------------------------------------------------------------------------------------
Event Log: Application
Source: Application Error
Event ID: 1000
1/23/2015 7:12:07 PM
 
     Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2
Faulting module name: KERNELBASE.dll, version: 6.1.7601.18409, time stamp: 0x5315a05a
Exception code: 0xe0434352
Fault offset: 0x000000000000940d
Faulting process id: 0x94c
Faulting application start time: 0x01d036fa96dd367e
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: a174fc6f-a35d-11e4-ad94-001c23b85f7b
 
 

14 Replies

Reply to Thread
0
Employee Replied
Employee Post
Hello TechSavvySam,
 
Thanks for the information on the error logs. Can you recall at the time what was being done in the application or if this is a random occurrence ?  How often does the application falter and what do you do to gain access again ?  I would like to know if you can provide us with a sample of the error log from the SmarterTrack directory.  The default location is: [C:\Program Files (x86)\SmarterTools\SmarterTrack\MRS\App_Data\Logs].
 
Please consider opening a Support ticket if you would like for us to review this matter further.
 
Thank you.
0
TechSavvySam Replied
here are the error log entries that correspond with the crash.  Looks like it's the chat stuff... The ASP.NET 4.0.30319.0 source event timestamp was 1/23/2015 7:12:06 PM.
 
I'll edit the thread above and add the timestamps.
 
 
 
=====================
[2015-01-23 7:12:02 PM]
Agent: N/A
Problem happened in the UserTrackingItemThread
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   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.WhosOnVisitorEntity.GetDictionaryByGuid()
   at SmarterTrack.HelperClasses.Tracking.UserTrackingItemList.Flush()
   at SmarterTrack.HelperClasses.Tracking.UserTrackingItemThread.#PJc()
ClientConnectionId:d0b84041-e088-47ee-a149-0aacc4f04cd4

=====================
[2015-01-23 7:12:06 PM]
Agent: N/A
Problem with ChatManagementThread
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   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.ChatEntity.GetUnfinishedChats()
   at SmarterTrack.HelperClasses.Threads.ChatManagementThread.#6Rd()
   at SmarterTrack.HelperClasses.Threads.ChatManagementThread.DoWork()
ClientConnectionId:fd525899-5459-4ede-a1e0-a61af7e7b74a
 
0
TechSavvySam Replied
I just realized I didn't answer your question of "how often".  Here's how often the crash with the reference to "PK_st_GlobalSettings" showed up:
 
2014-11-17 22:37:25.000
2014-11-18 16:45:56.000
2014-11-20 19:20:37.000
2014-11-28 12:04:47.000
2014-12-02 11:12:21.000
2014-12-05 21:20:38.000
2014-12-16 17:24:44.000
2014-12-26 22:32:46.000
2014-12-29 08:03:41.000
2015-01-08 23:00:33.000
2015-01-17 19:23:06.000
2015-01-22 00:50:01.000
2015-01-23 19:12:06.000
2015-01-27 01:09:17.000
 
(yes, one early this morning)  I have since disabled "Who's On" to see if it stops the issue.
 
I also (think) I disabled live chat.  I'm not exactly sure how to do this, but I did the following:
 

Live Chats / Live Chat Links / Support / Enable for Support Department = unchecked

Live Chats / Live Chat Settings - couldn't find anything to turn off

Organizaiton / Brands / My Company Name / Who's On / Track portal visitors in Who's On - unchecked

Organization / Departments  / Sales Department / Options / Enable Live Chat - unchecked

Organization / Departments  / Support Department / Options / Enable Live Chat - unchecked

Portal / Portal Settings / Options / Display live chat link - was already unchecked

 

 

 

0
Steve Reid Replied
Is this issue resolved? Curious as to why it's status is not a problem..
 
0
TechSavvySam Replied
Not resolved. YES it is a problem, but this forum UI doesn't retain that status when displaying it, even though it shows it when I'm editing the initial post.
0
TechSavvySam Replied
IMO Microsoft ALSO has a problem here as an fatal application crash inside an application pool shouldn't crash the IIS process.  I would classify this as a DoS vulnerability.
0
TechSavvySam Replied
It just crashed again.  How do I completely disable Chat code?  I either have to do that or completely shut down SmarterTrack as this continual crashing is affecting other applications on my web server.
 
Here's the log file entry:
 
=====================
[2015-01-27 8:31:49 PM]
Agent: N/A
Problem with ChatManagementThread
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   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.ChatEntity.GetUnfinishedChats()
   at SmarterTrack.HelperClasses.Threads.ChatManagementThread.#6Rd()
   at SmarterTrack.HelperClasses.Threads.ChatManagementThread.DoWork()
ClientConnectionId:c2d02ad8-3820-4131-a5ab-a53359c1e61e
 
And the 4 event log entries:
 
--------------------------------------------------------------------------------------------------------------
2015-01-27
20:31:48
Application
ASP.NET 4.0.30319.0
1325  
     An unhandled exception occurred and the process was terminated.
Application ID: /LM/W3SVC/2/ROOT
Process ID: 3012
Exception: System.Data.SqlClient.SqlException
Message: Violation of PRIMARY KEY constraint 'PK_st_GlobalSettings'. Cannot insert duplicate key in object 'dbo.st_GlobalSettings'. The duplicate key value is (Options, thread_indexerrunning).
The statement has been terminated.
StackTrace:    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()
   at Microsoft.ApplicationBlocks.Data.SqlHelperInternal.ExecuteReader(SqlConnection , SqlTransaction , CommandType , String , SqlParameter[] , #XZc )
   at SmarterTrack.Data.GlobalSettingEntityBase.Save_SQL(IDbConnection& connection)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save(IDbConnection& connection)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save()
   at SmarterTrack.Data.GlobalSettingEntity.SetSetting(D v, String val)
   at SmarterTrack.MRS.Global.indexEngine_ThreadLoopBeginning(Object sender, ThreadLoopEventArgs e)
   at SmarterTools.Indexing.Engine.#cac()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
--------------------------------------------------------------------------------------------------------------
2015-01-27
20:31:48
Application
.NET Runtime
1026  
     Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Data.SqlClient.SqlException
Stack:
   at Microsoft.ApplicationBlocks.Data.SqlHelperInternal.ExecuteReader(System.Data.SqlClient.SqlConnection, System.Data.SqlClient.SqlTransaction, System.Data.CommandType, System.String, System.Data.SqlClient.SqlParameter[], #XZc)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save_SQL(System.Data.IDbConnection ByRef)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save(System.Data.IDbConnection ByRef)
   at SmarterTrack.Data.GlobalSettingEntityBase.Save()
   at SmarterTrack.Data.GlobalSettingEntity.SetSetting(D, System.String)
   at SmarterTrack.MRS.Global.indexEngine_ThreadLoopBeginning(System.Object, ThreadLoopEventArgs)
   at SmarterTools.Indexing.Engine.#cac()
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   at System.Threading.ThreadHelper.ThreadStart()
--------------------------------------------------------------------------------------------------------------
2015-01-27
20:31:49
System
Microsoft-Windows-WAS
5011  
     A process serving application pool 'SmarterTrack' suffered a fatal communication error with the Windows Process Activation Service. The process id was '3012'. The data field contains the error number.
--------------------------------------------------------------------------------------------------------------
2015-01-27
20:31:49
Application
Application Error
1000  
     Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2
Faulting module name: KERNELBASE.dll, version: 6.1.7601.18409, time stamp: 0x5315a05a
Exception code: 0xe0434352
Fault offset: 0x000000000000940d
Faulting process id: 0xbc4
Faulting application start time: 0x01d039f820cc0ae2
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: 6d55e5ad-a68d-11e4-9ca6-001c23b85f7b
 
0
TechSavvySam Replied
seems like it should be fairly easy to track this problem down--you're trying to insert a row into st_GlobalSettings that is already there:
 
SettingCategory SettingName        	SettingValue
Options         thread_indexerrunning	True
 
and I've given you the code tracebacks.
0
Steve Reid Replied
Why wouldn't you open a support ticket to get proper support?
0
TechSavvySam Replied
because I've had limited success with going that route in the past.
0
Steve Reid Replied
That seems like a ridiculous statement... The best method for support is via a ticket. You think community forums could help better than paid professionals with such a specific problem? They may need access to your server via RDP or other such things which is done via a Ticket.
0
TechSavvySam Replied
Steve, please go troll somewhere else. Your "help" is not welcome here.
0
Employee Replied
Employee Post
Hello,
 
Hmm... Could try deleting the duplicated field from the Database to fix it if you have access to the DataBase? But this may not be the source of the problem and could potentially cause other issues ( so maybe grab a backup of the Database before trying it) or you could try updating to a newer version?

Recreating the issue, debugging it with a Database backup, and either cleaning the DB with a query or fixing a bug would be a part of solving this. If this is still not resolved, and its a show stopper i would highly recommend on putting in a support ticket.
2
Grady Werner Replied
Employee Post
The exceptions that were causing the event log entries were taken care of in version 10.5.5515, released in February.  They related to indexing.
Grady Werner
Development Manager
SmarterTools Inc.
(877) 357-6278
www.smartertools.com

Reply to Thread