Hi, Try the 7.5 patch 5 installer. It has resolved a few Oracle related upgrade issues.
-- Jarl 2010/6/8 <Prashanth Bhagawat> <[email protected]>: > ** > > 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"
