The total number of sync rows with the web source is 136,614 but in the Record List there are only 82,874. After each sync with the web source the number of rows in list are different (80,000 - 90,000).What could be the reason?
Discussion posts and replies are publicly visible
Did you check for any error messages? Is the sync batched? Any more details ...?
sync completed with green mark. I use batching:
pagingInfo: a!pagingInfo( startIndex: 1 + ((ri!batchNum - 1) * 1000), batchSize: 1000 )the number of rows in sync grid is equal to number of rows in external DB.But in the Record List I don`t see all of them. No filters applied.
That's weird. Could it be that there are duplicate primary keys?
No, because duplication of primary keys break a sync with the web source. All keys are unique
Is it possible that you're using default filters or row-level security? Both of those could limit the number of records that are shown on the record list (even if all the data was synced).
I don`t use default filter and row-level-security
So just to confirm, in your sync history grid you see 136k rows as synced; in the record list you see 80k-90k rows? What happens if you use a!queryRecordType() - do you see the total count matching the sync history grid or the record list?
Also do you see anything interesting in the tomcat stdout log while the sync occurs?
a!queryRecordType() shows the same row number as a list I don`t have an access to the tomcat log
Ok it might be worth opening a support ticket - if your sync history is showing the correct number of rows, any queries should be able to return all the rows synced.
ok, thanks
Hi Sofia, has the issue been resolved?