It's been clarified for me that Filter_Notify is a system form and Behavior
a field .... duh .... wasn't thinking of it in those terms.

More info coming soon about an issue with that.

On Tue, Mar 2, 2010 at 5:28 PM, Susan Palmer <[email protected]> wrote:

> 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"

Reply via email to