This discussion is archived
14 Replies Latest reply: May 15, 2013 7:26 AM by user629560 RSS

Indexer is not working.

mtbdgr Newbie
Currently Being Moderated
Hi!

I do check-in in to the WebCenter Content of new document, but its not indexed. I use OracleTextSearch and the metadata fields with enabled filtered search.
When i try to search some words from the document, it is can not find it.

In Repository Manager the document has the status NEW.

In the UCM server is this error:

intradoc.common.ServiceException: !csIndexerMetaOnlyFailed
at intradoc.indexer.IndexerBulkLoader.handleIndexerResults(IndexerBulkLo
ader.java:593)
at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.j
ava:384)
at intradoc.indexer.IndexerBulkLoader.doWork(IndexerBulkLoader.java:170)

at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)

In the System Audit Information - View Server Output, with enabled indexer, indexermonitor, indexerprocess and Full Verbose Tracing, i did not see any additional information about the error.

I tried to reboot the Oracle DB services.
Tried to clear /lock /rebuild /update directories.
But it does not take an effect.

What is this and how to fix it?
  • 1. Re: Indexer is not working.
    Srinath Menon Guru
    Currently Being Moderated
    Hi ,

    Go to <domain_home>/ucm/cs/search and there you will see following 3 sub-directories :

    /rebuild
    /lock
    /update

    Delete the contents / files in these 3 sub-folders and then restart UCM server .

    Run collection rebuild cycle and see if the issue still persists .

    Thanks,
    Srinath
  • 2. Re: Indexer is not working.
    mtbdgr Newbie
    Currently Being Moderated
    Thank you, Srinath.

    I saw this recomendations in other topics and i did it.
    But id does not fix my problems :(
  • 3. Re: Indexer is not working.
    frank abela - oracle Journeyer
    Currently Being Moderated
    After clearing the directories, did you do a full collection rebuild, and if so did you do a fast rebuild or the completely full rebuild?

    If so, what happens if you resubmit the content item?
  • 4. Re: Indexer is not working.
    mtbdgr Newbie
    Currently Being Moderated
    After clearing the directories i did the full collection rebuild, it was a full rebuild (i unchecked the fast rebuild check).
    Then i resubmit content item. I looked in the log file, there was the error:

    <Jan 23, 2013 6:35:01 AM MST> <Error> <oracle.ucm.idccs> <UCM-CS-060009> <Indexing aborted.>
    <Jan 23, 2013 6:35:01 AM MST> <Error> <oracle.ucm.idccs> <UCM-CS-000001> <general exception
    intradoc.common.ServiceException: !csIndexerMetaOnlyFailed
         at intradoc.indexer.IndexerBulkLoader.handleIndexerResults(IndexerBulkLoader.java:593)
         at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:384)
         at intradoc.indexer.IndexerBulkLoader.doWork(IndexerBulkLoader.java:170)
         at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
         at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
         at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
         at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
    >

    And, the full search text did not work, filtered search too.
  • 5. Re: Indexer is not working.
    frank abela - oracle Journeyer
    Currently Being Moderated
    I would check the following:

    Check your config.cfg and ensure the indexer engine is OracleTextSearch.
    Under Administration, check your 'Configuration For <instance>' page and verify that the indexer engine there is the same. Also check that the Index is either ots1 or ots2.

    If they're not the same, or the index isn't ots1 or ots2 then something is wrong with the installation. If they are the same or as expected:

    In Repository manager, switch off the Auto update cycle so it can't cause a conflict or generate extra logging which might be confusing.
    In System Audit INformation, switch on Is Verbose Tracing.
    In the Active Sections field, put in systemdatabase, indexer* only; no other entries should be in there.
    Run the full rebuild (not fast).
    Switch off verbose tracing under System Audit Information.
    Look at the logs (see KM note 1309159.1for 11g logs or KM note 445530.1 for 10g logs) to see whether anything stands out or if there may be an expanation for what kind of problem you're having. The systemdatabase traces will actually show you the EXACT queries being made to the database. You could try running them directly on the database and seeing what errors come back, if any.

    If none of this helps then I'm sorry but I suspect you may hae to open an SR with support. In that case, the above will not be wasted work. When opening it, you could supply the above logs, as well as the config.cfg and the Configuration page (expand all the links in the page and save it to a Word doc so the engineers can see what you're running).

    Hope this helps!
    Frank.

    Edited by: Frank Abela on Jan 23, 2013 2:14 PM
  • 6. Re: Indexer is not working.
    Srinath Menon Guru
    Currently Being Moderated
    Hi ,

    What is the version of ucm server where this issue is happening ? Copy the version tag from COnfiguration Information Page and update the post .

    Copy the details from <domain_home>/ucm/cs/search/activeindex.hda file and put here .

    Thanks,
    Srinath
  • 7. Re: Indexer is not working.
    mtbdgr Newbie
    Currently Being Moderated
    I found folow error in the log:

    !csDbUnableToExecuteSql,CREATE INDEX IdcText1_dDocName ON IdcText1(dDocName)!$ORA-01408: such column list already indexed
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     run: 0.73 ms. total 1.90 ms. [ORA-01408: such column list already indexed systemdatabase/6     01.23 08:07:05.285     index rebuild work     
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     !csDbUnableToExecuteSql,CREATE INDEX IdcText1_dDocName ON IdcText1(dDocName)!$ORA-01408: such column list already indexed
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     exception backtrace:intradoc.data.DataException: !csDbUnableToExecuteSql,CREATE INDEX IdcText1_dDocName ON IdcText1(dDocName)!$ORA-01408: such column list already indexed
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2546)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:849)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.jdbc.JdbcWorkspace.addIndex(JdbcWorkspace.java:2316)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.addIndexes(OracleTextCollectionHandler.java:1668)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.createCollection(OracleTextCollectionHandler.java:1249)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:265)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:101)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     Caused by: java.sql.SQLException: ORA-01408: such column list already indexed
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4680)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1842)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:530)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:843)
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     ... 9 more
    systemdatabase/6     01.23 08:07:05.285     index rebuild work     Closing active result set
    Version of ucm server :11gR1-11.1.1.6.0-idcprod1-111219T111403 (Build:7.3.3.183)

    There is the <domain_home>/ucm/cs/search/activeindex.hda file context:

    <?hda version="11gR1-11.1.1.6.0-idcprod1-111219T111403" jcharset="UTF8" encoding="utf-8"?>
    @Properties LocalData
    ActiveIndex=ots2
    UseImplicitZonedSecurityField=true
    blDateFormat=M/d{yy}{ h:mm[:ss]{ a}}!mAM,PM!tAmerica/Denver
    @end
    @ResultSet SearchCollections
    7
    sCollectionID
    sDescription
    sVerityLocale
    sProfile
    sLocation
    sFlag
    sUrlScript
    ucm11gdemo595236nccom16200
    !csSearchDefaultSearchCollection
    English-US
    local
    ots2
    enabled
    <$URL$>
    @end

    What about the error "uch column list already indexed" — how i can drop this state, or clear something? Or, maybe, someone else?

    Thank you.
  • 8. Re: Indexer is not working.
    jiri.machotka Guru
    Currently Being Moderated
    You can certainly drop the index manually - see http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8015.htm

    If it's not a sand box system, I'd probably create a backup of the database first.
  • 9. Re: Indexer is not working.
    mtbdgr Newbie
    Currently Being Moderated
    Thank you, i will try it.

    But, what could be causing of it, in common? I get the similar problem, what i described above, periodically.

    Edited by: mtbdgr on 24.01.2013 5:50
  • 10. Re: Indexer is not working.
    jiri.machotka Guru
    Currently Being Moderated
    But, what could be causing of it, in common?
    No idea. There might be other guys in the forum who might know the answer, though.

    There's been a web session by Oracle Support focused on the Indexer issues only. I think it's still available somewhere (but unfortunately, you might not have access to it). Besides, there are several quite useful notes in MetaLink (ditto). Tuning the Indexer seems to be a kind of alchemy. If you encounter problems on regular basis, it might be worth paying few days of Oracle Consulting or Advanced Support guys to take a look at your system.
  • 11. Re: Indexer is not working.
    mtbdgr Newbie
    Currently Being Moderated
    Ok, Jiri, thank you for your help!

    Thanks, all! :) You were helpfull.


    I tried to delete index from the error below, but took the error: index does not exist.

    If it will helpfull for someone, i have the instruction, how get this error (but no concrete idea, how fix it. Yes, i fix it now, but through the many reindexing, deleting, adding again metafield, and more reindexing. Without any explicit consistency):

    1. Add the new metadata field through the Configuration Manager (Administration - Configuration Manager - Information Fields - Add...).
    2. Enable for this field filter search through the Advanced Search Design (Administration - Configuration Manager - Advanced Search Design), choose Is a filter category options.
    3. Add a value to the new metadata field through the Conent Information page for a document.
    4. Rebuild.
    5. Check if the document in the filtered search, through the Search link.
    6. Open the Configuration Manager (Administration - Configuration Manager - Information Fields), and than delete your new metadata field.
    7. Rebuild index.
    8. Get the indexing error
  • 12. Re: Indexer is not working.
    jiri.machotka Guru
    Currently Being Moderated
    Would you mind doing it once again, but prior to that turn on server-wide tracing on systemdatabase (Full Verbose)?

    This could untangle what's going on in the database.

    Maybe it's not related, but I have another case where DDL commands from Config Manager do not work as they should: in Config Mgr, under Tables, create a new table with a name, delete it, try to create a table with the same name - you get an error (unless you drop the table explicitly in the database).
  • 13. Re: Indexer is not working.
    mtbdgr Newbie
    Currently Being Moderated
    I did it again, as you said.
    This is a short context of the log:

    ...
    systemdatabase/6     02.01 13:59:58.166     index update work     Prepared statement is reused.
    systemdatabase/6     02.01 13:59:58.166     index update work     Parameters: ([indexName:FT_IDCTEXT1],[memory:50M],[parallelDegree:1],[maxTime:2147483647])
    systemdatabase/7     02.01 13:59:58.167     index update work     (start) Executing PreparedStatement ({call CTX_DDL.SYNC_INDEX(?, ?, NULL, ?, ?)})
    systemdatabase/6     02.01 13:59:58.291     index update work     128 ms. Executing PreparedStatement ({call CTX_DDL.SYNC_INDEX(?, ?, NULL, ?, ?)})[Executed. 1 row(s) affected.]
    systemdatabase/7     02.01 13:59:58.292     index update work     (start) SELECT dDocName, IdcText1.RowID, Err_Text AS OracleTextErrDetails
    systemdatabase/7     02.01 13:59:58.292     index update work               FROM CTX_USER_INDEX_ERRORS LEFT JOIN IdcText1
    systemdatabase/7     02.01 13:59:58.292     index update work                         ON IdcText1.RowID = CTX_USER_INDEX_ERRORS.Err_TextKey
    systemdatabase/7     02.01 13:59:58.292     index update work               WHERE ERR_INDEX_NAME = 'FT_IDCTEXT1'
    systemdatabase/6     02.01 13:59:58.308     index update work     16 ms. SELECT dDocName, IdcText1.RowID, Err_Text AS OracleTextErrDetails
    systemdatabase/6     02.01 13:59:58.308     index update work               FROM CTX_USER_INDEX_ERRORS LEFT JOIN IdcText1
    systemdatabase/6     02.01 13:59:58.308     index update work                         ON IdcText1.RowID = CTX_USER_INDEX_ERRORS.Err_TextKey
    systemdatabase/6     02.01 13:59:58.308     index update work               WHERE ERR_INDEX_NAME = 'FT_IDCTEXT1'[Executed. Returned row(s): false]
    systemdatabase/6     02.01 13:59:58.312     index update work     Closing active result set
    ...
    systemdatabase/6     02.01 14:00:14.328     index rebuild work     Prepared statement is reused.
    systemdatabase/6     02.01 14:00:14.328     index rebuild work     Parameters: ([preferenceID:IdcLexer_ots2])
    systemdatabase/7     02.01 14:00:14.341     index rebuild work     (start) SELECT 1 FROM DUAL
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     1.07 ms. SELECT 1 FROM DUAL[Executed. Returned row(s): true]
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     !csDbUnableToExecuteCallableQuery,CdropTextPreference!$ORA-20000: Oracle Text error:
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     DRG-10700: preference does not exist: IdcLexer_ots2
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.DRUE"\, line 160
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.CTX_DDL"\, line 40
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at line 1
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     run: 1.27 ms. total 3.54 ms. [ORA-20000: Oracle Text error: systemdatabase/6     02.01 14:00:14.341     index rebuild work     DRG-10700: preference does not exist: IdcLexer_ots2 systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.DRUE", line 160 systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.CTX_DDL", line 40 systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at line 1 systemdatabase/6     02.01 14:00:14.341     index rebuild work     
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Closing active result set
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Closing statement in closing internals
    ...
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Prepared statement is reused.
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Parameters: ([preferenceID:IdcStore_ots2])
    systemdatabase/7     02.01 14:00:14.341     index rebuild work     (start) SELECT 1 FROM DUAL
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     1.14 ms. SELECT 1 FROM DUAL[Executed. Returned row(s): true]
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     !csDbUnableToExecuteCallableQuery,CdropTextPreference!$ORA-20000: Oracle Text error:
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     DRG-10700: preference does not exist: IdcStore_ots2
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.DRUE"\, line 160
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.CTX_DDL"\, line 40
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at line 1
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     run: 1.38 ms. total 3.80 ms. [ORA-20000: Oracle Text error: systemdatabase/6     02.01 14:00:14.341     index rebuild work     DRG-10700: preference does not exist: IdcStore_ots2 systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.DRUE", line 160 systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at "CTXSYS.CTX_DDL", line 40 systemdatabase/6     02.01 14:00:14.341     index rebuild work     ORA-06512: at line 1 systemdatabase/6     02.01 14:00:14.341     index rebuild work     
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Closing active result set
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Closing statement in closing internals
    systemdatabase/7     02.01 14:00:14.341     index rebuild work     (start) Executing CallableStatement ({call CTX_DDL.CREATE_PREFERENCE(?, ?)})
    systemdatabase/6     02.01 14:00:14.341     index rebuild work     Statement is
    ...
    systemdatabase/6     02.01 14:00:14.353     index rebuild work     Prepared statement is reused.
    systemdatabase/6     02.01 14:00:14.353     index rebuild work     Parameters: ([groupName:section_group_ots2])
    systemdatabase/7     02.01 14:00:14.356     index rebuild work     (start) SELECT 1 FROM DUAL
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     1.54 ms. SELECT 1 FROM DUAL[Executed. Returned row(s): true]
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     !csDbUnableToExecuteCallableQuery,CdropSectionGroup!$ORA-20000: Oracle Text error:
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     DRG-12203: section group section_group_ots2 does not exist
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     ORA-06512: at "CTXSYS.DRUE"\, line 160
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     ORA-06512: at "CTXSYS.CTX_DDL"\, line 100
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     ORA-06512: at line 1
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     run: 1.82 ms. total 5.03 ms. [ORA-20000: Oracle Text error: systemdatabase/6     02.01 14:00:14.358     index rebuild work     DRG-12203: section group section_group_ots2 does not exist systemdatabase/6     02.01 14:00:14.358     index rebuild work     ORA-06512: at "CTXSYS.DRUE", line 160 systemdatabase/6     02.01 14:00:14.358     index rebuild work     ORA-06512: at "CTXSYS.CTX_DDL", line 100 systemdatabase/6     02.01 14:00:14.358     index rebuild work     ORA-06512: at line 1 systemdatabase/6     02.01 14:00:14.358     index rebuild work     
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     Closing active result set
    systemdatabase/6     02.01 14:00:14.358     index rebuild work     Closing statement in closing internals
    systemdatabase/7     02.01 14:00:14.359     index rebuild work     (start) Executing CallableStatement ({call CTX_DDL.CREATE_SECTION_GROUP(?, ?)})
    systemdatabase/6     02.01 14:00:14.359     index rebuild work     Statement is
    ...
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     !csDbUnableToExecuteSql,CREATE INDEX IdcText2_dDocName ON IdcText2(dDocName)!$ORA-01408: such column list already indexed
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     exception backtrace:intradoc.data.DataException: !csDbUnableToExecuteSql,CREATE INDEX IdcText2_dDocName ON IdcText2(dDocName)!$ORA-01408: such column list already indexed
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2546)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:849)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.jdbc.JdbcWorkspace.addIndex(JdbcWorkspace.java:2316)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.addIndexes(OracleTextCollectionHandler.java:1668)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.createCollection(OracleTextCollectionHandler.java:1249)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:265)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:101)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     Caused by: java.sql.SQLException: ORA-01408: such column list already indexed
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:6518)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:6665)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2151)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2091)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:320)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:530)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:843)
    systemdatabase/6     02.01 14:00:14.786     index rebuild work     ... 9 more
    systemdatabase/6     02.01 14:00:14.788     index rebuild work     Closing active result set
    systemdatabase/6     02.01 14:00:14.788     index rebuild work     Closing statement in closing internals
    systemdatabase/7     02.01 14:00:14.788     index rebuild work     (start) CREATE INDEX IdcText2_dDocTitle ON IdcText2(dDocTitle)
    systemdatabase/6     02.01 14:00:14.798     index rebuild work     14 ms. CREATE INDEX IdcText2_dDocTitle ON IdcText2(dDocTitle)[Executed. 0 rows affected.]
    ...
    systemdatabase/7     02.01 14:00:16.024     index rebuild work     (start) SELECT dDocName, IdcText2.RowID, Err_Text AS OracleTextErrDetails
    systemdatabase/7     02.01 14:00:16.024     index rebuild work               FROM CTX_USER_INDEX_ERRORS LEFT JOIN IdcText2
    systemdatabase/7     02.01 14:00:16.024     index rebuild work                         ON IdcText2.RowID = CTX_USER_INDEX_ERRORS.Err_TextKey
    systemdatabase/7     02.01 14:00:16.024     index rebuild work               WHERE ERR_INDEX_NAME = 'FT_IDCTEXT2'
    systemdatabase/6     02.01 14:00:16.030     index rebuild work     7.76 ms. SELECT dDocName, IdcText2.RowID, Err_Text AS OracleTextErrDetails
    systemdatabase/6     02.01 14:00:16.030     index rebuild work               FROM CTX_USER_INDEX_ERRORS LEFT JOIN IdcText2
    systemdatabase/6     02.01 14:00:16.030     index rebuild work                         ON IdcText2.RowID = CTX_USER_INDEX_ERRORS.Err_TextKey
    systemdatabase/6     02.01 14:00:16.030     index rebuild work               WHERE ERR_INDEX_NAME = 'FT_IDCTEXT2'[Executed. Returned row(s): false]
    systemdatabase/6     02.01 14:00:16.035     index rebuild work     Closing active result set
    systemdatabase/6     02.01 14:00:16.035     index rebuild work     Closing statement in closing internals
    ...
    systemdatabase/6     02.01 14:00:58.184     index rebuild work     Connection with id of 'index rebuild work.2' is removed from active connections with key of 'index rebuild work'.
    systemdatabase/6     02.01 14:00:58.184     index rebuild work     Closing active result set
    systemdatabase/6     02.01 14:00:58.184     index rebuild work     release pool connection
    (internal)/3     02.01 14:00:58.185     index rebuild work     !csIndexerAbortedMsg intradoc.common.ServiceException: !csIndexerBuildIndexError
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.Indexer.buildIndex(Indexer.java:323)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
    (internal)/3     02.01 14:00:58.185     index rebuild work     Caused by: java.lang.NullPointerException
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.OracleTextUtils.encodeValue(OracleTextUtils.java:236)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.OracleTextUtils.constructDrillDownTagEx(OracleTextUtils.java:305)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.OracleTextUtils.constructDrillDownTag(OracleTextUtils.java:359)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:368)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:101)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
    (internal)/3     02.01 14:00:58.185     index rebuild work     at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
    (internal)/3     02.01 14:00:58.185     index rebuild work     ... 2 more
    systemdatabase/6     02.01 14:01:00.579     WebDAVUnlocker     begin tran - soft
  • 14. Re: Indexer is not working.
    user629560 Newbie
    Currently Being Moderated
    A bug has been opened for this issue. The error is benign, because index creation happens normally after this error appears in the WebCenter Content logs. The content server creates the table with dDocName as the primary key field, so it's already indexed. This error occurs when the content server starts creating the additional indexes, and tries to add the same index once again. The bug is to have a code fix that skips this second index creation on dDocName.


    Bug 16813844 - CREATING IDCTEXT2_DDOCNAME INDEX ON OTS TABLES THROWS ORA-01408

    Bug text:

    The IdcText1 and IdcText2 tables are created with a primary key field of
    dDocName, so an index on that column already exists. However, during
    collection rebuild when the table is being created, a second index called
    IdcText2_dDocName is attempted to be created. Since this would create two
    identical indexes, Oracle DB throws this error.

    !csDbUnableToExecuteSql,CREATE INDEX IdcText2_dDocName ON
    IdcText2(dDocName)!$ORA-01408: such column list already indexed

    The collection rebuild process should not attempt to create this index, since
    dDocName is already indexed as the primary key.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points