M.App Enterprise Discussions

[gmaldera]

Dear all,

In our M.App Enterprise system we have two servers: the first for the application pools and M.App Service, the second for the Tile Service and the Database where we store features data. 

At the moment, the servers are ON only 12 hours per day. Sometimes happens the both services M.App Service and Tile Service do not start automatically when the server restart.

In our configuration the second server (with Tile Service and Database for features) is started two minutes before than the other with the applications pools and M.App Service.

Can you please support me?

Thank you very much

Regards

[jan.neumann · Accepted solution]

Hi Giuseppe,

It usually helps to set the services to Automatic (Delayed start) instead of Automatic. You should see in the Event Log why M.App service failed to start - it might be that the master database was not initialized during the start attempt.

You might also further adjust the services Start up options to be dependend on another services.

Regards,

Jan

[gmaldera]

Thank you Jan.

So the starting order should be this:

• master database inizialitation (this db is on the first server);
• features database inizaliation (this db is on the second);
• m.App Service (first server);
• Tile Service (second server);

Is it Right?

thank you

[gmaldera]

I have always the same error:

Service cannot be started. Npgsql.PostgresException (0x80004005): 57P03: il database si sta avviando
at Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode dataRowLoadingMode, Boolean isPrependedMessage)
at Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode dataRowLoadingMode)
at Npgsql.NpgsqlConnector.HandleAuthentication(String username, NpgsqlTimeout timeout)
at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout)
at Npgsql.ConnectorPool.Allocate(NpgsqlConnection conn, NpgsqlTimeout timeout)
at Npgsql.NpgsqlConnection.OpenInternal()
at MApp.Data.Database.Select[T](String sqlCommand, IEnumerable`1 parameters)
at MApp.Core.MAppConfigReader.Read()
at MApp.Service.MAppService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

I will try to o set the services to Automatic (Delayed start).

[jan.neumann]

Hi Giuseppe,

Correct, the master DB must be started fist. Since the DB service startup tend to vary or prolong during the machine age. You can adjust the service to make another start attempt after certain time interval.

A bullet-proof solution would be to change the services definition and create again with dependency defined. Something like this:

sc delete "M.App Service"
sc delete "M.App Tile Service"

sc create "M.App Service" binpath="C:\Program Files\Hexagon\M.App Enterprise\Service\MApp.Service.exe" type=own start=auto depend="postgresql-x64-10" obj="<MappUser>" password="<password>"
sc create "M.App Tile Service" binpath="C:\Program Files\Hexagon\M.App Enterprise Tile Service\MApp.TileService.exe" type=own start=auto depend="postgresql-x64-10" obj="<MappUser>" password="<password>"

On your own risk

Regards,

Jan

[gmaldera]

I set the services as Automatic (Delayed) and the problems seems solved. Thank you very much

Giuseppe M.