Workflow config-Replacement data-Migration Document for Bill Amendment W&S

This document contains the steps to create new workflow configs specific to WS and SW modules for Bill Amendment.

1. Create the new Workflow configs in the same tenant-Id as the one you want to replace in the applications.
   
   New configs for WS and SW bill amendment are as follows:
   Curl for WS Bill Amendment Config:

   curl --location --request POST 'https://egov-micro-qa.egovernments.org/egov-workflow-v2/egov-wf/businessservice/_create' \ --header 'Content-Type: application/json' \ --data-raw '{ "RequestInfo": { "apiId": "Rainmaker", "action": "", "did": 1, "key": "", "msgId": "20170310130900|en_IN", "requesterId": "", "ts": 1513579888683, "ver": ".01", "authToken": "", "userInfo": { "id": 73, "userName": null, "name": null, "type": "EMPLOYEE", "mobileNumber": null, "emailId": null, "roles": [ { "id": 2, "name": "Customer Support Representative", "code": null, "tenantId": null } ], "tenantId": null, "uuid": "uuid" } }, "BusinessServices": [ { "tenantId": "pb.amritsar", "businessService": "WS.AMENDMENT", "business": "WS", "businessServiceSla": 0, "states": [ { "tenantId": "pb.amritsar", "sla": null, "state": null, "applicationStatus": "INWORKFLOW", "docUploadRequired": false, "isStartState": true, "isTerminateState": false, "isStateUpdatable": false, "actions": [ { "tenantId": "pb.amritsar", "action": "OPEN", "nextState": "APPROVALPENDING", "roles": [ "CITIZEN", "SW_CEMP", "WS_CEMP" ], "active": true } ] }, { "uuid": "APPROVALPENDING", "tenantId": "pb.amritsar", "sla": null, "state": "APPROVALPENDING", "applicationStatus": "INWORKFLOW", "docUploadRequired": false, "isStartState": true, "isTerminateState": false, "isStateUpdatable": false, "actions": [ { "tenantId": "pb.amritsar", "currentState": "APPROVALPENDING", "action": "APPROVE", "nextState": "APPROVED", "roles": [ "WS_APPROVER", "SW_APPROVER" ], "active": true }, { "tenantId": "pb.amritsar", "currentState": "APPROVALPENDING", "action": "REJECT", "nextState": "REJECTED", "roles": [ "WS_APPROVER", "SW_APPROVER" ], "active": true }, { "tenantId": "pb.amritsar", "currentState": "APPROVALPENDING", "action": "SEND_BACK", "nextState": "PENDING_FOR_CITIZEN_ACTION", "roles": [ "WS_APPROVER", "SW_APPROVER" ], "active": true } ] }, { "tenantId": "pb.amritsar", "sla": null, "state": "REJECTED", "applicationStatus": "INACTIVE", "docUploadRequired": false, "isStartState": false, "isTerminateState": true, "isStateUpdatable": false, "actions": null }, { "tenantId": "pb.amritsar", "sla": null, "state": "APPROVED", "applicationStatus": "ACTIVE", "docUploadRequired": false, "isStartState": false, "isTerminateState": true, "isStateUpdatable": false, "actions": null }, { "uuid": "PENDING_FOR_CITIZEN_ACTION", "tenantId": "pb.amritsar", "sla": null, "state": "PENDING_FOR_CITIZEN_ACTION", "applicationStatus": "INWORKFLOW", "docUploadRequired": false, "isStartState": false, "isTerminateState": false, "isStateUpdatable": true, "actions": [ { "tenantId": "pb.amritsar", "currentState": "PENDING_FOR_CITIZEN_ACTION", "action": "RE-SUBMIT", "nextState": "APPROVALPENDING", "roles": [ "CITIZEN", "SW_CEMP", "WS_CEMP" ], "active": true } ] } ] } ] }'

   
   Curl for SW Bill Amendment Config:
   
   

   curl --location --request POST 'https://egov-micro-qa.egovernments.org/egov-workflow-v2/egov-wf/businessservice/_create' \ --header 'Content-Type: application/json' \ --data-raw '{ "RequestInfo": { "apiId": "Rainmaker", "action": "", "did": 1, "key": "", "msgId": "20170310130900|en_IN", "requesterId": "", "ts": 1513579888683, "ver": ".01", "authToken": "", "userInfo": { "id": 73, "userName": null, "name": null, "type": "EMPLOYEE", "mobileNumber": null, "emailId": null, "roles": [ { "id": 2, "name": "Customer Support Representative", "code": null, "tenantId": null } ], "tenantId": null, "uuid": "uuid" } }, "BusinessServices": [ { "tenantId": "pb.amritsar", "businessService": "SW.AMENDMENT", "business": "SW", "businessServiceSla": 0, "states": [ { "tenantId": "pb.amritsar", "sla": null, "state": null, "applicationStatus": "INWORKFLOW", "docUploadRequired": false, "isStartState": true, "isTerminateState": false, "isStateUpdatable": false, "actions": [ { "tenantId": "pb.amritsar", "action": "OPEN", "nextState": "APPROVALPENDING", "roles": [ "CITIZEN", "SW_CEMP", "WS_CEMP" ], "active": true } ] }, { "uuid": "APPROVALPENDING", "tenantId": "pb.amritsar", "sla": null, "state": "APPROVALPENDING", "applicationStatus": "INWORKFLOW", "docUploadRequired": false, "isStartState": true, "isTerminateState": false, "isStateUpdatable": false, "actions": [ { "tenantId": "pb.amritsar", "currentState": "APPROVALPENDING", "action": "APPROVE", "nextState": "APPROVED", "roles": [ "WS_APPROVER", "SW_APPROVER" ], "active": true }, { "tenantId": "pb.amritsar", "currentState": "APPROVALPENDING", "action": "REJECT", "nextState": "REJECTED", "roles": [ "WS_APPROVER", "SW_APPROVER" ], "active": true }, { "tenantId": "pb.amritsar", "currentState": "APPROVALPENDING", "action": "SEND_BACK", "nextState": "PENDING_FOR_CITIZEN_ACTION", "roles": [ "WS_APPROVER", "SW_APPROVER" ], "active": true } ] }, { "tenantId": "pb.amritsar", "sla": null, "state": "REJECTED", "applicationStatus": "INACTIVE", "docUploadRequired": false, "isStartState": false, "isTerminateState": true, "isStateUpdatable": false, "actions": null }, { "tenantId": "pb.amritsar", "sla": null, "state": "APPROVED", "applicationStatus": "ACTIVE", "docUploadRequired": false, "isStartState": false, "isTerminateState": true, "isStateUpdatable": false, "actions": null }, { "uuid": "PENDING_FOR_CITIZEN_ACTION", "tenantId": "pb.amritsar", "sla": null, "state": "PENDING_FOR_CITIZEN_ACTION", "applicationStatus": "INWORKFLOW", "docUploadRequired": false, "isStartState": false, "isTerminateState": false, "isStateUpdatable": true, "actions": [ { "tenantId": "pb.amritsar", "currentState": "PENDING_FOR_CITIZEN_ACTION", "action": "RE-SUBMIT", "nextState": "APPROVALPENDING", "roles": [ "CITIZEN", "SW_CEMP", "WS_CEMP" ], "active": true } ] } ] } ] }'

   
   
   

