Application Development Software

Hi,

I installed and configured Oracle Text Search with our UCM 11gR1-11.1.1.5.0 running Oracle Database 11.2.0.2.0 ---Oracle Database 11g Enterprise Edition Release --- - 64bit

I added the "SearchIndexerEngineName=OracleTextSearch" to the config.cfg along with "UseNativeFormatInIndex=true"

I'm trying to rebuild the complete index and I'm seeing the following error in the content server logs:

Unable to index documents. Unable to create the result set for query 'QdocumentUpdatable(SELECT dDocName FROM IdcText1 WHERE dDocName IN..........ORA-00942: table or view does not exist
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist. [ Details ]


As I'm running Oracle 11g database I did NOT add an external provider, I do NOThave this "IndexerDatabaseProviderName=SystemDatabase" in my config.cfg


6.1.2 Configuring OracleTextSearch for Content Server (http://docs.oracle.com/cd/E21043_01/doc.1111/e10792/c05_search001.htm#CHDJFGGI)
If the Oracle UCM system database used with OracleTextSearch is not Oracle Database 11g, then an external provider for OracleTextSearch must be configured.