Cartridge upgrade error

User d8da4712c1

26-06-2013 08:33:34

Hello guys,


I did exactly follow the upgrade tutorial here https://www.chemaxon.com/jchem/doc/admin/cartridge.html#input_for_upgrade />But I'm getting this error message:


INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
SEVERE: error
java.lang.RuntimeException: Timed out in waiting for JChem Cartridge server to come up: 60000 milliseconds
        at chemaxon.jchem.cartridge.install.InstallUtil.waitForRmiServerToStart(InstallUtil.java:185)
        at chemaxon.jchem.cartridge.install.ServerCtrl.start(ServerCtrl.java:117)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.checkStartNewJChemServer(InstallCmdLine.java:429)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.checkStartNewJChemServer(InstallCmdLine.java:403)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.getParams(UpgradeCmdLine.java:433)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:67)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.main(UpgradeCmdLine.java:783)
+ set +x




ChemAxon aa7c50abf8

26-06-2013 08:56:15

Hello,


I guess there is much more log than this. Please, could you copy-past some more, possibly from the beginning?


From which version to which version?


Peter

User d8da4712c1

26-06-2013 09:30:46

it keeps checking the Jchem server:


INFO: Checking JChem Server at localhost:1099...


INFO: RUNNING_JCSRV_NONE                        


INFO: Checking JChem Server at localhost:1099...


INFO: RUNNING_JCSRV_NONE                        


INFO: Checking JChem Server at localhost:1099...



From 5.12 to the last version, thanks.

ChemAxon aa7c50abf8

26-06-2013 09:32:40

Please, could you upload the entire output?

User d8da4712c1

26-06-2013 09:37:31










pkovacs wrote:

Please, could you upload the entire output?



can't get it now cause I'm doing some work on my server "I'll send it later" but those are all the error that server shows it keeps repeating those two lines:


INFO: Checking JChem Server at localhost:1099...


INFO: RUNNING_JCSRV_NONE  


then shows the error:


INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
SEVERE: error
java.lang.RuntimeException: Timed out in waiting for JChem Cartridge server to come up: 60000 milliseconds
        at chemaxon.jchem.cartridge.install.InstallUtil.waitForRmiServerToStart(InstallUtil.java:185)
        at chemaxon.jchem.cartridge.install.ServerCtrl.start(ServerCtrl.java:117)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.checkStartNewJChemServer(InstallCmdLine.java:429)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.checkStartNewJChemServer(InstallCmdLine.java:403)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.getParams(UpgradeCmdLine.java:433)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:67)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.main(UpgradeCmdLine.java:783)
+ set +x

ChemAxon aa7c50abf8

26-06-2013 09:52:24

This error message along with preceeding logs say that the JCC server hasn't been started where expected (localhost:1099).


One work-around you can do is to pre-start the JCC server (in a different terminal window) before starting the installation program (from within the same directory in another terminal window). Then we should know for sure whether the server has been successfully started or not.


Peter

User d8da4712c1

26-06-2013 10:25:50

I restarted the server, now it works but after that I got another error message:


[root@CN5 cartridge]# ./upgrade.sh
+ /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.19.x86_64/jre/bin/java -classpath ../lib/jchem.jar -Djava.util.logging.config.file=conf/logging.properties chemaxon.jchem.cartridge.install.UpgradeCmdLine

The path to the home directory of the old JChem version: /home/jchem

====> The directory /home/jchem/cartridge/licenses, where the old JChem Cartridge version expected the licenses files, doesn't exist.

Database descriptor type (sid, service_name, url) [sid]:

Name of the Oracle host [localhost]:

Oracle listener port [1521]:

Name of the Oracle database (sid) [CNBD]:

DBA login [sys as sysdba]:
DBA password:

Name of the cartridge owner [kiet]:
Password of the cartridge owner:

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 [700m]: 2000m
INFO: Checking JChem Server at localhost:1099...

====> Trying to start JChem Server...
INFO: Using classpath: /home/jchem6/lib/jchem.jar
INFO: Server process start-ed.
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Cache id set to JCC1
INFO: Directory licenses does not exist. Leaving it to LicenseHandler to check the default location for licenses.
INFO: Maximum memory: 1916 MB
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Checking JChem Server at localhost:1099...
INFO: RUNNING_JCSRV_NONE
INFO: Listening at 1099
INFO: Checking JChem Server at localhost:1099...