2. List all the states from the process instances of the old workflow(business service) config.
   select uuid,state  from eg_wf_state_v2 where businessserviceid=(select UUID from eg_wf_businessservice_v2 where businessservice='BS.AMENDMENT' and tenantid='pb');

eg:--

1. List the states from the new business service created for replacement using this query
   SELECT UUID, state FROM eg_wf_state where businessService='WS.AMENDMENT' AND business='WS' AND tenantid='pb'

2. SELECT UUID, state FROM eg_wf_state where businessService='SW.AMENDMENT' AND business='SW' AND tenantid='pb'
   
   

1. Replace the state-ids of the old workflow in the eg_wf_processinstance table with stateids of the new workflow.

2. Write an update query (one for each state UUID) to rewrite the process-instance table as shown above
   update eg_wf_processinstance_v2 set status={new state uuid} AND businessservice={WS.AMENDMENT}  and modulename={WS} where businessservice={BS.AMENDMENT} and status={old state uuid}  and businessid like '%WS%';

3. update eg_wf_processinstance_v2 set status={new state uuid} AND businessservice={SW.AMENDMENT}  and modulename={SW} where businessservice={BS.AMENDMENT} and status={old state uuid}  and businessid like '%SW%';

Open

Note: businessid like '%SW% or businessid like '%WS% will be used depending on the New businessService that you are using. moduleName in the above query would take WS or SW in sync with the new businessService

1. The status and businessservice columns should be set to the new values from the newly created business-service master create based on the old status and id of the process-Instance.

1. Rename or delete the old business service (BS.AMENDMENT) to avoid any of the applications using it wrongly in future. 
   {update eg_wf_businessservice set businessservice='BS.AMENDMENT-deprecated' where businessservice='BS.AMENDMENT'}

2. UI/BACKEND will have to replace their configs to fetch the workflow configs for WS and SW.
   Changes required from UI:
   Bill Amendment Workflow _create and _update APIs - replace businessservice BS.AMENDMENT with WS.AMENDMENT/SW.AMENDMENT and moduleName BS with WS/SW as per the requirement.
   Bill Amendment Inbox - replace businessservice BS.AMENDMENT with WS.AMENDMENT/SW.AMENDMENT as per the requirement.
   
   

DevOps changes:

1. Add path for searcher for inbox:
   file:///work-dir/configs/egov-searcher/inboxBillAmendmentWsSearch.yml,file:///work-dir/configs/egov-searcher/inboxBillAmendmentSwSearch.yml here

2. Add new property for inbox 

3. Add searchpaths -
   "WS.AMENDMENT,SW.AMENDMENT":{"searchPath":"http://billing-service.egov:8080/billing-service/amendment/_search","dataRoot":"Amendments","applNosParam":"consumerCode","businessIdProperty":"amendmentId","applsStatusParam":"status"} here.