cannot enable Text Search on project in ALM

[nameless_girl]

Hello all.

I am trying to enable the Text Search feature in ALM v11.52.  I have the Text Search enabled on the DB in SiteAdmin.  Also, the CTXAPP role  has the necessary privileges.  However, I keep getting OLE error 800419A4 when clicking the "enable/rebuild text search" button.

I have a Case open with Support for a few weeks now and have tried various things with no resolution.

Has anybody else been able to fix this issue?  Thanks.

[Trudy Claspill]

What are you using on the backend for database support?

You may need to enable text search on the database software.

[nameless_girl]

We have already enabled search on the Database.  We are using Oracle 11.0.3 for the database back-end.

[Will Herrmann]

What patch level are you on for ALM 11.52?

We are on 11.52 patch 4 with Oracle 11.2.0.4.4 and do not have this issue.

[ameyjo]

When the error shows in enable/rebuild,  please look at the sa logs,  filter them by errors and look for an error in the time frame the error was shown. 

And paste it here. 

Cordially

Ameyjo 

[JonathanGraham]

I am in the same situation.

Here is a copy of my error log...

[Mercury][Oracle JDBC Driver][Oracle]ORA-06564: object CTX_DDL.CREATE_PREFERENCE does not exist ORA-06512: at "SYS.DBMS_UTILITY", line 156 ORA-06512: at line 1 Failed SQL: /* ~~QC */ {CALL CTX_DDL.CREATE_PREFERENCE(/*P*/'QCCOLUMNS',/*P*/'MULTI_COLUMN_DATASTORE')};

Stack Trace: java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-06564: object CTX_DDL.CREATE_PREFERENCE does not exist ORA-06512: at "SYS.DBMS_UTILITY", line 156 ORA-06512: at line 1 Failed SQL: /* ~~QC */ {CALL CTX_DDL.CREATE_PREFERENCE(/*P*/'QCCOLUMNS',/*P*/'MULTI_COLUMN_DATASTORE')}

[Will Herrmann]

Check with your DBA(s) that the account you are using to talk to the database has the rights it needs to create or change tables in the database.

You can also run the verify job to check for schema/database corruption.

[ameyjo]

Please have your dba to look at the database permissions below: 

• SELECT ON SYS.DBA_USERS (2) (ALM db admin user)Required to verify the existence of specific database project users. For example, you might want to (ALM db admin user)verify the existence of an Oracle CTXSYS user before creating a new ALM project.
• SELECT ON SYS.DBA_REGISTRY (2) (ALM db admin user)Required to verify that the text search component is installed on the database server.
• SELECT ON SYS.DBA_ROLES (2) (ALM db admin user)Required to verify that the text search role (CTXAPP) is installed on the database server.
• GRANT CTXAPP to ) ctxapp role to Project schema user 

For knowing your ALM db admin user: go to Site Administration/DBservers

Project Schema User: Site Administration /Site Projects -> Project details tab

 

Cordially

Ameyjo