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

book

Article ID: 86828

calendar_today

Updated On:

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

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.

Environment

OS: All
OS Version: ALL OS

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.