Select Services Offline

Discussions related to SoftPro Select Server development.

Moderator: Phil Barton

Post Reply
roteague
Posts: 292
Joined: Thu Sep 25, 2008 4:49 pm
Location: Honolulu, Hawaii

Select Services Offline

Post by roteague »

I've noticed that occasionally the SoftPro environments will be Offline for no apparent reason. If I forget to check their status it causes my users problems when they are presented with a login dialog box (which isn't displayed when the Services are Online).

Is there some process that shuts these Services down in certain circumstances?
Robert
Top
roteague
Posts: 292
Joined: Thu Sep 25, 2008 4:49 pm
Location: Honolulu, Hawaii

Re: Select Services Offline

Post by roteague »

Anyone had a chance to look at this yet? My services were online this morning, and now they are offline. There hasn't been anyone on the system all morning.
Robert
Top
Hadi Chemaly

Re: Select Services Offline

Post by Hadi Chemaly »

Robert, can you dig out event logs related to the SoftPro services shutting down, and post them here?

Thanks.
Top
roteague
Posts: 292
Joined: Thu Sep 25, 2008 4:49 pm
Location: Honolulu, Hawaii

Re: Select Services Offline

Post by roteague »

It took me awhile to track this down, it looks like this is the first item in the list:

Code: Select all

Event Type:	Error
Event Source:	.NET Runtime 2.0 Error Reporting
Event Category:	None
Event ID:	5000
Date:		10/18/2010
Time:		9:57:47 PM
User:		N/A
Computer:	SOFTPRO
Description:
EventType clr20r3, P1 spssvc.exe, P2 2.6.0.0, P3 4c7d57de, P4 system.data, P5 2.0.0.0, P6 4889ece0, P7 247f, P8 2c, P9 system.data.sqlclient.sql, P10 NIL.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 63 00 6c 00 72 00 32 00   c.l.r.2.
0008: 30 00 72 00 33 00 2c 00   0.r.3.,.
0010: 20 00 73 00 70 00 73 00    .s.p.s.
0018: 73 00 76 00 63 00 2e 00   s.v.c...
0020: 65 00 78 00 65 00 2c 00   e.x.e.,.
0028: 20 00 32 00 2e 00 36 00    .2...6.
0030: 2e 00 30 00 2e 00 30 00   ..0...0.
0038: 2c 00 20 00 34 00 63 00   ,. .4.c.
0040: 37 00 64 00 35 00 37 00   7.d.5.7.
0048: 64 00 65 00 2c 00 20 00   d.e.,. .
0050: 73 00 79 00 73 00 74 00   s.y.s.t.
0058: 65 00 6d 00 2e 00 64 00   e.m...d.
0060: 61 00 74 00 61 00 2c 00   a.t.a.,.
0068: 20 00 32 00 2e 00 30 00    .2...0.
0070: 2e 00 30 00 2e 00 30 00   ..0...0.
0078: 2c 00 20 00 34 00 38 00   ,. .4.8.
0080: 38 00 39 00 65 00 63 00   8.9.e.c.
0088: 65 00 30 00 2c 00 20 00   e.0.,. .
0090: 32 00 34 00 37 00 66 00   2.4.7.f.
0098: 2c 00 20 00 32 00 63 00   ,. .2.c.
00a0: 2c 00 20 00 73 00 79 00   ,. .s.y.
00a8: 73 00 74 00 65 00 6d 00   s.t.e.m.
00b0: 2e 00 64 00 61 00 74 00   ..d.a.t.
00b8: 61 00 2e 00 73 00 71 00   a...s.q.
00c0: 6c 00 63 00 6c 00 69 00   l.c.l.i.
00c8: 65 00 6e 00 74 00 2e 00   e.n.t...
00d0: 73 00 71 00 6c 00 20 00   s.q.l. .
00d8: 4e 00 49 00 4c 00 0d 00   N.I.L...
00e0: 0a 00                     ..
The service is essentially crashing, with a .NET runtime error. It looks to be crashing in system.data.sqlclient.sql.

Other error:

Code: Select all

