Sync Problem on Android.

[atexinspect]

Hi Adrian,
I have a problem with syncing that only happens on Android (Tested on Android 12 and Android 14 mobile phones) The Windows version of my application always syncs without a problem. My application has several tables that all sync ok on both platforms but on Android 2 tables give a 'Not Found' error although about 70% of the records on each table are synchronized. The 2 tables that generate the 'Not Found' error both happen to be the most populated with around 5000 records each. Don't know if this makes a difference. The other tables have much fewer records and sync ok on both platforms. The errors are when 'Pulling' from my Web App /Azure SQL Server database.

Any idea's?
Thanks
Paul.

[adrianhall]

Turn on logging and take a look at the requests going out and what data is coming back.

At the end of the day, we are processing a series of HTTP requests to the remote service. Something is happening there. Given its not a complete failure, I suspect something is wrong with the data coming back.

[atexinspect]

Ok thanks will do. Paul.

[atexinspect]

Hi Adrian,
I have tried logging and occasionally are getting - StatusCode: 414, ReasonPhrase: 'URI Too Long' when pulling from my local SQL database. I have tried changing the PageSize and MaxTop in my Web App but it doesn't seem to make any difference.

Any help appreciated.
Thanks
Paul.

Request: Method: GET, RequestUri: 'https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?$orderby=updatedAt&$count=true&__includedeleted=true&$skip=219', Version: 1.1, Content: , Headers:
{
User-Agent: Datasync/8.0.5.0 (lang=Managed;os=Microsoft Windows 10.0.26100/Microsoft Windows NT 10.0.26100.0;arch=X64;version=8.0.5.0)
ZUMO-API-VERSION: 3.0.0
XMid: xxxxxxxxxxxxx
Accept-Encoding: gzip
Accept-Encoding: deflate
Accept-Encoding: br
}

Response: StatusCode: 414, ReasonPhrase: 'URI Too Long', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers:
{
Connection: close
Date: Mon, 27 Jan 2025 15:26:47 GMT
Server: Kestrel
Content-Length: 0
}, Trailing Headers:

[adrianhall]

This feels like a missing ‘/‘ on the end of the URI. I try to accommodate that, but apparently not working in your case. Take a look at the URI you are passing in; does it have a trailing ‘/‘ - if not, add one.

…

Sent from my iPad On Jan 27, 2025, at 7:58 AM, atexinspect ***@***.***> wrote:  Hi Adrian, I have tried logging and occasionally are getting - StatusCode: 414, ReasonPhrase: 'URI Too Long' when pulling from my local SQL database. I have tried changing the PageSize and MaxTop in my Web App but it doesn't seem to make any difference. Any help appreciated. Thanks Paul. Request: Method: GET, RequestUri: 'https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?$orderby=updatedAt&$count=true&__includedeleted=true&$skip=219<https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/tables/asset?https://localhost:56557/ta>', Version: 1.1, Content: , Headers: { User-Agent: Datasync/8.0.5.0 (lang=Managed;os=Microsoft Windows 10.0.26100/Microsoft Windows NT 10.0.26100.0;arch=X64;version=8.0.5.0) ZUMO-API-VERSION: 3.0.0 XMid: xxxxxxxxxxxxx Accept-Encoding: gzip Accept-Encoding: deflate Accept-Encoding: br } Response: StatusCode: 414, ReasonPhrase: 'URI Too Long', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers: { Connection: close Date: Mon, 27 Jan 2025 15:26:47 GMT Server: Kestrel Content-Length: 0 }, Trailing Headers: — Reply to this email directly, view it on GitHub<#198 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AALLUOPL65KMRXKJV6MHYHT2MZJRDAVCNFSM6AAAAABVFSQKUWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCOJXGE4DMNI>. You are receiving this because you commented.Message ID: ***@***.***>

[atexinspect]

Hi Adrian,
Thanks for the reply. I have already added the '/' to my URL. I previously read on the internet that this could be the issue.

