Install or Upgrade of UVMS 6.2.01 with database Oracle fails

Document ID : KB000085412
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
The error that appears when installing or upgrading is:

####################################################

Fatal Error due to JDBC error 911: ORA-00911: invalid character

java.sql.SQLException: ORA-00911: invalid character

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
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-00911: invalid character

####################################################

Patch level detected:Univiewer Management Server 6.2.00
Product Version: Dollar.Universe 6.2.0

Description :The installation or upgrade of UVMS 6.2.01 fails
Environment:
OS: All
Related configuration item(s): database Oracle
Cause:
Cause type:
Defect
Root Cause: N/A
Resolution:
In order to workaround this issue in UVMS 6.2.01, we would need you to perform the following on the Oracle Instance used by UVMS:

1. stop the uvms
2. connect to the database as the same user as UVMS
3. launch the following statement:
INSERT INTO UNI_UV_PERMISSIONS (ID, ROLE_ID, PERMISSION_CLASS, PROTECTED_RESOURCE, ACTION_NAME, IS_POSITIVE)
VALUES (8, 1, 'MANAGEMENT_SERVER_DUX_ADMINISTRATION', '*', '*', 1)
/

4. then you can restart your uvms

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.2.0
Additional Information:
Workaround :
N/A