search cancel

Delete Investments Job Fails with Folder Error


Article ID: 128583


Updated On:


Clarity PPM On Premise


The Delete Investments job is failing with the following error in the bg-ca logs: 

ERROR 2019-03-04 19:31:16,818 [Dispatch Delete Investments : [email protected] (tenant=clarity)] xql2.xbl (clarity:admin:48807071__9CC6B1BD-423C-449C-9370-10A6709B5133:Delete Investments) Error while attempting to delete PR0123 (5110000)
ERROR 2019-03-04 19:31:16,820 [Dispatch Delete Investments : [email protected] (tenant=clarity)] xql2.xbl (clarity:admin:48807071__9CC6B1BD-423C-449C-9370-10A6709B5133:Delete Investments) com.niku.union.exceptions.DMSException: User does not have read permissions on this folder


Release: CODFSS99000-15.4-PPM SAAS FedRAMP-Sandbox-Small Environment


In order to delete the project that the job is failing on, the user running the Delete Investments job will need to be made a Collaboration Manager on the project. 

The following set of steps can be used: 
1. In the PPM UI, go to the Team tab of the project in question. Based on the error message on this example, project PR0123
2. Add the resource to the project team, which also adds the resource as a project participant (based on the 'Automatically Add Staff Members As Investment Participant' under Administration - Project Management - Settings)
3. To then make the resource a collaboration manager, create an xml file with the following and use XOG to make the update: 

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">
  <Header version="6010" action="write" objectType="user" externalSource="ORACLE-FINANCIAL"/>
                        <User externalId=" " userName="<username>" userStatus="Active">
                                    <PersonalInformation emailAddress="<user's email address>" firstName="<users first name>" lastName="<user's last name>"/>
                                    <Resource resourceId="<resource id>"/>
                                                <Group id="CLB_PROJECT_MEMBERS5110000">
                                                            <nls languageCode="en" name="project 5110000 participant group"/>
                                                <Group id="CLB_PROJECT_MANAGERS5110000">
                                                            <nls languageCode="en" name="project 5110000 CM group"/>

Where the 5110000 number referenced is the internal ID of the project that the job is failing on. 

Once steps 1-3 are completed, re-run the Delete Investments job (logged in as the user that is now one of the the collaboration managers on this project). 

Additional Information

KB000056374 - Delete Investments Job - Where do I look for errors?
KB000038536 - Delete Investments Job Fails - PRJ-07536 error

articleID94955 - Delete Investments job fails with a PRJ-07536 Error Due to a Unfinished Process on the Investment