My Oracle Support Banner

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

Last updated on MAY 31, 2018

Applies to:

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

Symptoms

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

ERROR:
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

STACK_TRACE:

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

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at com.inquira.model.GSRSearchResult.insertContentFindHits(GSRSearchResult.java:396)
at com.inquira.admin.content.ContentTextFindResultProcessor.insertContentFindHits(ContentTextFindResultProcessor.java:111)
at com.inquira.admin.content.ContentTextFindResultProcessor.performAction(ContentTextFindResultProcessor.java:85)
at com.inquira.admin.application.CVProgressThread.run(CVProgressThread.java:98)
at com.inquira.foundation.utilities.RunnableProxy.run(RunnableProxy.java:167)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)

 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

com.inquira.services.search.LuceneIndexer - 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(ERXDatabaseContextDelegate.java:295)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
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.

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.