UVMS update/upgrade could fail in case of incorrect data in database

Products

• CA Automic Dollar Universe

Issue/Introduction

Error Message :
Pop-up error message:

-------------------------------------------------------------------
Error during installation:
Error meesage = Unable to upgrade database to 6.3.01
-------------------------------------------------------------------

In the maintenance_debug.log :



BEGIN

 EXECUTE IMMEDIATE 'ALTER TABLE UNI_UV_NODE_TAGS DROP CONSTRAINT UNIQUE_NODE_TAGS';
 EXECUTE IMMEDIATE 'ALTER TABLE UNI_UV_NODE_TAGS ADD CONSTRAINT UNIQUE_NODE_TAGS UNIQUE (ID, NODE_ID, TAG_VALUE)';

EXCEPTION
 WHEN OTHERS THEN
 IF SQLCODE != -1430 THEN
 RAISE;
 END IF;
END;

Fatal Error due to JDBC error 955: ORA-00955: name is already used by an existing object
ORA-06512: at line 19

java.sql.SQLException: ORA-00955: name is already used by an existing object
ORA-06512: at line 19

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4693)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
    at com.orsyp.central.cli.databasecmd.AbstractDatabaseScript.execute(AbstractDatabaseScript.java:106)
    at com.orsyp.central.cli.databasecmd.AbstractDatabaseScript.matches(AbstractDatabaseScript.java:56)
    at com.orsyp.central.cli.databasecmd.AbstractDatabaseScript.matches(AbstractDatabaseScript.java:23)
    at com.orsyp.streams.ahocorasik.AhoCorasickStream$2.recursive(AhoCorasickStream.java:304)
    at com.orsyp.streams.ahocorasik.AhoCorasickStream$2.matches(AhoCorasickStream.java:290)
    at com.orsyp.streams.ahocorasik.AhoCorasickStream$2.append(AhoCorasickStream.java:251)
    at com.orsyp.central.cli.databasecmd.AbstractDatabaseScript.executeOffline(AbstractDatabaseScript.java:199)
    at com.orsyp.central.cli.databasecmd.AbstractDatabaseCommand.cmdMain(AbstractDatabaseCommand.java:79)
    at com.orsyp.central.cli.databasecmd.RunDatabaseScript.main(RunDatabaseScript.java:46)
java.sql.SQLException: ORA-00955: name is already used by an existing object
ORA-06512: at line 19

Patch level detected:Univiewer Management Server 6.1.00
Product Version: Dollar.Universe 6.1.0

Description :UVMS update/upgrade could fail in case of incorrect data in database.

Environment

OS: All

Cause

Cause type:
Defect
Root Cause: N/A

Resolution

Update to the fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.5.21

Additional Information

Workaround :
N/A