We too have started to experience this situation in our ArcGIS Enterprise v10.7.1 environment.
Quick Tech Details:
- ArcGIS Enterprise v10.7.1 - MS IIS, Web-adaptor for portal & server, hosting server & federated (non hosting) server. This was upgraded from v10.6.1
- Publishing from back-end SQL Server 2017 (running Enterprise Geodatabase v10.6.1)
- Published with a SQL "editor" account (not the data schema owner)
If we publish the service with our data schema owner, then the offline download/sync functions as expected. If we publish with a built-in SQL Server "editor" account, then the sync fails with the same behavior mentioned in this thread "No path for delta data changes". All other references we searched for were related to the ORACLE "create table" issues.
We deployed a feature service with this configuration (sync enabled and published with a built-in SQL 'editor' account) when we originally built the ArcGIS Enterprise environment at v10.6.1 and were successful with offline sync then. Seems possibly related to the v10.7.1 upgrade?
We may try to upgrade the back-end Enterprise Geodatabase to v10.7.1 to see if it resolves, but expect it to continue to fail.
The back-end SQL Editor account has full "Insert/Create, Update, Delete, Query/Read" permissions on all back-end database tables (including their underlying 'a' and 'd' tables in the traditional versioned configuration). The SQL editor account also has "connect, create table/procedure/view/function" permissions.
Any help is appreciated. Thanks.