Unable To Add The Activities In Progress Reporter (Doc ID 2062888.1)

Last updated on OCTOBER 11, 2015

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 to 8.2.2.0 [Release 8.2]
Information in this document applies to any platform.

Symptoms


In Oracle Primavera, adding new activity in Progress Reporter fails and the following error is observed in webserver console:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'pk_rsrchour'.
Cannot insert duplicate key in object 'dbo.RSRCHOUR'. The duplicate key value is (2242106).

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