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

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : P6 Web Application version 8.3 and higher.

When attempting to save a new location within P6 Web, the following error occurs:

P6 WEB ERROR:
------------------
"Exception has occurred!"

Possible errors that can appear within P6WebAccess.html:

Error #1:

[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)' 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 #2:

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).

 

STEPS
--------

The issue can be reproduced at will with the following steps:
1.  Login to P6 Web.
2.  Choose "Administer" / "Enterprise Data".
3.  Within "Enterprise Data" / "Global",  select "Locations".
4.  Click the "+" sign to add new location.
5.  Enter the location details and click "Add"
6.  Observe error within the application interface:  "Exception has occured!"
7.  Observe additional error within P6WebAccess.html.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are unable to save a new location within P6 Web.

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