Event Type:	Error
Event Source:	SoftPro Select Server (SOFTPRO_TEST)
Event Category:	None
Event ID:	0
Date:		10/18/2010
Time:		9:57:53 PM
User:		N/A
Computer:	SOFTPRO
Description:
Error occured on service boundary.
Error: could not update: [SoftPro.Select.Server.Integration.Session#c7e9c65b-55db-df11-9fab-0050569a729b][SQL: UPDATE dbo.SessionView SET Version = ?, Username = ?, MachineName = ?, State = ?, AcquiredOn = ?, ExpiresOn = ?, ClientID = ?, Recoverable = ?, TrusteeID = ? WHERE ID = ? AND Version = ?]
Stack Trace: 
   at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
   at NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session)
   at NHibernate.Action.EntityUpdateAction.Execute()
   at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
   at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
   at NHibernate.Engine.ActionQueue.ExecuteActions()
   at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)
   at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
   at NHibernate.Impl.SessionImpl.Flush()
   at SoftPro.PersistenceModel.DataContext.SaveChanges()
   at SoftPro.Select.Server.Managers.SessionManager.RenewSession()
   at SoftPro.Select.Server.Integration.SessionManagerService.SoftPro.Select.Server.Integration.ISessionManager.RenewSession()
   at SyncInvokeRenewSession(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
XML Log: 
Error in creating ILExceptionData: System.NullReferenceException: Object reference not set to an instance of an object.
   at SoftPro.ServerModel.Utils.CreateXmlLog(Exception ex)
***********************************************************************************
Error: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Stack Trace: 
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   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 NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
XML Log: 
<ILExceptionData>
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.SqlInternalConnection" methodName="OnError" methodSignature="Void OnError(System.Data.SqlClient.SqlException, Boolean)" methodToken="0x6002742" ILOffset="41" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParser" methodName="ThrowExceptionAndWarning" methodSignature="Void ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject)" methodToken="0x6002997" ILOffset="148" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParserStateObject" methodName="ReadSniError" methodSignature="Void ReadSniError(System.Data.SqlClient.TdsParserStateObject, UInt32)" methodToken="0x6002a8d" ILOffset="298" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParserStateObject" methodName="ReadSni" methodSignature="Void ReadSni(System.Data.Common.DbAsyncResult, System.Data.SqlClient.TdsParserStateObject)" methodToken="0x6002a8c" ILOffset="98" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParserStateObject" methodName="ReadNetworkPacket" methodSignature="Void ReadNetworkPacket()" methodToken="0x6002a8a" ILOffset="61" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParserStateObject" methodName="ReadBuffer" methodSignature="Void ReadBuffer()" methodToken="0x6002a77" ILOffset="30" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParserStateObject" methodName="ReadByte" methodSignature="Byte ReadByte()" methodToken="0x6002a7c" ILOffset="20" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.TdsParser" methodName="Run" methodSignature="Boolean Run(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject)" methodToken="0x60029a9" ILOffset="58" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.SqlCommand" methodName="FinishExecuteReader" methodSignature="Void FinishExecuteReader(System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.RunBehavior, System.String)" methodToken="0x60023e0" ILOffset="199" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.SqlCommand" methodName="RunExecuteReaderTds" methodSignature="System.Data.SqlClient.SqlDataReader RunExecuteReaderTds(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, Boolean)" methodToken="0x60023dd" ILOffset="682" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.SqlCommand" methodName="RunExecuteReader" methodSignature="System.Data.SqlClient.SqlDataReader RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String, System.Data.Common.DbAsyncResult)" methodToken="0x60023dc" ILOffset="183" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.SqlCommand" methodName="InternalExecuteNonQuery" methodSignature="Int32 InternalExecuteNonQuery(System.Data.Common.DbAsyncResult, System.String, Boolean)" methodToken="0x60023c1" ILOffset="208" />
  <Point module="System.Data.dll" classFull="System.Data.SqlClient.SqlCommand" methodName="ExecuteNonQuery" methodSignature="Int32 ExecuteNonQuery()" methodToken="0x60023ba" ILOffset="64" />
  <Point module="NHibernate.dll" classFull="NHibernate.AdoNet.AbstractBatcher" methodName="ExecuteNonQuery" methodSignature="Int32 ExecuteNonQuery(System.Data.IDbCommand)" methodToken="0x60000bd" ILOffset="136" />
  <Point module="NHibernate.dll" classFull="NHibernate.Persister.Entity.AbstractEntityPersister" methodName="Update" methodSignature="Boolean Update(System.Object, System.Object[], System.Object[], System.Object, Boolean[], Int32, System.Object, System.Object, NHibernate.SqlCommand.SqlCommandInfo, NHibernate.Engine.ISessionImplementor)" methodToken="0x6002d6e" ILOffset="693" />
</ILExceptionData>

Unable to retrieve message headers. Message is closed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I'll look around a bit more and see what I can find on this end. If you have any ideas where I can look, let me know.

Thanks,
Robert
Top
roteague
Posts: 292
Joined: Thu Sep 25, 2008 4:49 pm
Location: Honolulu, Hawaii

Re: Select Services Offline

Post by roteague »

I've got 4 installations, and this issue is the same on all 4 installations. Additionally, of the installations has 3 services. All exhibit the same problem.

I'm in the process of installing SP2. Is there anything in this service pack that may affect this?
Robert
Top
jbright

Re: Select Services Offline

Post by jbright »

We have seen circumstances where the Select Server requires a restart if SQLServer becomes inaccessible. This may be the cause.
Top
Post Reply

Return to “Server”