Install or Upgrade of UVMS 6.2.01 with database Oracle fails
Article ID: 85412
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
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
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
Cause
Cause type:
Defect
Root Cause: N/A
Defect
Root Cause: N/A
Environment
OS: All
Related configuration item(s): database Oracle
Related configuration item(s): database Oracle
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
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
N/A
Feedback
Yes
No
Powered by