Do you want a role for basic JChem Cartridge user privileges to be created? (This role will be granted to kiet WITH ADMIN OPTION. DataVault users, please, answer with "n") (y, n) [y]: y

The role for basic JChem Cartridge user privileges [JCC_BASIC_ROLE]:

====> Role JCC_BASIC_ROLE doesn't exist, it will be created

Staging schema for the version [JCC_UPGR_STAGE]:
The password for the staging schema:

Rebuild jc_idxtype indexes (none, ask, all) [none]: all


You have entered the following parameters:
==========================================

The path to the home directory of the old JChem version: /home/jchem
Database descriptor type: sid
Name of the Oracle host: localhost
Oracle listener port: 1521
Name of the Oracle database (sid): CNBD
DBA login: sys as sysdba
Name of the cartridge owner: kiet
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: 2000m
Do you want a role for basic JChem Cartridge user privileges to be created? (This role will be granted to kiet WITH ADMIN OPTION. DataVault users, please, answer with "n"): y
The role for basic JChem Cartridge user privileges: JCC_BASIC_ROLE
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 /home/jchem6/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 KIET...
INFO: Preparing upgrade of JChem Cartridge in KIET based on JCC_UPGR_STAGE...
INFO: Skipping dropping sequence JCHEMIDX_SEQ
INFO: Skipping dropping sequence SEQ_SLOT_LABO_ID_LOTLABO_ID
INFO: Skipping dropping sequence SEQ_SUBS_ID
INFO: Skipping dropping sequence SEQ_SUBS_NATIONAL_ID
INFO: Skipping dropping sequence SEQ_SUB_LOT
INFO: Skipping dropping sequence SEQ_SUB_NATIONAL_ID
INFO: Skipping dropping sequence SEQ_SUB_STRUCTURE
INFO: Skipping dropping sequence SUB_STRUCTURE_SQ
INFO: Skipping dropping sequence SUB_STRUCTURE_USQ
INFO: Upgrade plan has been stored in /home/jchem6/cartridge/upgrade-plan.txt
INFO: Verifying schema objects...
INFO: Schema objects verified.
INFO: Loading jar file /home/jchem6/cartridge/jcart.jar into kiet's schema...
INFO: Dropping staging schema...
SEVERE: Problem connecting to the followingJDBC URL: jdbc:oracle:thin:@localhost:1521:CNBD: ORA-28009: la connexion avec SYS doit être remplacée par une connexion avec SYSDBA ou SYSOPER
. Please, check the JDBC connection properties of the JChem Server.
INFO: Using classpath: /home/jchem6/lib/jchem.jar
INFO: Connecting to localhost:1099
AdminImpl: shutdown called...
INFO: shutdown called
Exiting with exit code 0...
Exiting with exit code 0...
INFO: Server process stop-ed.
SEVERE: error
java.sql.SQLException: ORA-29532: appel Java arrêté par une exception Java non interceptée : java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: java.sql.SQLException: Problem connecting to the followingJDBC URL: jdbc:oracle:thin:@localhost:1521:CNBD: ORA-28009: la connexion avec SYS doit être remplacée par une connexion avec SYSDBA ou SYSOPER
. Please, check the JDBC connection properties of the JChem Server.
ORA-06512: à "KIET.JCHEM_CORE_PKG", ligne 70
ORA-06512: à "KIET.JCHEM_CORE_PKG", ligne 66

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
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.setPasswordForJcc(Schema.java:686)
at chemaxon.jchem.cartridge.install.schema.Schema.reconnect(Schema.java:697)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgradeDbaSchema(UpgradeCmdLine.java:343)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:320)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:71)
at chemaxon.jchem.cartridge.install.UpgradeCmdLine.main(UpgradeCmdLine.java:783)
+ set +x


ChemAxon aa7c50abf8

26-06-2013 11:21:00

Try SYSTEM instead of "sys as sysdba". (This may be a limitation of the installer program.)