When attempting to save a project from Microsoft Project (MSP) to PPM, receive a 'Save Failed' error. In the app-ca.logs, an error similar to the below is generated:
Rolling back transaction:
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (PRASSIGNMENT0) violated
Applies to all supported PAS environments for specified releases.
There are two known solutions for this issue:
Solution 1: Delete the project from the workstation in the MSP Default save location
Solution 2: If you've copied and pasted any tasks by highlighting the entire task and then pasting, delete both the Text3 data for that pasted task in both the Task view and also the Assignment in the Resource Usage view. If you delete just the Text3 data from the task, it will give you a 'Save Failed' message, because the Text3 data is still in the assignment.
Reference KB000010395 - CA PPM Best Practices when copying and pasting tasks in MSP
Reference KB000044475 - Unable to Save Projects back to PPM from MSP if the Project Team has More than One Instance of the Same Role
Reference KB000005264 - MSP Save Failed error due to task Start or Finish Date issues in MSP
Reference KB000071385 - CA PPM and MSP integration - List of knowledge documents
Reference KB000015956 - CA PPM and MSP integration known defects - Support Technical Document Index