SmartConnector service exceptin - "Error while building type Mongoose.Service.LoggerFilterProvider."

[mike_meirovitz]

Hi,

We are using SmartConnector version 2.4.17. After computer restart, SmartConnector works for ~1 minute and then crashes. See the log below. We are using SQL Server express. Not SqlAzure.

2020-11-14 12:06:51.0356,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.
The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (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
at lambda_method(Closure , IBuildSession , IContext )
at StructureMap.Building.BuildPlan.Build(IBuildSession session, IContext context)
at StructureMap.SessionCache.GetObject(Type pluginType, Instance instance, ILifecycle lifecycle)
at StructureMap.SessionCache.GetDefault(Type pluginType, IPipelineGraph pipelineGraph)
at StructureMap.Container.GetInstance(Type pluginType)
at StructureMap.Container.GetInstance[T]()
at Mongoose.Service.Mongoose.OnStart(String[] args)
,[],

Any idea why?

Thanks.

Mike

[JeffBowman · Accepted solution]

Hi Michael,

Is SQL on the same machine?

This error looks like SQL does not start up fast enough before Smart Connector does. You may want to configure the Smart Connector service to start after a delay, as well as setting the Smart Connector service to restart on failure.

Best Regards,

-Jeff

[mike_meirovitz]

Hi Jeff,

Yes. It is on the same machine. I have added the SQL server service as a dependency service for the SmartConnector service. I hope that this will resolve the issue.

Thank you.

Mike