Upgrade script (3.2 to 3.3) for Oracle issue

[GardenDwarf]

Hello,
I'm having issues with the Oracle scripts to update from 3.2 to 3.3.
I used sqlplus to connect to the database and the executed the sql script, but I think that it's not complete (missing statements?).
Any help would be much appreciated.

[jojo]

please post errors (the script works)

[GardenDwarf]

Well, if you say it's working then there's no reason it don't work for me. I'll investigate further and post the error message here.
In the meantime, when I go to the login screen, it's displayed "version 3.2.9" and I can't go further (buttons have no effect).

[jojo]

so it seems that you did not follow all steps of the migration or some errors did occr on the replacement of the files. Is this an rpm installation?

[GardenDwarf]

Yes, rpm. Here's the procedure steps, as described here:
1 - I stopped the postfix service (cron & apache commands does not exist in init.d).
2 - I backuped the database (or at least our dba did it) and I zipped the whole otrs folder content.
3 - "Make sure that you have backed up everything" --> Yes.
4 - "Setup new system" --> Not required.
5 - Install new rpm release --> rpm -Uvh otrs-3.3.3-01.noarch.rpm
6 - "Own themes" --> I don't have custom themes, so I skipped this step.
7 - "Set file permissions" --> for tarball install only, so I skipped this step.
8 - Check needed Perl modules --> All installed except the two optionals.
9 - Schema update --> otrs.CheckDB.pl report no error ("Connected"). The installation steps does not include a sample of the command, but I used sqlplus with the sql file provided for Oracle. I had errors with the SQL file (as the output wasn't redirected to a file, I lost the message) and DBUpdate-to-3.3.pl line 123 (_AddTemplateTypeColumn).

Do you think that I can restart a script execution, or do I have to restore the backup?

[GardenDwarf]

Ok, here are some issues I have with the upgrade.

When executing the sql Oracle script (DBUpdate-to-3.3.oracle.sql), I have two times the following:

Code: Select all

ALTER TABLE standard_template_attachment MODIFY standard_template_id NUMBER (12, 0) NOT NULL
                                                *
ERROR at line 1:
ORA-01442: column to be modified to NOT NULL is already NOT NULL

Then I ran DBUpdate-to-3.3.pl.

At step 9, here is what I have:

Code: Select all

Step 9 of 13: Checking if ACL tables already exist... Check if ACL table exists.
ACL tables not found, create it.
CREATE TABLE acl (
    id NUMBER (12, 0) NOT NULL,
    name VARCHAR2 (200) NOT NULL,
    comments VARCHAR2 (250) NULL,
    description VARCHAR2 (250) NULL,
    valid_id NUMBER (5, 0) NOT NULL,
    stop_after_match NUMBER (5, 0) NULL,
    config_match CLOB NULL,
    config_change CLOB NULL,
    create_time DATE NOT NULL,
    create_by NUMBER (12, 0) NOT NULL,
    change_time DATE NOT NULL,
    change_by NUMBER (12, 0) NOT NULL,
    CONSTRAINT acl_name UNIQUE (name)
)
ALTER TABLE acl ADD CONSTRAINT PK_acl PRIMARY KEY (id)
DROP SEQUENCE SE_acl
DBD::Oracle::db do failed: ORA-02289: sequence does not exist (DBD ERROR: error possibly near <*> indicator at char 14 in 'DROP SEQUENCE <*>SE_acl') [for Statement "DROP SEQUENCE SE_acl"] at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.10.1 OS: linux Time: Wed Jan 15 15:32:56 2014

 Message: ORA-02289: sequence does not exist (DBD ERROR: error possibly near <*> indicator at char 14 in 'DROP SEQUENCE <*>SE_acl'), SQL: 'DROP SEQUENCE SE_acl'

 Traceback (1964):
   Module: main::_AddACLTables (unknown version) Line: 385
   Module: ./otrs/scripts/DBUpdate-to-3.3.pl (unknown version) Line: 146

ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.10.1 OS: linux Time: Wed Jan 15 15:32:56 2014

 Message: Error during execution of 'DROP SEQUENCE SE_acl'!

 Traceback (1964):
   Module: main::_AddACLTables (unknown version) Line: 387
   Module: ./otrs/scripts/DBUpdate-to-3.3.pl (unknown version) Line: 146

Died at ./otrs/scripts/DBUpdate-to-3.3.pl line 146.

[EDIT] I restored the version 3.2 (Oracle and code), then restarted the migration. Now, what is displayed above is what I have at first execution of the upgrade.