Citizen Complaint Resolution System Migration

Learn more about module migration details

Setup

Config/Service Name	Path/Build
Persister yml for bulk migration	https://github.com/egovernments/configs/blob/DEV/egov-persister/pgr-migration-batch.yml
pgr-services	pgr-services-db:pgr-migration-2475ec38-56
rainmaker-pgr	rainmaker-pgr-db:pgr-migration-c046a264-20

The above build has to be deployed to perform the migration. The batch persister config has to be added in config Repo. After adding the file in the repo, update the persister path in the environment yml file. Make sure the persister.bulk.enabled is set to true. Once done restart the persister pod.

To start the migration, call the following API with tenantId as a parameter. It will migrate data belonging to that tenantId. The API does not have role action mapping and should be used by port forwarding rainmaker-pgr pod.

curl --location --request POST 'http://localhost:8083/rainmaker-pgr/v2/_migrate?tenantIds=pb.jalandhar' \
--header 'Content-Type: application/json' \
--data-raw '{
     "RequestInfo": {
        "apiId": "Rainmaker",
        "action": "",
        "did": 1,
        "key": "",
        "msgId": "20170310130900|en_IN",
        "requesterId": "",
        "ts": 1513579888683,
        "ver": ".01",
        "authToken": "6fc5bb66-f3f1-49fa-b750-34f7b33d80d4",
        "userInfo": {
        "id": 23287,
        "uuid": "4632c941-cb1e-4b83-b2d4-200022c1a137",
        "userName": "PalashS",
        "name": "Palash S",
        "mobileNumber": "9949032246",
        "emailId": null,
        "locale": null,
        "type": "EMPLOYEE",
        "roles": [
            {
                "name": "PGR Last Mile Employee",
                "code": "PGR_LME",
                "tenantId": "pb.amritsar"
            },
            {
                "name": "Employee",
                "code": "EMPLOYEE",
                "tenantId": "pb"
            },
            {
                "name": "Employee",
                "code": "EMPLOYEE",
                "tenantId": "pb.amritsar"
            }
        ],
        "active": true,
        "tenantId": "pb.amritsar"
    }
    }
}'

WSD

Validation Queries

select  distinct(action),count(*) from eg_pgr_action group by  action
select st.state,count(*) from eg_wf_processinstance_v2 pi INNER JOIN eg_wf_state_v2 st ON st.uuid = pi.status  where businessService ='PGR' group by st.state

select tenantId,count(*) from eg_pgr_service group by tenantId;
select tenantId,count(*) from eg_pgr_service_v2 group by tenantId;

select servicecode,count(*) from eg_pgr_service group by servicecode;
select servicecode,count(*) from eg_pgr_service_v2 group by servicecode;

select active,count(*) from eg_pgr_service group by active;
select active,count(*) from eg_pgr_service_v2 group by active;

select count(*) from eg_pgr_address
select count(*) from eg_pgr_address_v2

-- Assignee count match
select count(*) from eg_pgr_action where assignee is not null;
select count(*) from eg_wf_assignee_v2;

select count(*)  from eg_pgr_action  where media NOT in ('[]','null')
select count(*) from eg_wf_document_v2 where processinstanceid IN (select id from eg_wf_processinstance_v2 where businessService ='PGR')

*(Last query related to document might need little modification as values in NOT IN clause can be more than the 2 specified)

Prod Data Insights

1. A null value is stored in action for adding comments in the old system it’s mapped to COMMENT in the new system.

2. The Locality attribute in the new eg_pgr_address_v2 table does not allow NULL values whereas the locality attribute in the old eg_pgr_address in Punjab prod data has NULL values. Those values are filled in migration with the dummy value NOT_AVAILABLE.

3. For 128 records accountId is NULL so they won’t be associated with any citizen login.

4. For some records in the media column, corrupt data is present. For example, in one case instead of fileStore UUID some normal text describing the complaint is present. While some other records have values like no. For data with such text having a length greater than 64 is set to null, else DB validations are violated.

5. In the old system-id is stored for referencing user data. In new systems we use UUID to refer users, therefore all id is mapped to respective UUIDs which are then migrated to the new system. If some user has UUID as NULL default value NOT_SPECIFIED will be used.

6. Some 1104 complaints have value in the column named feedback which seems to be from some set of predefined values like "Resolution Time", "Quality of work", ”others” etc. The new structure does not have any such column so we will be storing this in additionalDetails.

7. The address and landmark column in eg_pgr_service has values in some columns they are also stored in additionalDetails.

8. The phone column contains phone numbers, we are not migrating that column as it has PII data and will be already present in user service as well.

9. If SLA is not found in the old config (will only happen if some complaint category is removed from MDMS and complaints are present in the system of that category) default SLA value will be used.