Update All Shells Job Finishes, but Only a Few Shells Are Updated

(Doc ID 2240687.1)

Last updated on OCTOBER 31, 2017

Applies to:

Primavera Unifier - Version 9.7 and later
Primavera Unifier Cloud Service - Version 9.7 and later
Information in this document applies to any platform.

Symptoms

1) A few Shell Templates have been created which have multiple Groups and Users.

When Update Shells > All Shells is triggered the job finishes, but only a few shells are updated.

When Update Shells > History is checked we found some error messages against particular users/groups, however when the job is triggered against the user/group that failed the job finishes successfully.
The below error can be found in the logs:Exception while pushing the users to all the projects in batch=7 ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT'

2) The Submit Date showed, but Start Date/End Date/Status are all blank. Users may facing this issue frequently in monthly basis. Once user renew the DB locks and restart the server, the issue is getting resolved. But it will be a problem again about 15 days later.

See the following error:
Company Workspace->Templates->Shells-> Projects-> PROJECT TEMPLATE->Setup->Business Processes->the problem BP->Update Projects/Shells : History, there is no Start Date , no End Data, and no Status.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms