Update:
There is an active defect SW00327170 that appears to be in QA to resolve
this issue. Of course we have no feedback on when but I do know it was not
fixed in patch 4 since we tried that patch and had the same results.
It's a shame that something fixed in 7.0.1P7 as noted by Rafael did not seem
to find its way through numerous versions after that.
I'll provide an update when received.
Thanks,
Susan
On Thu, Mar 4, 2010 at 7:08 AM, Rodriguez, Rafael J x23718 <
rafael.rodrig...@broadridge.com> wrote:
> **
> Susan we had the same issue when we upgraded from ARS 7.0.1P6 to 7.5 P2.
>
> The issue is with the control table not being upgraded properly. You MUST
> upgrade to 7.0.1P7 first, this will fix the control table and allow the 7.5
> upgrade. This was a bug that was fixed in patch7 of the 7.0.1 version.
>
> HTH,
>
> ------------------------------
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Susan Palmer
> *Sent:* Tuesday, March 02, 2010 4:44 PM
> *To:* arslist@ARSLIST.ORG
> *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*
> *spal...@shoppertrak.com *
> **
> *ARS v7.0.1P2*
> *Oracle 10g*
> *Sun Solaris*
>
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> This message and any attachments are intended only for the use of the
> addressee and
> may contain information that is privileged and confidential. If the reader of
> the
> message is not the intended recipient or an authorized representative of the
> intended recipient, you are hereby notified that any dissemination of this
> communication is strictly prohibited. If you have received this communication
> in
> error, please notify us immediately by e-mail and delete the message and any
> attachments from your system.
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
