FILTER_NOTIFY.BEHAVIOR doesn't exist in our current system. I assumed it was coming from v7.5.
I'm saving your last suggestion for desperation time! Thanks, Susan :) On Tue, Mar 2, 2010 at 5:08 PM, Grooms, Frederick W < [email protected]> wrote: > ** > > Take a look and see what type of column FILTER_NOTIFY.BEHAVIOR currently > is. > > > > Also … I know you don’t want to hear this but, What happens if you upgrade > to 7.1.0 then to 7.5.0? > > > > Fred > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Susan Palmer > *Sent:* Tuesday, March 02, 2010 3:44 PM > *To:* [email protected] > *Subject:* ARS v7.0.1P2 upgrade to ARS v7.5 P4 Failure > > > > ** > > 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"
