Hi all,

I came in this morning and was doing some last minute testing before launching our site.  I noticed I wasn't receiving email.  The problem was that the WindowsService was not running.  I looked in the log and found that an exception (see bottom) caused by SpyIIS was the culprit.  I restarted the service and the stat service failed once and then continued on.  The timing seems to coincide to when we have the App_Pool restart, but I'm not sure if that is what created the error.

What concerns me the most here is that emails for orders will not be received if this service crashes and then it may be a few days.  Any thoughts on preventing this?

-Cole

==================

2007-03-20 03:11:25,999 [2960] ERROR Mediachase.eCF.BusLayer.Audit.Log [(null)] - ECF Services
System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Data.SqlClient.SqlTransaction.Zombie()
   at System.Data.SqlClient.SqlInternalTransaction.ZombieParent()
   at System.Data.SqlClient.SqlInternalTransaction.Zombie()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction)
   at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction)
   at System.Data.SqlClient.SqlInternalTransaction.Rollback()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at Mediachase.eCF.DataLayer.TransactionScope.Rollback() in c:\Projects\ECF\Package\main\src\DataProvider\TransactionScope.cs:line 132
   at Mediachase.eCF.DataLayer.TransactionScope.System.IDisposable.Dispose() in c:\Projects\ECF\Package\main\src\DataProvider\TransactionScope.cs:line 151
   at Mediachase.eCF.DataLayer.Provider.SqlDataProvider.Save(DataCommand command)
   at Mediachase.eCF.DataLayer.Provider.DataService.Save(DataCommand command) in c:\Projects\ECF\Package\main\src\DataProvider\DataService.cs:line 111
   at Mediachase.eCF.DataLayer.DBBaseObject.Save()
   at Mediachase.eCF.BusLayer.Common.Services.ECFServiceHistory.AddNewItem(Int32 serviceId)
   at Mediachase.eCF.BusLayer.Common.Services.ECFServiceHistory.CreateNewMessage(Boolean init, Int32 serviceid, String source, String message)
   at Mediachase.eCF.Plugins.Services.Statistics.SpyIISLogService.Execute()
   at Mediachase.eCF.BusLayer.Common.Services.BaseECFService.ExecuteJob()

Hi Cole,

We will investigate this issue and get back to you soon.

Thanks.
Sincerely,
Irina

Irina,

I had the same issue last night, but it occurred at 1AM and we recycle at 3AM.  The same exception as above occurred. When I restart the service, I get the below error message in the log, but the WindowsService continues to run and seems to work fine after this point.
=====

2007-03-22 10:43:20,515 [2184] ERROR Mediachase.eCF.BusLayer.Audit.Log [(null)] - Failed SpyIISLog service.
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_Stat_RequestInfo_Stat_Visitors". The conflict occurred in database "GardenIQ_com", table "dbo.Stat_RequestInfo", column 'VisitorId'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Mediachase.Web.Statistics.DBHelper.RunSP(String strSP, Object[] paramList)
   at Mediachase.Web.Statistics.Data.FillRequestInfo()
   at Mediachase.Web.Statistics.Data.StatProcessing()
   at Mediachase.eCF.Plugins.Services.Statistics.SpyIISLogService.ProcessData()
   at Mediachase.eCF.Plugins.Services.Statistics.SpyIISLogService.Execute()

Hi Cole,

What version of the ECF are you running? What are you system specs (OS, database)? Is there way to get an access to your Commerce Manager as well as terminal services? If so, please email that info to support@mediachase.com.

We are working on this issue and will keep you posted. If there are any other info, please let us know.

Thank you for you patience.
Sincerely,
Irina

ECF 4.0.10
Windows Server 2003
SQL Server 2005

I'll email you a username/pass

Thank you, Cole. I am sorry for the inconvenience and thank you for your patience and communication.

Sincerely,
Irina

Hi Cole,

The problem may be a result of the transition to summer time.

Thanks Alexey.  I have changed the line and will let you know if I continue to receive errors or if this resolves the issue.

-Cole

Hi Guys,

I am still receiving the same error that was occurring initially (see below).  At the least I would like the service to handle the error, log it, and continue processing.  I am currently having to check the service every day to make sure it is still running.

Thanks,
-Cole

----------------
2007-03-26 00:51:34,359 [2740] ERROR Mediachase.eCF.BusLayer.Audit.Log [(null)] - ECF Services
System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Data.SqlClient.SqlTransaction.Zombie()
   at System.Data.SqlClient.SqlInternalTransaction.ZombieParent()
   at System.Data.SqlClient.SqlInternalTransaction.Zombie()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction)
   at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction)
   at System.Data.SqlClient.SqlInternalTransaction.Rollback()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at Mediachase.eCF.DataLayer.TransactionScope.Rollback() in c:\Projects\ECF\Package\main\src\DataProvider\TransactionScope.cs:line 132
   at Mediachase.eCF.DataLayer.TransactionScope.System.IDisposable.Dispose() in c:\Projects\ECF\Package\main\src\DataProvider\TransactionScope.cs:line 151
   at Mediachase.eCF.DataLayer.Provider.SqlDataProvider.Save(DataCommand command)
   at Mediachase.eCF.DataLayer.Provider.DataService.Save(DataCommand command) in c:\Projects\ECF\Package\main\src\DataProvider\DataService.cs:line 111
   at Mediachase.eCF.DataLayer.DBBaseObject.Save()
   at Mediachase.eCF.BusLayer.Common.Services.BaseECFService.ExecuteJob()

We are looking at the error and we will try to add a handler to the ExecuteJob method in our next maintanance release.

Thanks for the info.

Hi,

   Can you describe the steps that lead to the error?

Nadya.

Hi,

   One more question: which service causes the error? You can determine it this way: enable one service and disable all the others and see if it causes the error, and do the same for all the services.

Nadya.