My Oracle Support Banner

UPK: ORA-00001: Unique Constraint Violated During Check In of Content into UPK 12.1.0 (Doc ID 1939817.1)

Last updated on APRIL 13, 2020

Applies to:

User Productivity Kit - Version 12.1.0.0 to 12.1.0.0 [Release 12.1]
Information in this document applies to any platform.

Goal


When checking content into UPK 12.1.0 Library, receive the following error: ORA-00001: unique constraint  violated.
The Windows Event Log below displays the error.  Is this a known issue?

 

Oracle.ManagedDataAccess.Client.OracleException: ORA-00001: unique constraint (UPK.PK_SEARCH_MATCH) violated
ORA-06512: at "UPK.ADD_SEARCH_MATCH", line 9
ORA-06512: at line 1
  at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)    at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int32 lobPrefetchSize, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Boolean isFromEF)    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.AddSearchMatch(DbConnection connection, DbTransaction transaction, Int32 termId, Int32 searchableAssetId) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2441    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.UpdateContextSearchDataByType(DbConnection connection, DbTransaction transaction, Int32 assetId, String application, Ecid ecid, Int32 type) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2368    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.AddContextSearchData(DbConnection connection, DbTransaction transaction, RepositoryDocumentStorage documentStorage, Guid targetDocumentId, Guid sourceDocumentId) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2344    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.UpdateContextSearchData(DbConnection connection, DbTransaction transaction, RepositoryDocumentStorage documentStorage) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2281    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.UpdateContextSearchData(DbConnection connection, DbTransaction transaction, DocumentId documentId) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2263    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.CheckInDocumentIfPartsExist(DocumentChange documentChange, CheckInOperationState state, List`1 partInfosParameter) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2246    at Gkn.OnDemand.Repository.Content.LocalContentStrategy.CheckInDocuments(Chunk chunk, CheckInOperationState& state) in c:\BuildRoot\Engineering\trunk\Core_DotNet\Repository\LocalContentStrategy.cs:line 2612



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!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.