User 8688ffe688
10-06-2013 20:10:52
Encountered an error in upgrading from 5.12.3 to 6.0.0. Any idea what I can manually run to complete the upgrade? See error message:
You have entered the following parameters:
==========================================
The path to the home directory of the old JChem version: /usr/local/chemaxon/jchem-5.12.3
The license files in /usr/local/chemaxon/jchem-5.12.3/cartridge/licenses will now be moved to /usr/local/chemaxon/jchem-6.0.0/cartridge/licenses.: y
Database descriptor type: sid
Name of the Oracle host: localhost
Oracle listener port: 1521
Name of the Oracle database (sid): foo
DBA login: SYSTEM
Name of the cartridge owner: jchem
The host name of the JChem Server: localhost
The port at which the JChem Server accepts connections: 1099
maximum memory allocated to the JChem Server process: 2048m
Do you want a role for basic JChem Cartridge user privileges to be created? (This role will be granted to jchem WITH ADMIN OPTION. DataVault users, please, answer with "n"): y
The role for basic JChem Cartridge user privileges: y
Staging schema for the version: JCC_UPGR_STAGE
Rebuild jc_idxtype indexes: all
Proceed with the Upgrade? (y, n) [n]: y
INFO: Setting up staging schema...
INFO: Populating the staging schema with the objects of the new JChem Cartridge version...
INFO: Loading jar file /usr/local/chemaxon/jchem-6.0.0/cartridge/jcart.jar into JCC_UPGR_STAGE's schema...
INFO: Building schema model for JCC_UPGR_STAGE...
INFO: Verifying schema objects...
INFO: Schema objects verified.
INFO: Building schema model for JCHEM...
INFO: Preparing upgrade of JChem Cartridge in JCHEM based on JCC_UPGR_STAGE...
INFO: Skipping dropping sequence JCHEMIDX_SEQ
INFO: Upgrade plan has been stored in /usr/local/chemaxon/jchem-6.0.0/cartridge/upgrade-plan.txt
INFO: Verifying schema objects...
INFO: Schema objects verified.
INFO: Loading jar file /usr/local/chemaxon/jchem-6.0.0/cartridge/jcart.jar into jchem's schema...
INFO: Dropping staging schema...
INFO: Using chemaxon.jchem.cartridge.util.cpool.Oracle10gDataSource
INFO: Using classpath: /usr/local/chemaxon/jchem-6.0.0/lib/jchem.jar
INFO: Connecting to localhost:1099
AdminImpl: shutdown called...
INFO: shutdown called
Exiting with exit code 0...
INFO: Server process stop-ed.
SEVERE: error
java.sql.SQLSyntaxErrorException: ORA-01917: user or role 'Y' does not exist
ORA-06512: at "JCHEM.PRIVMAN_PKG", line 40
ORA-06512: at "JCHEM.PRIVMAN_PKG", line 77
ORA-06512: at "JCHEM.PRIVMAN_PKG", line 46
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
at chemaxon.jchem.cartridge.install.schema.Schema.executeSql(Schema.java:653)
at chemaxon.jchem.cartridge.install.schema.Schema.executeSqls(Schema.java:622)
at chemaxon.jchem.cartridge.install.Installer.grantBasicJccPrivilegesByJCartOwner(Installer.java:425)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:322)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:71)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.main(UpgradeCmdLine.java:783)
+ set +x