SmartConnector Portal is not available.

[Lihov]

After installation SmartConnector Portal localhost:8082 is not available. The following entries in log file:

2017-03-02 15:28:48.4279,Status,Service,<no principal>,SmartConnector is starting,

2017-03-02 15:28:48.4569,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,

2017-03-02 15:28:48.5570,Status,Service,<no principal>,Spinning up WorkerManager,

2017-03-02 15:28:48.5570,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,

2017-03-02 15:28:48.6470,Status,Service,<no principal>,Attaching context listeners,

2017-03-02 15:28:48.8328,Status,Service,<no principal>,PortalAddress disabled because there is no defined endpoint.,

What can I do with this issue?

[sesa180908_brid]

Ilya,

Was this a new installation or did you upgrade from a prior version?  If it was an upgrade, do you happen to know what version you were upgrading from?

Can you open up a SQL client against your SmartConnector database and run the following query.

SELECT * FROM Settings;

[Lihov]

Hello Mark,

It is not ubgrade. This is new installation of 2.2.108 version. The result for this query is emty table without any entries.

[sesa180908_brid · Accepted solution]

That is very strange but the lack of rows does explain why the portal isn't working.

Since it was a fresh install, you could just opt to uninstall and reinstall using the setup EXE.

Alternatively, you could do the following which will re-install a new database at the configured location.

1. Stop the service if its running
2. Open a command window as an Administrator.
3. Change to the SmartConnector install folder.
4. Run mongoose.utility.exe /CreateDatabase
5. Start the service and try to access the portal

Both approaches will delete the existing database but it doesn't sound like that is an issue in this case. 

If this doesn't remedy the situation, it is most likely a permission issue with the user you have configured for the database connection.  If you still have issues after trying the above, please supply:

• Database server type (Express or SQLServer) and version.
• Is the database server remote or is it the same machine SmartConnector is installed on?
• Are you using Windows authentication or SQLServer authentication.
• Does the DB user you are using have dbcreator roles?

[Lihov]

Hello, Mark

After re-installation database web portal became available (all permissions of user was correctly). Thank you so much!

[sesa395052_brid]

Hello Mark,

After installation of SmartConnector, localhost:8082 is not available.

2017-07-07 14:11:55.7055,Status,Service,<no principal>,SmartConnector is starting,

2017-07-07 14:11:55.7055,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,

2017-07-07 14:11:55.9015,Status,Service,<no principal>,Spinning up WorkerManager,

2017-07-07 14:11:55.9015,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,

2017-07-07 14:11:55.9575,Status,WorkerManager,<no principal>,Worker manager has started.,

2017-07-07 14:11:55.9795,Status,Service,<no principal>,Attaching context listeners,

2017-07-07 14:11:56.7945,Status,Service,<no principal>,Starting PortalAddress,

2017-07-07 14:11:57.2365,Error,Service,<no principal>,Exception has been thrown by the target of an invocation.

The process cannot access the file because it is being used by another process

  at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

  at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

  at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)

  at Microsoft.Owin.Hosting.Engine.HostingEngine.StartServer(StartContext context)

  at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)

  at Microsoft.Owin.Hosting.Starter.DirectHostingStarter.Start(StartOptions options)

  at Microsoft.Owin.Hosting.Starter.HostingStarter.Start(StartOptions options)

  at Microsoft.Owin.Hosting.WebApp.StartImplementation(IServiceProvider services, StartOptions options)

  at Microsoft.Owin.Hosting.WebApp.Start(StartOptions options)

  at Microsoft.Owin.Hosting.WebApp.Start[TStartup](StartOptions options)

  at Mongoose.Service.Mongoose.StartPortal()

,[],

[JeffBowman]

Hi Soe,

It may be that port 8082 is in use by some other process on your computer. Can you try going into the database (through SQL management studio). Opening the Settings table, and changing the PortalAddress to a different port number. Then restart the SmartConnector service.

-Jeff

[sesa395052_brid]

Hi Jeff,

After I changed PortalAddress to a different port number, it worked . Thank you very much.