Hi,
We are running Apex 24.2 on-premise and have 3 environments, DEV, TEST and PROD.
Whenever a bug is fixed or an enhancement is completed in DEV, we will take an application export and import it to higher environments, TEST & PROD, overwriting the existing application.
Later, we noticed that after every such migration of changes, the workflow transactions that are enroute is stuck with the last approver and do not proceed further, it will throw a NO DATA FOUND issue when the approver tries to take an action, because the relevant transaction goes missing in the APEX_TASKS table.
My question is, what is the right approach to migrate an application change from one instance to another (on-premise installation) and how to prevent this data loss?
Looking forward to getting advice to overcome this issue.
Regards,
Mohammed Sadiq