Sync issue

[mahalakshme]

User: anjalifc@cini, anjalib@cini, anjalibps@apfodisha
apk: 9.4
env: prod
fresh sync

Stacktrace:

09-24 00:14:05.999  4348  4395 D ReactNativeJS: [12:14:05:999] [SyncService][Debug] Before filter entityResources length: 7, after filter entityResources length: 7, entities length  7
09-24 00:14:05.999  4348  4395 D ReactNativeJS: [12:14:05:999] [SyncService][Debug] Creating entity create functions for schema DashboardSectionCardMapping
09-24 00:14:05.999  4348  4395 D ReactNativeJS: [12:14:05:999] [SyncService][Debug] Syncing - DashboardSectionCardMapping with subType:
09-24 00:14:06.000  4348  4395 D ReactNativeJS: [12:14:06:000] [SyncService][Debug] Creating entity create functions for [object Object]
09-24 00:14:06.010  4348  4395 D ReactNativeJS: [12:14:06:009] [ErrorHandler][Debug] SyncComponent-Sync
09-24 00:14:06.010  4348  4395 E ReactNativeJS: 'SyncComponent-Sync', 'card are mandatory for DashboardSectionCardMapping, Keys being saved - uuid,displayOrder,voided,dashboardSection,card. UUID: a1a69c7f-3b68-4ebf-8e88-af2657e8e2f2, {}', 'Error: card are mandatory for DashboardSectionCardMapping, Keys being saved - uuid,displayOrder,voided,dashboardSection,card. UUID: a1a69c7f-3b68-4ebf-8e88-af2657e8e2f2\n    at create (address at index.android.bundle:1:1104391)\n    at anonymous (address at index.android.bundle:1:1252484)\n    at anonymous (address at index.android.bundle:1:1252397)\n    at map (native)\n    at anonymous (address at index.android.bundle:1:1252383)\n    at write (native)\n    at write (address at index.android.bundle:1:1104836)\n    at bulkSaveOrUpdate (address at index.android.bundle:1:1252355)\n    at persistAll (address at index.android.bundle:1:1552044)\n    at processResponse (address at index.android.bundle:1:1555213)\n    at anonymous (address at index.android.bundle:1:1555472)\n    at tryCallOne (/root/react-native/packages/react-native/ReactAndroid/hermes-engine/.cxx/MinSizeRel/2k3l5153/arm64-v8a/lib/InternalBytecode/InternalBytecode.js:53:16)\n    at anonymous (/root/react-native/packages/react-native/ReactAndroid/hermes-engine/.cxx/MinSizeRel/2k3l5153/arm64-v8a/lib/InternalBytecode/InternalBytecode.js:139:27)\n    at apply (native)\n    at anonymous (address at index.android.bundle:1:246985)\n    at _callTimer (address at index.android.bundle:1:245979)\n    at _callReactNativeMicrotasksPass (address at index.android.bundle:1:246144)\n    at callReactNativeMicrotasks (address at index.android.bundle:1:248066)\n    at __callReactNativeMicrotasks (address at index.android.bundle:1:97211)\n    at anonymous (address at index.android.bundle:1:96350)\n    at __guard (address at index.android.bundle:1:97088)\n    at flushedQueue (address at index.android.bundle:1:96261)\n    at invokeCallbackAndReturnFlushedQueue (address at index.android.bundle:1:96204)'
09-24 00:14:06.018  4348  4395 D ReactNativeJS: [12:14:06:018] [SyncComponent::AC][Debug] Dispatching action: "SyncTelemetryActions.SYNC_FAILED"
09-24 00:14:06.029  4348  4395 D ReactNativeJS: [12:14:06:029] [SyncComponent::AC][Debug] Dispatched action completed: "SyncTelemetryActions.SYNC_FAILED" {"syncing":true,"isConnected":true,"progress":0.33999999999999964,"message":"downloadForms","syncMessage":"syncingData","startSync":false,"backgroundSyncInProgress":false,"startTime":1727116945452,"numberOfPagesProcessedForCurrentEntity":0,"totalNumberOfPagesForCurrentEntity":1}
09-24 00:14:06.030  4348  4395 D ReactNativeJS: [12:14:06:030] [SyncComponent::AC][Debug] Dispatching action: "SYNC.ON_ERROR"
09-24 00:14:06.037  4348  4395 D ReactNativeJS: [12:14:06:037] [SyncComponent::AC][Debug] Dispatched action completed: "SYNC.ON_ERROR" {"syncing":false,"isConnected":true,"progress":0.33999999999999964,"message":"downloadForms","syncMessage":"syncingData","startSync":false,"backgroundSyncInProgress":false,"startTime":1727116945452,"numberOfPagesProcessedForCurrentEntity":0,"totalNumberOfPagesForCurrentEntity":1}
09-24 00:14:06.039  4348  4395 W ReactNativeJS: registerHeadlessTask or registerCancellableHeadlessTask called multiple times for same key 'syncJob'
09-24 00:14:06.042  4348  4395 I ReactNativeJS: [12:14:06:042] [AvniBackgroundJob-SyncJobSchedule][Info] Successfully scheduled
09-24 00:14:06.212  4348  4395 I ReactNativeJS: [12:14:06:212] [Sync][Info] Starting background sync
09-24 00:14:06.212  4348  4395 I ReactNativeJS: [12:14:06:212] [Sync][Info] Skipping auto-sync since it is disabled

