Installing search package after initial install

Squiz Matrix Support
1

Hi there,


I installed 3.12.0 without the search package a few weeks ago, and now I'm attempting to install the seach package manually, by:


  • uploading the search package directory into the package location in the mysource_matrix directory
  • running step02, compile locale, step03, compile locale





    On step02, it appears that the script is trying to create an index on a LOB column for the search package. Below is the outputted error message.


[quote]*** Package: search

| MySource Error                                                                                                                                                                                                                                   



| File : [SYSTEM_ROOT]/core/include/assertions.inc                                                                                                                                                                                                  |

| Line : 508                                                                                                                                                                                                                                        |



| [ASSERT EXCEPTION] DB Error: unknown errorCREATE INDEX sq_sch_idx_value ON sq_sch_idx (value) [nativecode=ORA-02327: cannot create index on expression with datatype LOB] (LINE 213 IN [SYSTEM_ROOT]/core/lib/db_install/db_install.inc) [SYS0270] |[/quote]





Does this appear to be correct??



Aleks

2

Do you have the Oracle Text package installed? The new Oracle Search package uses Oracle Text to create a full-text index.


Though as you have the commercial modules, you should probably log this with support so that we can check that you have the correct search package for your installed Matrix system.

3

Yup, Oracle Text is installed.

4

I would contact support – it sounds like you might have mismatched versions.

5

ok thanks Avi… email sent to support

6

problem resolved.