Univiewer Management Server 4.x with Oracle DB fails to start after upgrade

Products

• CA Automic Dollar Universe

Issue/Introduction

Error Message :
In the uvserver.log:
#################################
java.security.PrivilegedActionException: com.orsyp.InitializationException: Cannot initialize UVMS
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at com.orsyp.central.server.CentralServer.main(CentralServer.java:199)
Caused by: com.orsyp.InitializationException: Cannot initialize UVMS
at com.orsyp.central.server.CentralServer$1.run(CentralServer.java:204)
... 3 more
Caused by: com.orsyp.InitializationException: A problem occurred while initializing the server.
at com.orsyp.central.server.CentralServer.configAndInitServer(CentralServer.java:259)
at com.orsyp.central.server.CentralServer.access$000(CentralServer.java:74)
at com.orsyp.central.server.CentralServer$1.run(CentralServer.java:202)
... 3 more
Caused by: com.orsyp.InitializationException: Failed initializing server: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.orsyp.central.server.CentralServer.initServer(CentralServer.java:389)
at com.orsyp.central.server.CentralServer.configAndInitServer(CentralServer.java:257)
... 5 more

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 27 more
#################################

Patch level detected:Univiewer Management Server 4.0.00
The upgrade of the Univiewer Management Server (UVMS) from 4.0.00 to 4.0.07 corrupts the external Oracle database that is initially installed separately. Thus, the UVMS fails to start.

Product Version: Dollar.Universe 6.0.0

Environment

OS: All
OS Version: ALL OS

Cause

Cause type:
Configuration
Root Cause: Upgrade from UVMS v4.0.0x to UVMS v4.0.0y does not work if the DB is on an external Oracle DB. (where x < 3 and y >=4),

Upgrade from UVMS v4.0.0x to UVMS v4.0.0y where x < 3 and y >=4 does not work if DB is on an external Oracle DB.
Workaround :
- Stop UVMS
- Edit the values.xml file located under /data
- Replace DB_NAME by DB_INSTANCE
- Save the values.xml file
- Run the UVMS installer and choose the upgrade option.

Resolution

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

Fix Status: Released

Fix Version(s):
Univiewer Management Server v6.4.21 - Available

Additional Information

Workaround :
Perform the following procedure to attemp the upgrade again:

1. Stop UVMS
2. Backup and edit the "values.xml " file located under /data
3. Replace DB_NAME by DB_INSTANCE in the values.xml
4. Save the "values.xml" file
5. Run the UVMS installer and choose the upgrade option.