Problem with Android app on OR >= 1.13.0 - restart on asset view

Mobile apps, Consoles
1

Hello,

I’m in the process of upgrading an OpenRemote 1.3 instance to the latest possible version, and I’m currently facing a problem with the Android app. The app works fine up to OpenRemote 1.12.3. Every higher version (tested on 1.13.0–1.17.0 official Docker images) has a strange issue:

Starting with version 1.13.0, whenever I try to use the app it shows the domain and realm selection dialog (as if it were a fresh install). After that, the map loads correctly with all assets visible. However, when I select “Assets” from the menu, the app restarts and returns to the map view. It is not possible to view or edit asset attributes — clicking an asset on the map shows its attributes, but clicking the “View” button causes the app to reload and return to the map view.

I’ve tested this on Android 14 and 16 (Samsung devices, although I don’t think they are the source of the problem).

OpenRemote 1.13.0 is also the first version where I noticed logs like the following in the Manager console (logged when I switch between assets in web browser or trying to view asset on Android mobile):

2026-02-07 17:40:17.475  WARN    [WebService task-6             ] rnate.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 42601
2026-02-07 17:40:17.475  ERROR   [WebService task-6             ] rnate.engine.jdbc.spi.SqlExceptionHelper : ERROR: subquery in FROM must have an alias
  Hint: For example, FROM (SELECT ...) [AS] foo.
  Position: 53
2026-02-07 17:40:17.476  INFO    [WebService task-6             ] emote.container.web.WebServiceExceptions : Web service exception in 'RESTEasy Dispatch' for 'POST http://xxxx.yyyyyyyy.zz/api/asset/cou>
  Hint: For example, FROM (SELECT ...) [AS] foo.
  Position: 53

On the other hand, this version is also the first one where my OpenRemote Manager instance starts in about 30 seconds. In all previous versions, it took around 10 minutes for the container to start, with extremely slow compilation and initialization of rulesets (I have about 100 assets with 4 rules per asset).

Regards,

Krzysztof

2

Hi!

We’ve created an issue for this error last week.

.
If you use the Web UI through your preferred browser, everything works fine.
However, the mobile apps, as you’ve experienced, get redirected to the “home page”.
This is because the API returns a server error 500.

I’ll try to find the time to investigate it, but I’m not sure when, as I’m very busy :sweat_smile:
Any additional info you can provide would be great!
And, of course, feel free to open a PR if you’re able to :+1:

3

We’ve improved this indeed :wink:

Introduced in version 1.13.0:

4

I’ve commented this bug on OpenRemote Github with potential resolution :wink:

Regarding speeding Manager rules compilation during starting - great news!

5

The bugfix has just been released as part of 1.17.2 ! :partying_face: