Workflow is deleting the Catalog Tasks after approval and the result is deleted
Release or Environment
- The task table and the sc_task table shares the same prefix [TASK]
- There is a unique field that is set to true on the Number dictionary field on the task table. This is the reason why the system is not taking the next number which is already existing on the task table.
As a fix, Please change the prefix for the Catalog task table to a different prefix other than TASK in the Number Maintenance.
We strongly suggest you to test this first on the sub-production instance and regress test it before doing it on the PROD instance.
[Note: This issue is a PRB657894 where the prefix of the Catalog task table got changed from TASK to SCTASK from the Helsinki Family. The PRB will NOT be fixed for customers who have upgraded from an older version. This was made intentional. Hence the only way to resolve/ apply the fix for this issue is to manually change the prefix for the Catalog task table on the number maintenance (/nav_to.do?uri=sys_number.do?sys_id=sc_task). Again, We strongly suggest you to test this first on the sub-production instance and regress test it before doing it on the PROD instance.]