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.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
