Hi, Upgrading AR System on Oracle I did these modification to the database before the upgrade:
----------------------------------------- CREATE TABLE FIELD_ENUM_BACKUP AS SELECT * FROM FIELD_ENUM; delete from FIELD_ENUM; ALTER TABLE FIELD_ENUM MODIFY (enumStyle number(15)); INSERT INTO FIELD_ENUM SELECT * FROM FIELD_ENUM_BACKUP; CREATE TABLE SCHEMA_ARCHIVE_BACKUP AS SELECT * FROM SCHEMA_ARCHIVE; delete from SCHEMA_ARCHIVE; ALTER TABLE SCHEMA_ARCHIVE MODIFY (archiveFromForm number(15)); INSERT INTO SCHEMA_ARCHIVE SELECT * FROM SCHEMA_ARCHIVE_BACKUP; UPDATE filter_notify SET behavior = NULL, permission = NULL ; ALTER TABLE filter_notify MODIFY (behavior number(15), permission number(15)); UPDATE filter_notify SET behavior = 0, permission = 0; ----------------------------------------- After the upgrade, then delete these tables: SCHEMA_ARCHIVE_BACKUP; TABLE FIELD_ENUM_BACKUP; -- Jarl 2010/3/2 Susan Palmer <[email protected]>: > ** > > Hi Everyone, > > > This was supposed to be pretty straightforward, we're only upgrading (not > overwriting) the ARS engine and email engine, nothing else. We've started > on our test server. > > We've had about 5 failed installs as of today. It indicates that the > database is not the correct version. We confirm when we start that we're at > dbversion '22' and when the install fails we see the following: > > >> r...@svs035 (/apps/oracle/product/10.2.0/db_1)$ > >> $ORACLE_HOME/bin/sqlplus > >> arad...@st_remt1 > >> SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 2 13:00:24 2010 > >> Copyright (c) 1982, 2005, Oracle. All Rights Reserved. > >> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit > >> Production With the Partitioning, OLAP and Data Mining options > >> SQL> select dbversion from control; > >> DBVERSION > >> ---------- > >> 23 > > We restore the database and we're back at dbversion 22. The install log > indicates the following: > > > (Mar 02 2010 12:23:45.272 PM > -0600),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask, > > LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the > database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL > statement [ALTER TABLE FILTER_NOTIFY MODIFY ( BEHAVIOR NUMBER(15) )] Due to > [ORA-01440: column to be modified must be empty to decrease precision or > scale > > ][SQLSTATEMENT]=]} > > (Mar 02 2010 12:23:45.273 PM > -0600),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask, > > THROWABLE EVENT {Description=[Failed to upgrade the database schema]}, > > Throwable=[java.sql.SQLException: Failed to run SQL statement [ALTER TABLE > FILTER_NOTIFY MODIFY ( BEHAVIOR NUMBER(15) )] Due to [ORA-01440: column to > be modified must be empty to decrease precision or scale > > ] > > > com.bmc.install.utility.database.io.DatabaseModelJDBCWriter.writeStatements(DatabaseModelJDBCWriter.java:245) > > > com.bmc.install.utility.database.io.DatabaseModelJDBCWriter.writeStatements(DatabaseModelJDBCWriter.java:130) > > > com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerManageUpgradeDatabaseBusinessTask.processDBVendorTablesXMLFile(ARServerManageUpgradeDatabaseBusinessTask.java:399) > > > com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerManageUpgradeDatabaseBusinessTask.execute(ARServerManageUpgradeDatabaseBusinessTask.java:98) > > > com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask.execute(ARServerOracleManageUpgradeDatabaseTask.java:85) > > com.bmc.install.task.InstallationTask.run(InstallationTask.java:79) > > java.lang.Thread.run(Unknown Source)] > > (Mar 02 2010 12:23:45.276 PM > -0600),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, > > LOG EVENT {Description=[SET PROPERTY > FAILED_INSTALL_FEATURES],Detail=[featureARServer]} > > (Mar 02 2010 12:23:45.282 PM - > > We even tried an overwrite upgrade and cannot get past this error. It's > like the install script already writes something to the database and then > chokes and doesn't rollback leaving you high and dry. > > If you've seen something like this I'd love to hear how you resolved it. > We're working with support but obviously we don't have a solution yet. We > cannot move onto the dev and prod servers until we know we can do clean > upgrades. > > Thanks for your help, > > Susan Palmer > ShopperTrak > 200 W Monroe 11th Floor > Chicago, IL 60606 > 312-529-5325 > 312-502-7687 > [email protected] > > ARS v7.0.1P2 > Oracle 10g > Sun Solaris > > > > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
