Error in upgrade from 5.12.3 to 6.0.0

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

ChemAxon aa7c50abf8

11-06-2013 11:43:26

If a role exists which is used to grant privileges to JChem Cartridge (JCC) users, please, answer "y" to the first question below and specify the name of the role to second question:


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: <role-name>

If no such role exists (faulty branch of the JCC upgrader program, to be fixed, sorry for the inconvenience), you have two options:


1. Create a role temporarily and feed it to the second question as described above.


2. Rebuild all JChem indexes (ALTER INDEX ... REBUILD) and recreate (public) synonyms for the JCHEM schema objects eventually using the synonym helper functions of the PRIVMAN_PKG package.


Not part of the expected behaviour of the JCC upgrader program is the "upgrade" of the privileges for those JCC users who have them directly granted (as opposed to being granted through the role at issue). You have to perform this step manually with the help of the configuration utility in the jchem/cartridge directory (of the new JCC version):


.\config-util.bat list-sqls-for-jcc-user-privs

.