Unable to Save Changes on the 'Administer > Application Settings > Audit' Page Or Application Settings Page Hangs When Loading Audit Page P6 EPPM (Doc ID 2261446.1)

Last updated on JULY 31, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
In r8.4 and earlier version of P6 EPPM, the SETTINGS table did not include a column called "setting_id".  This column was added to the schema in r15.1. If auditing is enabled in r8.4 (or earlier versions of P6 EPPM), and the datbase is upgraded to r15.1 or later, the setting_id column of all auditing rows will be set with a null value.  After upgrading to r15.1 or later, if the setting_id value for auditing rows of the SETTINGS table contain a null value, one of the following two issues can occur:

Issue 1:
Application settings page hangs (shows white screen) in P6 (web) if:


Issue 2:
Unable to save changes on the Application Settings, auditing page if:


STEPS TO REPRODUCE:

  1. Create an 8.4 or earlier schema:
  2. Turn on auditing for at least one table by running:  exec auditing_enable('TASK',1);
  3. Disable auditing but keep the values where namespace like 'database.audit%' present by running:    exec auditing_disable(null);
  4. Upgrade to r16.2.5 by running 16.2.5.0 dbsetup
  5. Run the following SQL statement and note the setting_id value is null:    select rownum, setting_id, namespace, setting_name, setting_value from settings where namespace like 'database.audit%' and setting_id is null;
  6. Note one of the issues defined in the additional information section when this occurs.

EXPECTED OUTCOME:
When upgrading the database, there should be a check in the orpm_admuser_upgrade.sql script to find any rows in settings where namespace like 'database.audit%' and setting_id is null and update the row to set a setting_id value.

 

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