Project and Portfolio Management Practitioners Forum
cancel

Delete Project Error

Highlighted
kndlny
Super Contributor.

Delete Project Error

Hi,

 

We are using PPM v9.10.

 

We want to delete old project in our system.

 

Interesting thing is, Delete Project button is visible in some of these projects but not visible in most of them.

 

And, even if it is visible when we try to delete the project we are usually getting the error in the attachment. But sometimes

 

we don't get the error and successfully delete projects.

 

It says something like  "The reference you are trying to add is already deleted" when we try to delete a project but I assure

 

you nothing has been deleted.

 

Anybody has an idea why sometimes this button is visible and sometimes not, and even if  it is possible what might be the

 

reason for this error ?

 

You can also find the logs generated in the server log when we get this error.

 

Thanks
 

4 REPLIES
penoles
Super Contributor.

Re: Delete Project Error

if you can not see  delete button on the project which you are sure to have privillege, in most cases this project is created from a proposal.

 

The error you shown seems these project have invalid reference, check the reference on the project page and also check with it in backend db from following querys(replace project ID/user id for you own). make sure the references are existed.

select * FROM KNTA_REFERENCES_V
WHERE STORED_SOURCE_ENTITY_ID = 6
AND SOURCE_ID = <project ID>
AND SHOW_TARGET_TYPE_FLAG = 'Y'
AND ENABLED_FLAG = 'Y'
AND TARGET_TYPE_CODE != '20'

 

select * FROM KNTA_SECURED_REQ_REFS_V
WHERE STORED_SOURCE_ENTITY_ID = 6
AND SOURCE_ID = <project ID>
AND SHOW_TARGET_TYPE_FLAG = 'Y'
AND ENABLED_FLAG = 'Y'
AND USER_ID = <user id who do delete>

 

 

d4y4n4
Honored Contributor.

Re: Delete Project Error

Hi,

Try with these steps if the project stem from proposals

This should not be viewed as a workaround to delete projects on a regular basis.

1) Navigate to the Project that is to be deleted
2) Click on the References tab, note down the Proposal Request #, let's call this "ProposalRequestNo"
3) Click on Search > Requests. In Request Type field, enter the Proposal Request Type (PFM - Proposal or others) used.
4) Select "Include Closed?" to 'Yes', click on Search
5) On the Results page select the Proposal as got in Step 2
6) Click on 'Delete'
7) Using SQL*Plus or any DB tool log on to the schema that the PPM server is using
8) Run the following SQL:

update pfm_lifecycle_parent_entity set proposal_req_id = NULL where proposal_req_id =


9) Go to the project that is to be deleted and click on 'Delete'. The project should now be deleted.
10) Repeat Steps 1 thru 9 for other projects.

Regards,
Dayana Campos
kndlny
Super Contributor.

Re: Delete Project Error

Hi penoles,

 

Thanks for the reply but I do not understand how it is gonna solve my problem.

 

Yes, when I run the quires, it shows the referenced requests.  Then, what am I supposed to do?

 

These are all created from requets by the way.

 

Thanks

kndlny
Super Contributor.

Re: Delete Project Error

Hi d4y4n4,

 

Thanks for the reply.

 

As far as I know, you cannot delete requests that are related with the projects.

 

Any other way I should fallow?

 

Thanks