Clarity

We have 8 applications that are marked for deletion, but I can't get the job to process them. I receive this error: "PRJ-07536: An error ocurred while attempting to delete one or more projects in the background scheduler. Please, refer to the log for details."

Nothing else in our environment is marked for Deletion that I can find (checked both Projects and Programs). We're an OnDemand environment running 14.2.

I found this checklist but I've checked all of this and I'm still getting an error.

     Please make sure that:

1. The investment is inactive.

2. The investment contains no WIP entries.

3. The investment contains no non-zero time entries.

4. The Financial Properties Status is set to "Closed".

5. There are no process instances attached to this investment or tasks on the investment

6. There are no requisitions attached to this investment.

7. There is not a Participant Group on the project.

Any ideas? Screen shots of settings and team below. THANK YOU in advance!

What do you see in the logs ?

NJ

I think these are the applicable lines:

WARN  2016-02-18 08:59:59,236 [Dispatch pool-5-thread-4 : bg@sc5app076.casaasops.com (tenant=clarity)] niku.xql2 (clarity:hcook:7767507__901F3F49-2919-40F4-8EF6-73048D06B8AB:Delete Investments) Failed to delete records from query referenced in select deleteODF :com.niku.union.persistence.PersistenceApplicationException

ERROR 2016-02-18 08:59:59,236 [Dispatch pool-5-thread-4 : bg@sc5app076.casaasops.com (tenant=clarity)] xql2.xbl (clarity:hcook:7767507__901F3F49-2919-40F4-8EF6-73048D06B8AB:Delete Investments) Error while attempting to delete APP-00000166 (5026023)

ERROR 2016-02-18 08:59:59,237 [Dispatch pool-5-thread-4 : bg@sc5app076.casaasops.com (tenant=clarity)] xql2.xbl (clarity:hcook:7767507__901F3F49-2919-40F4-8EF6-73048D06B8AB:Delete Investments) com.niku.union.odf.exception.ODFException: com.niku.union.persistence.PersistenceApplicationException

It had the same display for all 8 of them we're trying to delete.

You might want to check out access rights (of the user/owner of the job) ; see some comments in this recent discussion ; Delete Investments Job is failing due to error in project deletion.

Unfortunately I logged in as admin as well and it gives the same error.

OK, but don't assume that the admin user (or a system administrator with some "admin access rights") has access to all the data in the application ; it doesn't - the admin user only has access to administrate the system, which isn't the same thing as having access to all the data in the system!

That account is our companies only admin account though (we're small). Is there a permission on that account that I should look for that maybe CA missed when setting it up initially? Thank you!

Project - Delete - All

NJ

Unfortunately that doesn't seem to be it as I did already have that access right. Thank you though!

Hi hcook

Can you please check if following these steps help you to get rid of this problem?

1. Navigate to Home, Project, Schedule page and change the Track Mode to Other.
2. If the Project has financial actual hours, the 'Purge Financials' job must be executed for this investment before the 'Delete Investments' job is executed.
3. Execute the 'Delete Investments' job.

Note: Change the project track mode from Clarity to Other if the assignments have actuals. If you do not change the track mode, the project is not deleted

Let me know if that helps.

Regards,

Abhisek Dhar

I changed all of them from Track Mode of None to Other, but unfortunately got the same error. Any other ideas? None of these have any financials associated with them as they were just applications. Thank you!

Heidi

I would guess that the root of the problem is around this:

WARN  2016-02-18 08:59:59,236 [Dispatch pool-5-thread-4 : bg@sc5app076.casaasops.com (tenant=clarity)] niku.xql2 (clarity:hcook:7767507__901F3F49-2919-40F4-8EF6-73048D06B8AB:Delete Investments) Failed to delete records from query referenced in select deleteODF :com.niku.union.persistence.PersistenceApplicationException

It appears that some ODF table records are not being deleted which would cascade into unable to delete the application.

So I would enable a trace logger on com.niku.union.persistence to see if you get any additional information on what is happening in that class.

The application object has references to these tables:

• FIN_FINANCIALS
• INV_APPLICATIONS
• INV_INVESTMENTS
• PAC_MNT_PROJECTS
• ODF_CA_APPLICATION
• ODF_CA_INV

So I would check the DB permissions around the ODF_CA_APPLICATION, ODF_CA_INV tables.

Just guessing,

Gene

Since we're on demand, do I have to check with CA on the DB permissions? Or is that something I can look up? Thank you!

Heidi

Hello,

This looks like same issue that i have encountered last week. It is an access right issue.

Your Administrator login id should have Edit right, View rights, Delete rights for all the secure sub objects and custom sub objects. once you have added 3 rights for the objects . Then if you run the job delete investments job will run successfully.

Go to studio -objects and filter master project  with 'project' and add all that object access rights.

I went through and added all rights to everything listed in the project under the master project filter, and am still getting the error. Any other ideas? Thank you!

Heidi

^ same for "Application" master object? (in fact for any of the project subtypes)

I've now added every single access right to my account and I still get the same error. I don't think it's permissions.

Heidi

Can you check by running the below query:

select LABOR_ACTSUM from inv_investments where id = internal_id_of_application ?

NJ

Probably time to call CA-support then.