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
Environment
OS: All 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) /