Hi,
Try the 7.5 patch 5 installer. It has resolved a few Oracle related
upgrade issues.
--
Jarl
2010/6/8 <Prashanth Bhagawat> <prashanth.bhaga...@accenture.com>:
> **
>
> Hi All,
>
>
>
> I need help on debugging the ARS 7.5 upgrade failure from ARS 7.1, before
> that let me give a brief description of the approach that’s being used for
> upgrade.
>
>
>
> Task: upgrade remedy ARS 6.3 to 7.5 and database from oracle 9i to 10g, with
> custom built applications.
>
>
>
> Approach: Install ARS 6.3 ,Oracle 9i P2 on Local Server, Import aradmin
> schema from production database dump to ARS 6.3 Oracle 9i local server,
>
> Upgrade database 9i to 10g,
>
> Upgrade ARS from 6.3 to 7.1,
>
> Upgrade ARS from 7.1 to 7.5,
>
> Finally again do a data import of aradmin schema from
> the local server database dump to the test server where there ARS 7.5 is
> already installed with Oracle 10g database.
>
>
>
>
>
> Current Status: Upgrade to ARS 7.1 was successful with only one issue of
> duplicate views for group and user form due to customizations done on these
> form, customized views were copied to the proper view and old views were
> deleted, after which 7.1 upgrade was a success with stable server and stable
> applications without any errors.
>
>
>
> Upgrade Failure: Upgrade of ARS 7.1 to ARS 7.5 Failed, all the pre-requisite
> before upgrade was followed with out missing any steps still the up
> gradation failed due to below mentioned errors. Has any one faced this
> problem, how to fix this up gradation failure, any hint or suggestion to fix
> this will be of great help!
>
>
>
> Error: error from arinstall.log
>
>
>
> {Description=[ARServerManageUpgradeDatabaseBusinessTask.description],Progress=[25],Detail=[ARServerManageUpgradeDatabaseBusinessTask.generateDatabaseSchema]}
>
> (Jun 08 2010 12:43:48.901 PM
> +0530),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask,
>
> LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the
> database schema],Detail=[[SQLERRORCODE]=17068 [SQLMESSAGE]=Invalid
> argument(s) in
>
>
>
> call[SQLSTATEMENT]=]}
>
> (Jun 08 2010 12:43:48.901 PM
> +0530),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask,
>
> THROWABLE EVENT {Description=[Failed to upgrade the database schema]},
>
> Throwable=[java.sql.SQLException: Invalid argument(s) in call
>
>
> oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:119)
>
> oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)
>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:221)
>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:293)
>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:574)
>
>
> oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:7054)
>
>
> com.bmc.install.utility.database.io.DatabaseModelJDBCReader.readIndexes(DatabaseModelJDBCReader.java:1002)
>
>
> com.bmc.install.utility.database.io.DatabaseModelJDBCReader.readSchemaTables(DatabaseModelJDBCReader.java:522)
>
>
> com.bmc.install.utility.database.io.DatabaseModelJDBCReader.readSchema(DatabaseModelJDBCReader.java:316)
>
>
>
> Environment information of local server:
>
> OS: Windows XP service Pack 2[ professional]
>
> Oracle 10g
>
> ARS 7.5 patch 3
>
>
>
> Regards,
>
>
>
> Prashanth
>
>
>
>
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the email by you is prohibited.
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
