a.m. wrote:14 hours now with no errors....it is hard to be optimistic at this point, but I remain hopeful!
Great! Please write back about the progress in a couple of day
No joy...within about 4 hours of my last post, I had the familiar 3 errors occur again...
However....this time, they were immediately preceded (within 3 seconds) by two other errors and a warning that I have never seen before:
I have determined that our smartertrack support site threw the first 2 errors...not the nopcommerce site...(but the warning was on the nopC site's processID)...but it seems like more than just a coincidence that they would occur immediately before the familiar 3 errors...though I am still clueless as to how to fix it..
-------------NEW ERROR-------------------------------------------
An unhandled exception occurred and the process was terminated.
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.
-------------NEW ERROR------------------------------------------
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:...........
-------------NEW WARNING------------------------------------------
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/9/2014 2:35:11 AM
Event time (UTC): 5/9/2014 9:35:11 AM
Event ID: 19596b9569b740999c93d90db31f8389
Event sequence: 1958
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/5/ROOT-1-130440982224652500
Trust level: Full
Application Virtual Path: /
Application Path: C:\inetpub\wwwroot\THE_REAL_THING\
Machine name: WIN-DDE4FB9847H
Process information:
Process ID: 2880
Process name: w3wp.exe
Account name: IIS APPPOOL\MyFootShop
Exception information:
Exception type: SqlException
Exception message: Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=7605; [Login] initialization=0; authentication=0; [Post-Login] complete=22315;
------3 seconds later-----SAME 3 ERRORS ORIGINALLY POSTED------------------------