Page 1 of 1

Can't start self hosted service

PostPosted: Mon Oct 08, 2018 3:32 pm
by DannyC
Hi,

I'm getting this error trying to start the Jiwa 7 API self hosted service.
Version 7.2.
The config file has been modified correctly with valid SQL server name, database name, username & password.
REST API plugin is enabled.
2018-10-08 15_29_26-Untitled - Paint.png

Re: Can't start self hosted service  Topic is solved

PostPosted: Wed Oct 10, 2018 3:26 pm
by SBarnes
I believe the issue is related to trying to run the Web API on SQL 2008 as the SQL syntax in the error is only available on SQL 2012 or above but Mike or Scott will need to confirm this.

Re: Can't start self hosted service

PostPosted: Wed Oct 10, 2018 3:54 pm
by Scott.Pearce
I reckon Stuart has nailed it.

Offset . . .Fetch Next syntax is SQL 2012 and later. Check your SQL server version and upgrade it as necessary.