My Oracle Support Banner

How to Solve "ERROR:ORA-00001: unique constraint (KCS_IM.PK_GSRSEARCHRESULT) violated" and "ERROR - Problem Fetching ContentText object with id:" (Doc ID 2210242.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.


Scenario 1.

While running the Global Find and Replace tool from Information Manager Console the next errors appear:


"Return to Global Find and Replace Find Page
Find Result Processing Error
An error occurred while processing the find results. Please contact your system administrator for assistance."

  error message screen.

and in Inquira-InfoManager-infomanager.log we observed:

1380299823 [[ACTIVE] ExecuteThread: '117' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO com.stonecobra.filter.LoginFilter - User

not authorized yet. Go to ping.
1453976539 [Thread-996] ERROR com.inquira.admin.content.ContentTextFindResultProcessor - Total Memory in JVM : 2624585728
Free Memory : 661538392

ORA-00001: unique constraint (KCS_IM.PK_GSRSEARCHRESULT) violated

ORA-00001: unique constraint (KCS_IM.PK_GSRSEARCHRESULT) violated

ORA-00001: unique constraint (KCS_IM.PK_GSRSEARCHRESULT) violated


java.sql.BatchUpdateException: ORA-00001: unique constraint (KCS_IM.PK_GSRSEARCHRESULT) violated

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(
at com.inquira.model.GSRSearchResult.insertContentFindHits(
at com.inquira.admin.content.ContentTextFindResultProcessor.insertContentFindHits(
at com.inquira.admin.content.ContentTextFindResultProcessor.performAction(
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$ Source)

 While re-indexing the next error occurred in IMWS logs: /app/Oracle/Knowledge/IM/InfoManager/logs/IMWEBSERVICES/system

[[STUCK] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'] 2016-11-17 06:00:10,164 ERROR - Problem Fetching ContentText object with id: 9266d9bd5a0340fb80722518650ca56a
er.extensions.eof.ERXDatabaseContextDelegate$ObjectNotAvailableException: No com.inquira.model.ContentData found with globalID: <ContentData:

[recordID: '9266d9bd5a0340fb80722518650ca56a'] >
at er.extensions.eof.ERXDatabaseContextDelegate.databaseContextFailedToFetchObject(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAc

Scenario 2.

When attempting to use the Global Find & Replace tool in InfoManager, we observed the above errors when deselecting a single specific Repository Channel from the list.




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

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