My Oracle Support Banner

Some of the Primavera Gateway Tables Have Grown Very Large. Is It Possible to Reduce the Size of the Tables or Delete Old Synchronization Jobs in Large Batches? (Doc ID 2314248.1)

Last updated on MARCH 29, 2023

Applies to:

Primavera Gateway - Version 16.1.4.0 and later
Information in this document applies to any platform.

Goal

Is there a way to decrease the size of the Primavera Gateway tables? In the Primavera Gateway database, tables that hold the data for synchronization jobs are growing very large. In versions where the job information can be deleted from the Primavera Gateway UI, deleting the jobs sometimes hangs because of the large number of jobs. In versions of Primavera Gateway that do not allow deletion of the synchronization jobs from the Primavera Gateway, the tables continue to grow and there is no way to remove data that is no longer needed.

Tables Related to Job Synchronizations:

FLOWINST
FLOWSTEPINST
FLOWSTEPINSTLOG
FLOWSTEPINSTMSG
FLOWINSTREVIEW
FLOWINSTREVIEWXREF
PARAMVALUE
OBJECTLOG  (Post version 17.7)

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.