SmartConnector 2.4.7 fails to start after system restart

mike_meirovitz · ‎2018-08-17

SmartConnector 2.4.7 fails to start after system restart. The service is not started.

See the log below:

2018-08-17 14:09:37.9001,Error,Service,<no principal>,A system shutdown is in progress. (Exception from HRESULT: 0x8007045B)

...

2018-08-17 16:41:17.8454,Error,Service,<no principal>,Error while building type Mongoose.Service.LoggerFilterProvider. See the inner exception for details

1.) new LoggerFilterProvider()

2.) Mongoose.Service.LoggerFilterProvider

3.) Instance of SxL.Common.ILoggerFilterProvider (Mongoose.Service.LoggerFilterProvider)

4.) Container.GetInstance(SxL.Common.ILoggerFilterProvider)

An exception occurred while initializing the database. See the InnerException for details.

An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy.

The underlying provider failed on Open.

An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

No process is on the other end of the pipe

I had to start the service manually.

Thanks

Mike

Adam_Summers · ‎2018-08-17

Hi Michael, did you follow the steps in the install guide to add service dependencies? You can modify the service behaviour to be linked to SQL and set recovery states to have the service attempt an auto restart. It’s worth having SmartConnector set to delayed start too if it’s not already.

See Answer In Context

JeffBowman · ‎2018-08-17

Hi Michael,

Is this behavior reproducible?

It looks as though the Smart Connector service tried to start up before SQL finished starting.

Regards,

-Jeff

mike_meirovitz · ‎2018-08-17

Hi Jeff,

Not yet. Following another shut down and restart it didn't happen.

I will let you know If it happens again.

Thank you.

Michael

Adam_Summers · ‎2018-08-17

Hi Michael, did you follow the steps in the install guide to add service dependencies? You can modify the service behaviour to be linked to SQL and set recovery states to have the service attempt an auto restart. It’s worth having SmartConnector set to delayed start too if it’s not already.

mike_meirovitz · ‎2018-08-19

Hi Adam,

Not yet. I will do it.

Thank you.

Michael