This I think is one of those questions that will be hard to solve, hopefully I’m wrong.
I have been using the Data Migration Manager for some time now, it works well(ish) for (al)most all containers… sometimes… well… nobody’s perfect 😁
One area where I have struggle particularly is the Additional Deployment Processes, more specifically, the Post Deployment actions that update statuses.
I have seen one example created by IFS R&D which is the one that update statuses for CUSTOMER_ORDER entities. It is normally included in DMM templates and it does precisely what it should do.
I needed to do something similar for PROJECTS.
I thought updating STATES for other entities (such as PROJECTS) using this example as reference, should land me where I needed to be, so after finding what code behind gets executed when updating the STATE of Project I got myself into the task of creating a similar Additional Deployment Process in DMM, only to move projects from Initialized to Approved.
Here is the header...
… and here are the parameters…
So far so good, but when I try to deploy a record to test this whole thing, I get a COMPILATION ERROR!?
The error is:
DeploymentContainer/Form (server error)
Database error occurred. Contact administrator.
Error details:
{"code":24344,"message":"ORA-24344: success with compilation error"}Here is the thing: if I disable this Additional Deployment Process, the error goes away. It is 100% something related to this. I tried running as a Background Process but I stumble upon the same error
I am not sure how to troubleshoot this error. IFS doesn’t seem to provide a lot of tools to dig deeper, I can’t find the real reason why IFS fails to compile something related to my PROJECT_API.EV_APPROVE__ call.
Any ideas around here?