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 DECEMBER 05, 2016

Applies to:

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

Symptoms

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

 

Changes

 

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