Idea object XOG fails with error when we try to remove a resource from the Idea write XOG file by adding delete="true"

Document ID : KB000047990
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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:

  1. Create an Idea investment

  2. Go to the Team tab and add a resource

  3. XOG out the idea

  4. In the output file add delete="true" for the resource in the resources section

  5. 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

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

This is documented as CLRT-75660 and is currently reviewed by the CA Clarity Development team