Thanks
Paul.

[adrianhall]

I believe I have found the source of your error.

The problem is in the way the nextLink is generated, and how that is processed by the client. There isn't a quick fix (right now), but I'm working on it within the 9.x work.

[atexinspect]

Thanks Adrian, very much appreciated. Paul.

[adrianhall]

... and I've got a PR with the adjustments for .NET 9 out. Feel free to try out the code in the PR.

[adrianhall]

... and FWIW, it's because you are using a dev tunnel. The old code included the perceived URI (using GetDisplayUri()), whereas the new one just returns the query string (and the client appends the query string to the existing URI). The Android device thinks localhost is the local device - not your server running on your local machine.

You can also replace localhost with the IP address of your PC on the Android emulator networking side of things - should work just fine.

[atexinspect]

Hi Adrian,
Unfortunately I get similar results when live testing. My assets table has a byte[] column which contains about 20K of data per row which I thought could be a problem but the Schedules table rows don't have any columns with large amounts of data and the problem still persists.

Thanks
Paul.

Request: Method: GET, RequestUri: 'https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/asset?$orderby=updatedAt&$count=true&__includedeleted=true&$skip=2800', Version: 1.1, Content: , Headers:
{
User-Agent: Datasync/8.0.5.0 (lang=Managed;os=Microsoft Windows 10.0.26100/Microsoft Windows NT 10.0.26100.0;arch=X64;version=8.0.5.0)
ZUMO-API-VERSION: 3.0.0
XMid: xxxxxxxxxx
Accept-Encoding: gzip
Accept-Encoding: deflate
Accept-Encoding: br
}

Response: StatusCode: 404, ReasonPhrase: 'Not Found', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers:
{
Date: Thu, 30 Jan 2025 07:06:39 GMT
Server: Microsoft-IIS/10.0
X-Powered-By: ASP.NET
Content-Length: 103
Content-Type: text/html
}

Request: Method: GET, RequestUri: 'https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?https://oxlfizxk24ktq-service-exinspector.azurewebsites.net/tables/schedules?$orderby=updatedAt&$count=true&__includedeleted=true&$skip=2600', Version: 1.1, Content: , Headers:
{
User-Agent: Datasync/8.0.5.0 (lang=Managed;os=Microsoft Windows 10.0.26100/Microsoft Windows NT 10.0.26100.0;arch=X64;version=8.0.5.0)
ZUMO-API-VERSION: 3.0.0
XMid: xxxxxxxxxxx
Accept-Encoding: gzip
Accept-Encoding: deflate
Accept-Encoding: br
}

Response: StatusCode: 404, ReasonPhrase: 'Not Found', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers:
{
Date: Thu, 30 Jan 2025 07:06:54 GMT
Server: Microsoft-IIS/10.0
X-Powered-By: ASP.NET
Content-Length: 103
Content-Type: text/html
}

[adrianhall]

Well, I can see what is happening, but I don’t know why since I explicitly handle the appropriate situation.

I need to see the response from the server for the FIRST request. That will tell me if my hypothesis (next link in the response data is a full URL) is correct.

[atexinspect]

SyncLog3112025.log

Hi Adrian,
Please find attached sync log file. The conflicts for the 'membershipxxx' tables are expected as I need to add default data in case of no network connection. All tables except 'Assets' and 'Schedules' sync fine (2731 of 4089 assets synced / 2548 of 5752 schedules synced).

Thanks
Paul.

[adrianhall]

Explicitly, I need the JSON response to this call:

