Delete Investments Job Fails - Error in PRJ_DELETE_COLLAB_SP

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

Description:

The Delete Investments Job fails when a Project contains Project > Participant Groups.

Steps to Reproduce:

  1. Create a Project Template with more than one Participant Groups 
  2. Create a New Project from this Template 
  3. Check the new project to ensure the Participant Groups have been copied over 
  4. Mark the Project for Deletion 
  5. Execute the 'Purge Financial Tables' job to remove actual financial transactions 
  6. Execute the 'Delete Investments' job 

Expected Results: The Project should be deleted.

Actual Results: The 'Delete Investments' job fails with the following error.

BG-CA.LOG ERROR MESSAGE:

ERROR 2014-11-10 12:57:56,860 [Dispatch Thread-11278 : bg@bgservername] xql2.xbl (none:none:none) Error while attempting to delete PR05640 (5054446)
ERROR 2014-11-10 12:57:56,862 [Dispatch Thread-11278 :bg@bgservername] xql2.xbl (none:none:none) com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in PRJ_DELETE_COLLAB_SP : : ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "CLARITYDB.PRJ_DELETE_COLLAB_SP", line 189
ORA-06512: at line 1
...
ERROR 2014-11-10 12:59:58,819 [Dispatch Thread-11278 : bg@bgservername] niku.njs (none:none:none) Error executing job: 5210864 error An error occurred while attempting to delete one or more projects in the background scheduler. Please, refer to the log for details.

Solution:

WORKAROUND:

This issue is caused by the presence of Participant Groups that were added to the project from a template 

  1. Login to Clarity as the Collaboration Manager on the project marked for deletion 
  2. Navigate to the project marked for deletion 
  3. Project, Team, Participant Groups 
  4. Remove all Participant Groups from the project 
  5. Execute the 'Purge Financial Tables' job to remove actual financial transactions 
  6. Execute the 'Delete Investments' job 

STATUS/RESOLUTION:

CLRT-12143: Tested, verified and closed as 'Cannot Reproduce' in version 13.2