Knowledge Document: SQL Text - Oracle Error when upgrading

0 Likes

Environment

Content Manager 10.1

Situation

When upgrading from Content Manager 10.0 to Content Manager 10.1 if you have already converted to SQL Text you receive the the following Oracle error at step 3 of the Schema Upgrade.

ORA - 29855 and ORA - 20000

Resolution


Run the following SQL in the Content Manager 10.0.x database before performing the Schema Upgrade 

DECLARE isExist NUMBER( 1 );
BEGIN
    isExist := 0;
    SELECT CASE WHEN EXISTS ( SELECT 1 FROM CTXSYS.CTX_USER_PREFERENCES WHERE UPPER(pre_name) = 'TSSTORE')
 THEN 1
 ELSE 0
         END INTO isExist
    FROM DUAL;
    IF isExist = 0
 THEN
                    CTX_DDL.CREATE_PREFERENCE ('tsstore', 'BASIC_STORAGE');
END IF;
    CTX_DDL.SET_ATTRIBUTE('tsstore','STAGE_ITAB', 'TRUE');
   -- CTX_DDL.SET_ATTRIBUTE('tsstore','STAGE_ITAB_AUTO_OPT', 'TRUE');
END;

Access document on support portal here


Caroline Oest

Micro Focus Customer Experience Marketing

If you find this post useful, give it a ‘Like’ or use ‘Verify Answer’

Labels:

Knowledge Docs
Comment List
Anonymous
Related Discussions
Recommended