Request: Method: GET, RequestUri: 'https://XXX.azurewebsites.net/tables/asset?$orderby=updatedAt&$count=true&__includedeleted=true', Version: 1.1, Content: <null>, Headers:
{
  User-Agent: Datasync/8.0.6.0
  User-Agent: (lang=Managed;os=Linux 4.14.190-perf+ #1 SMP PREEMPT Fri Jun 9 15:03:49 CST 2023/Unix 31.0.0.0;arch=Arm64;version=8.0.6.0)
  ZUMO-API-VERSION: 3.0.0
  XMid: pgH7QzFHJx4w46fI5Uzi4RvtTwlEXp
}

Response: StatusCode: 200, ReasonPhrase: 'OK', Version: 1.1, Content: System.Net.Http.StreamContent, Headers:
{
  Date: Fri, 31 Jan 2025 01:47:42 GMT
  Server: Microsoft-IIS/10.0
  Set-Cookie: ARRAffinity=ad26f9a6bd8a60cc0a709ea5aba83deeee69ecdeb9e8ed99f43a1cd50f09889a;Path=/;HttpOnly;Secure;Domain=oxlfizxk24ktq-service-exinspector.azurewebsites.net
  Set-Cookie: ARRAffinitySameSite=ad26f9a6bd8a60cc0a709ea5aba83deeee69ecdeb9e8ed99f43a1cd50f09889a;Path=/;HttpOnly;SameSite=None;Secure;Domain=XXX.azurewebsites.net
  Transfer-Encoding: chunked
  Vary: Accept-Encoding
  X-Android-Received-Millis: 1738288062590
  X-Android-Response-Source: NETWORK 200
  X-Android-Selected-Protocol: http/1.1
  X-Android-Sent-Millis: 1738288033955
  X-Powered-By: ASP.NET
  Content-Type: application/json; charset=utf-8
}

[atexinspect]

Hi Adrian,
Hope this is what you are looking for?

https://1drv.ms/u/c/f325ad256d9be536/EZlOCr3jVEhGpXYpHstlkUQBJbRiN149Sp1Wg9dbbzX0hw?e=xdXcrc

Regards
Paul.

[adrianhall]

Looks like it. I’ll needs to get to a real computer to analyze further.

[atexinspect]

Thanks again. Good luck :)

[atexinspect]

SyncLog122025.log

Attached is an easier to read version where the photo data has been replaced with 4KB placeholders.

[adrianhall]

So - this is the relevant problem: https://github.com/CommunityToolkit/Datasync/blob/main/src/CommunityToolkit.Datasync.Client/Offline/Operations/PullOperationManager.cs#L105C1-L109C1

                    if (!string.IsNullOrEmpty(page.NextLink))
                    {
                        requestUri = new UriBuilder(endpoint) { Query = page.NextLink }.Uri;
                    }

Basically, the pull operation is expecting the page.NextLink to be the query alone - not the full URL.

The relevant code on the server side is here: https://github.com/CommunityToolkit/Datasync/blob/8.x/src/CommunityToolkit.Datasync.Server/Controllers/TableController.Query.cs#L163C5-L196C1

    internal static string CreateNextLink(HttpRequest request, int skip = 0, int top = 0)
        => CreateNextLink(new UriBuilder(request.GetDisplayUrl()).Query, skip, top);

    internal static string CreateNextLink(string queryString, int skip = 0, int top = 0)
    {
        List<string> query = (queryString ?? "").TrimStart('?')
            .Split('&')
            .Where(q => !q.StartsWith($"{SkipParameterName}=") && !q.StartsWith($"{TopParameterName}="))
            .ToList();

        if (skip > 0)
        {
            query.Add($"{SkipParameterName}={skip}");
        }

        if (top > 0)
        {
            query.Add($"{TopParameterName}={top}");
        }

        return string.Join('&', query).TrimStart('&');
    }

You will note that it generates the nextLink based on the query string as well. That means one of a few possible things:

1. You are using a pre-Community Toolkit version of the server. This might be confirmed by the fact you are including the ZUMO-API-VERSION. Community Toolkit is not backwards compatible (although it can use the same database).
2. You have a proxy that is appending the link address to nextLink somehow. Again - not supported.

[atexinspect]

Hi Adrian,
You are correct, my server was using a pre-community toolkit version. I have updated using the sample code and the pull operation is now working as expected. Thank you very much for the support it is very much appreciated.

Paul.