HP BSM upgrade from 9.13 to 9.25 and getting DB connection error in upgrade wizard of DP Server.
Please refer the log entries below.
015-06-17 05:23:37,030 [pool-2-thread-2] (DatabaseMetadata.java:119) INFO - table not found: PREVSYNCDATA
2015-06-17 05:23:37,030 [pool-2-thread-2] (DatabaseMetadata.java:119) INFO - table not found: SERVER_KEY_STORE
2015-06-17 05:23:37,030 [pool-2-thread-2] (DatabaseMetadata.java:119) INFO - table not found: SYNCPACKAGES
2015-06-17 05:23:37,296 [pool-2-thread-2] (ConnectionProviderFactory.java:95) INFO - Initializing connection provider: com.hp.opr.db.api.BSMConnectionProvider
2015-06-17 05:23:37,608 [pool-2-thread-2] (TransactionFactoryFactory.java:59) INFO - Using default transaction strategy (direct JDBC transactions)
2015-06-17 05:23:37,608 [pool-2-thread-2] (TransactionManagerLookupFactory.java:80) INFO - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2015-06-17 05:23:37,608 [pool-2-thread-2] (ASTQueryTranslatorFactory.java:47) INFO - Using ASTQueryTranslatorFactory
2015-06-17 05:23:37,623 [pool-2-thread-2] (SessionFactoryImpl.java:193) INFO - building session factory
2015-06-17 05:23:37,764 [pool-2-thread-2] (SessionFactoryObjectFactory.java:105) INFO - Not binding factory to JNDI, no JNDI name configured
2015-06-17 05:23:38,591 [pool-2-thread-2] (StoreSessionImpl.java:523) ERROR - Error while executing SQL statement: "create table CERTIFICATE_REQUESTS (ID varchar2(255 char) not null, VERSION number(10,0) not null, CN varchar2(255 char) not null, CONTEXT varchar2(255 char), DPS varchar2(255 char) not null, INSTALLATION number(10,0), IP_ADDRESS varchar2(255 char) not null, NODE_NAME varchar2(255 char), PEER_ADDRESS varchar2(255 char), TIME_RECEIVED timestamp, EVENT_TYPE number(10,0), INFO varchar2(255 char), PLATFORM_CPU_TYPE number(10,0), PLATFORM_MAJOR number(10,0), PLATFORM_MINOR number(10,0), PLATFORM_SUB_MINOR number(10,0), PLATFORM_OS_TYPE number(10,0), CHANGED_BY number(10,0), primary key (ID))": [mercury][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object
2015-06-17 05:23:38,591 [pool-2-thread-2] (JDBCExceptionReporter.java:100) WARN - SQL Error: 955, SQLState: 42S01
2015-06-17 05:23:38,591 [pool-2-thread-2] (JDBCExceptionReporter.java:101) ERROR - [mercury][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object
2015-06-17 05:23:38,669 [pool-2-thread-2] (CreateMigrationSQL.java:359) ERROR - Schema upgrade step failed: error executing work -- [mercury][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object
2015-06-17 05:23:38,669 [pool-2-thread-2] (JavaTask.java:87) INFO - Finished java task: com.hp.opr.migration.tasks.CreateMigrationSQL. Execution result: failure
2015-06-17 05:23:38,669 [pool-2-thread-2] (NavigationRules.java:66) INFO - navigationValue = failure
2015-06-17 05:23:38,669 [pool-2-thread-2] (Step.java:119) INFO - *** Step opr-oracle_create_migration_sql was executed. Execution result : failure. Next step is: opr-show_error
