SQL error on UD Mobile when I try to sync

[raymondjiii]

This always happens on wifi. Cell data I do not experience this. 
 

The firmware error is incorrect. I have 5.3.4 (which it says on UD Mobile screen.)

 

Edited May 7, 2022 by raymondjiii
Fix image

[raymondjiii]

Actually, I killed off the wifi network associated within UD Mobile and I think that resolved it. The ISY is running on a static local IP on the house network.

 

i have use ISY portal enabled. 
Local connection settings are correct and the “Only Use Local Connection” is not checked. 

[Javi]

Hi @raymondjiii,

The error is likely due to an invalid Local IP Address, maybe an extra space or character at the end of the address/Port.  

Can you please use the search icon next to the IP Address for automatic population.  The app will need the WiFi association. After that check the connection with the button at the bottom of Local network Connection Settings. Do you get an error? Does synchronization succeed?

 

[raymondjiii]

Definitely not an invalid IP address. It’s good in UD Mobile, username, password correct. Search icon finds it

I think the answer is that I had a wifi network (my only wifi network in the house) associated with it. So it seems like there was a double wifi network hop. My iPhone is on the house wifi but within the UD Mobile app I associated the house wifi with it. Something like:

iphone —> wifi network —> wifi network —> ISY

but this always worked:

iphone —> cell LTE —> ISY

so I think now it’s working as:

iphone —> wifi network —> ISY

(removed wifi network from within UD Mobile.)

 

TEST SYSTEM ON LOCAL NETWORK works but do I want to check that setting? 
If I check “Only Use Local Connection” then the “Remote Connection Setting” block turns red (and doesn’t work.)

My theory is, why associate a wifi network when the iPhone already is on the wifi network and the ISY is wired on the network?

Thanks. 

[Javi]

The error is that the App is not getting the /rest/config file, which is odd because it request /rest/time before /rest/config and /rest/time appears to have worked.  We have noticed that the /rest/time call will accept things like //rest/time and a few other variations.  All 3 errors are related. SQL cannot insert as there is no data, is the same reason the features array is empty, and the same reason the current firmware is shown as "NULL".  If you can determine the exact character(s) causing the issue we will add an additional check to the app.

Adding a network to the app only instructs the app to use the Local Connection settings when it is on that network.  This was added as the app can read a WiFi network instantaneously by requesting the current network from the Mobile OS. This check eliminates checking both URLs which could add many seconds at startup.  

Anyway, just as a test you can select only use local connection, then try synchronization. If it works then uncheck only use local connection and add your WiFi SSID, sync should work again.  If sync does not work in the first scenario there is a URL or port issue.

[raymondjiii]

Well, things seem to be working just fine. I followed all of your tests. I was able to sync now on local network. I added my wifi network back as an associated network. Thanks for your help.