My Oracle Support Banner

Error: "Exception Has Occurred!" When Attempting to Save a Location within P6 Web. (Doc ID 1943379.1)

Last updated on MAY 31, 2024

Applies to:

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

Symptoms

When attempting to save a new location in the P6 Web application the following error occurs:

Exception has occurred!

 

Either of the following errors can be found in the <P6 EPPM home>\p6\WebAccessLogs\P6WebAccess.html log file:

ERROR com.primavera.bo.base.LDBEngineImpl - Failed updating values with query: insert into location ( location.address_line1, location.address_line2, location.city_name, location.country_code, location.country_name, location.latitude, location.location_name, location.location_type, location.longitude, location.postal_code, location.state_name, location.location_id ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) parms: Test, , Test, USA, United States, -31.0, Username, LT_Point, 31.0, Test, Test, 202 com.primavera.PhoenixException: DBEngine.executeUpdate: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

ERROR com.primavera.bo.base.LDBEngineImpl ?:? Failed updating values with query: insert into location ( location.address_line1, location.address_line2, location.city_name, location.country_code, location.country_name, location.latitude, location.location_name, location.location_type, location.longitude, location.postal_code, location.state_code, location.state_name, location.location_id ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) parms: , , , , , 1.0, test, LT_Point, 1.0, , , , 353
  Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'pk_location'. Cannot insert duplicate key in object 'dbo.LOCATION'. The duplicate key value is (353).

 

When attempting to upgrade a database using the dbsetup.bat tool in the P6 installation media, the following error occurs:

ORA-04045: errors during recompilation/revalidation of ADMUSER.LOCATION
ORA-29861: domain index is marked LOADED/FAILED/UNUSABLE
SQL Query:
update task est_wt=1 where est_wt is null

 

The issue can be reproduced at will with the following steps:

  1. Login to P6 Web.
  2. Navigate to Administer > Enterprise Data > Global > Locations.
  3. Click the Add (+) icon to add new location.
  4. Enter the location details and click Add.
  5. Observe the reported error within the application.

Changes

 

Cause

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.