[himeshr]

Issue root-cause is migration "V1_342_1__SetDefaultsForStandardReportCardInput.sql", which does report_card new fields edit conditionally.
The reason we didnt face this issue earlier, was because, the migration happened long before EndOfLife1 attribute date value in our test environments.

To resolve the issue, changed the prod_vars value to

avni_endpoint_end_of_life_1: "2024-09-27"

Only entities that were modified today and included under endOfLifeEndpoints was report-cards.

select count(*) from dashboard where last_modified_date_time > '2024-09-26'::timestamp; --0
select count(*) from report_card where last_modified_date_time > '2024-09-26'::timestamp; --88
select count(*) from dashboard_section where last_modified_date_time > '2024-09-26'::timestamp; --0
select count(*) from dashboard_filter where last_modified_date_time > '2024-09-26'::timestamp; --0
select count(*) from dashboard_section_card_mapping where last_modified_date_time > '2024-09-26'::timestamp; --0
select count(*) from group_dashboard where last_modified_date_time > '2024-09-26'::timestamp; --0

[mahalakshme]

sync for cini working now

[himeshr]

sync for cini working now

Further testing suggestions, After fresh sync on 9.4 for cini user

• Upgrade of the app from 9.4 to 10.0 prod dev apk as well and confirm that there are no issues post that
• And also a fresh sync on 10.0 for the cini user and confirm that there are no issues post that

[AchalaBelokar]

• login in cini org with version 9.4 and update the version 10.0 and click on more and dashboard app is crashing login is working fine.
  https://github.com/user-attachments/assets/2818420c-815d-446b-95c2-f5b5a4279c50

[himeshr]

@AchalaBelokar Does the issue get resolved on fresh sync.? Need this info to provide proper fix.

• login in cini org with version 9.4 and update the version 10.0 and click on more and dashboard app is crashing login is working fine.
  https://github.com/user-attachments/assets/2818420c-815d-446b-95c2-f5b5a4279c50

[AchalaBelokar]

@himeshr no after doing the fresh sync I am facing the same issue.

[AchalaBelokar]

And I am download 10.0 version it is stuck on loading page that is on avni.
After clearing the data. I am able to Login with respected id.

[himeshr]

Discussion notes

• Do not make any data-fix to mitiagate the report card load on custom dashboard on upgrade from 9.4 to 10.0
• Fix failure in 10.0 apk

Code changes done

• In models, init default values for new reportCard fields : standardReportCardInputSubjectTypes, standardReportCardInputPrograms, standardReportCardInputEncounterTypes
• In Client, have a default value for duration param in indService.recentlyRegisteredV2

[petmongrels]

• binding recentlyRegisteredV2 etc should not be required, as it is getting invoked expclity on the service object instance and not via use of object mapping
• instead of checking for standardReportCardInputRecentDurationJSON being empty we should initialise it with default value in the migration if it is not present

[petmongrels]

1. Lists are initialised to empty array by default so they need to be initialised.

[himeshr]

RealmDB file of version 9.4 to test the fix using 10.0.1 apk. Do put db and login as anjalifc user of cini org.

[AchalaBelokar]

• for 10.0 when I click on dashboard it is showing same error and 10.0.1 is showing the same error.

[himeshr]

• for 10.0 when I click on dashboard it is showing same error and 10.0.1 is showing the same error.

AAh, this is because of my mistake while specifying test case..

Instead of this test case:

1> Login using 9.4

setup fast sync
Update to 10.0.0
Update to 10.0.1

Follow this one:

1> Login using 9.4

setup fast sync
Update to 10.0.1

The reason is that, since DBMigration for both 10.0 and 10.0.1 is the same, it'll not resolve the issue on install of 10.0.1 on top of 10.0.