When trying to move my app changes from dev to prod during the application import process, replace application, I'm getting this error:
Variable restrucured. 8196825713820203value IDT_WF_IDT_ID
ORA-02291: integrity constraint (APEX_230200.WWV_TASK_WF_FK) violated - parent key not found
We're on Apex 23.2.6.
IDT_WF is the name of my workflow and IDT_ID is the primary key/parameter for the workflow. I can import and replace the application changes in development without issue. It is just in production that the error occurs. The main difference is that production has many active workflows and the application changes include a new version of the workflow.
There is back end processing that occurs when importing the application that invalidates and suspends any old workflows (unfortunately) and I think this error is coming from that.
I read on another post that this error can be caused by using the ‘Original IDs’ option on application export. Our process to move to production uses this option so that git won’t go crazy with ID changes. Even so, I exported again without that option and get the same error.
I would be able to delete the application and import it fresh, but that would wipe out all the workflow history currently in production and that isn’t really an option.
Are there any ideas on how I can troubleshoot this and somehow get this new workflow into production?