Problem starting Exo API

Question

Hi

Trying to setup Existing API on new sytem getting the below error can anyone you help

2022-03-27 11:00:01.0707:EXOAPIService:4:TRACE:Service created
2022-03-27 11:00:01.1957:EXOAPIService:4:TRACE:Starting service.
2022-03-27 11:00:01.2269:EXOAPIService:4:TRACE:HTTP Server created at http://localhost:8888/
2022-03-27 11:00:01.2269:EXOAPIService:4:TRACE:Connection name configured for service: HutchiesLive
2022-03-27 11:00:01.4713:EXOAPIService:4:TRACE:Container built with connection name HutchiesLive.
2022-03-27 11:00:01.4713:EXOAPIService:4:TRACE:Configuring HTTP Listener
2022-03-27 11:00:02.7788:Bootstrap:4:TRACE:BOOTSTRAP Init started
2022-03-27 11:00:02.7788:Bootstrap:4:TRACE:Getting GENERAL_INFO
2022-03-27 11:00:02.8413:Bootstrap:4:ERROR:Cannot read general info from database. Database not updated to use API or has invalid values.
2022-03-27 11:00:02.8413:EXOAPIService:4:ERROR:Exception starting service.
EXCEPTION: System.Exception: Cannot read general info from database. Database not updated to use API.
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()
2022-03-27 11:00:02.8695:EXOAPIService:1:ERROR:UnhandledExcpetion
EXCEPTION: System.Exception: Cannot read general info from database. Database not updated to use API.
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)

Extra infomation

upgradeing to 1.6

Login is RDP to server with admin type access

Needed to setup coonection string  running exo as admin to get connnection visable

systemid  and DBid strings have been set to null in generalinfo table and have not been reset by opening API

Any help ideas appreciate

Thanks

Robert_North · Answer

Hi John

The Exo conection required "Run as Admin" setup, in order to make it show in API

Tested this login in Exo Business and it works in both admin and standard

recreated both services with MYOB Exo Business Services  "Run as Admin"

Issuse persits

Thanks

Robert

John_Semmens · Answer

Hi Robert,

This may be simplistic, but the first error message is that it can't see the General Info table.

That would suggest that connection is pointing to the wrong database or the connection has an error in it.

The test to verify this would be to right-click on the Exonet.exe whilst on the server with the API, and "Run as Admin" (which is the same context that the API will run in).

Then verify that you can choose the same Exo connection used by the API service, and log in to Exo.

You may as well login using the expected API credentials also. This will verify those as well (although the API hasn't got that far yet).

If you can't do that, then the API can't do it either.