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