Cannot start the service

Question

Hi All,

I have installed the API version 1.6 and after adding the relay services, i go and start the service it gives me an error:

Error 13816: Unknown error occurred

I uninstalled the EB Services and installed it again but still the same.

When i look at the error logs in MYOB.ED.EXO.Cloud.Provider.ServiceHost.ERROR the log shows:

2021-07-14 12:03:56.4272:EXOAPIProviderService:1:ERROR:UnhandledExcpetion
EXCEPTION: System.Exception: SytemId mismatch. This windows installation is not configured to connect to that database.
at MYOB.ED.EXO.Cloud.API.WebAPI.Bootstrap.Init()
at MYOB.ED.EXO.Cloud.API.WebAPI.HTTPConfiguration.Configure(HttpConfiguration configuration, IContainer container)
at MYOB.ED.EXO.Cloud.Provider.ServiceHost.EXOAPIProviderService.<Start>b__11_0(HttpConfiguration config)
at MYOB.CloudRelay.Provider.Provider..ctor(Action`1 configurationCallback, Int32 maxParrallelRequests, Int32 maxCPULoadPercentage)
at MYOB.ED.EXO.Cloud.Provider.ServiceHost.EXOAPIProviderService.Start()
at MYOB.ED.EXO.Cloud.Provider.ServiceHost.Service.DoStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.ServiceProcess.ServiceBase.Run(ServiceBase[] services)
at MYOB.ED.EXO.Cloud.Provider.ServiceHost.Service.Main(String[] args)

Also in the MYOB.ED.EXO.Cloud.API.ServiceHost.ERROR the log says:

2021-07-14 12:04:08.6806:EXOAPIService:1:ERROR:UnhandledExcpetion
EXCEPTION: System.Exception: SytemId mismatch. This windows installation is not configured to connect to that database.
at MYOB.ED.EXO.Cloud.API.WebAPI.Bootstrap.Init()
at MYOB.ED.EXO.Cloud.API.WebAPI.HTTPConfiguration.Configure(HttpConfiguration configuration, IContainer container)
at MYOB.ED.EXO.Cloud.API.ServiceHost.EXOAPIService.Start()
at MYOB.ED.EXO.Cloud.API.ServiceHost.Service.DoStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.ServiceProcess.ServiceBase.Run(ServiceBase[] services)
at MYOB.ED.EXO.Cloud.API.ServiceHost.Service.Main(String[] args)

Thank you for your help in advance.

Regards,

Will_H · Answer

I always do it in SSMS:

UPDATE GENERAL_INFO

SET DB_ID= NULL

Or:

UPDATE GENERAL_INFO

SET DB_ID= 'Test'

Anish · Answer

Thank you Will.

How do we change/reset the DB_ID?

Will_H · Answer

Hi Anish,

Try the following:

UPDATE GENERAL_INFO

SET SYSTEM_ID= NULL

This is  likely a message that the SystemID configured incorrectly, SYSTEMID is a stored GUID value relating to the exact server/windows computer you're running the business services from.

Please also remember to either reset to change the DB_ID in General Info for any other databases restored on the server, it's a bad time when the system_ID and DB_ID are cloned between the Live database and any test databases, as it can lead to problems selecting the correct database.