Sync upload local changes reordering patch issue

[ndegwamartin]

Sync upload local changes reordering patch issue

[aditya-07]

@ndegwamartin Can you add some data for the valid cycle.

[santosh-pingle]

@ndegwamartin Did you share the data with @aditya-07 for the valid cycle?
@ndegwamartin Do you mean the resources are already in sync, and it only throws exceptions when uploading updates during a valid cycle?

[ndegwamartin]

@aditya @santosh-pingle for context the above screenshot was captured after migrating to the latest codebase.

Attached is the SQL to recreate the state of the LocalChangeEntity and LocalChangeResourceReferenceEntity
resources_db-LocalChanges.sql.zip . Let me know if you need data from any of the other tables.

I'm also happy to jump on a call to clarify further

[ndegwamartin]

@aditya-07 related to the above these are the resources(count by resource type) that could not be synced via Upload

[aditya-07]

@aditya @santosh-pingle for context the above screenshot was captured after migrating to the latest codebase.

Attached is the SQL to recreate the state of the LocalChangeEntity and LocalChangeResourceReferenceEntity resources_db-LocalChanges.sql.zip . Let me know if you need data from any of the other tables.

I'm also happy to jump on a call to clarify further

@ndegwamartin The .zip doesn't have sql to recreate LocalChangeResourceReferenceEntity .

[ndegwamartin]

@aditya-07 you are correct, appears the LocalChangeResourceReferenceEntity was not part of the archive. I've recreated the scripts with a new data set attached here - LocalChangesSQL.zip