SmartConnector Update Issue

[sesa237670_brid]

I am upgrading smartconnector on my machine from SmartConnector 2.2.1.27 to ‘SmartConnector-2.3.110.exe’. After running the installer, Smartconnector service is not starting on my machine. I am getting below error in the logs . I wonder what I am missing?

2018-02-05 12:49:47.9067,Error,Service,<no principal>,Error while building type Mongoose.Service.LoggerFilterProvider.  See the inner exception for details

1. 1.) new LoggerFilterProvider()
2. 2.) Mongoose.Service.LoggerFilterProvider
3. 3.) Instance of SxL.Common.ILoggerFilterProvider (Mongoose.Service.LoggerFilterProvider)
4. 4.) Container.GetInstance(SxL.Common.ILoggerFilterProvider)

An error occurred while executing the command definition. See the inner exception for details.

Invalid column name 'IsEnumerated'.

   at lambda_method(Closure , IBuildSession , IContext )

   at StructureMap.Building.BuildPlan.Build(IBuildSession session, IContext context)

   at StructureMap.BuildSession.BuildNewInSession(Type pluginType, Instance instance)

   at StructureMap.Pipeline.NulloTransientCache.Get(Type pluginType, Instance instance, IBuildSession session)

   at StructureMap.BuildSession.ResolveFromLifecycle(Type pluginType, Instance instance)

   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)

,[],

[JeffBowman]

Hi Neeraj,

This is for sure a strange issue, as I have not heard of anyone coming across this before.

Did you previously add columns to the SmartConnector database with/for an extension? It could be that with the database migrations from 2.2 to 2.3 something was overriden and the column was removed?

Also, could you attach the full log?

Regards,

-Jeff

[sesa237670_brid]

Hi Jeff,

I have not added any columns to the existing tables in smartconnector database. However, I have added tables for the extension. It does seems like a database error though. Attached is the full log. Do you know which specific table is 'LoggerFilterProvider' accessing ?  Can you send me the table scheme to compare ?

Thanks!
Neeraj Tomar

[JeffBowman · Accepted solution]

Hi Neeraj,

It seems as though when you updated from 2.2 to 2.3, the migrations were not performed on the database.

In the "LogCatgegoryFilter" table, can you try to add a 'bit' column called "IsEnumerated" with the default value set to 1?

Regards,

-Jeff

[sesa237670_brid]

Thanks Jeff! Fixing db table did it. Smartconnector service is running now and I can connect to the smartconnector portal on my machine