When using Clarity XML Open Gateway (XOG) to update an existing Idea, the XOG fails when attempting to remove a resource from the investment.
java.lang.Exception: 101 : com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (<db_schema_name>.PRASSIGNMENT_U1) violated.
Steps to Reproduce:
- Create an Idea investment
- Go to the Team tab and add a resource
- XOG out the idea
- In the output file add delete="true" for the resource in the resources section
- XOG back in the modified XOG file from step 4
Expected Result: XOG should be successful with warnings to advise the resource cannot be removed
Actual Result: XOG fails with error
This is documented as CLRT-75660 and is currently reviewed by the CA Clarity Development team