error occured in IJC 5.6

User 1887159699

28-10-2011 20:58:42

Hi,


while searching in a database produced by IJC5.6, i got an error:


chemaxon.formats.MolFormatException: ;: unknown ChemAxon Extended SMILES feature
    at chemaxon.marvin.io.formats.smiles.CxsmilesImport.readExtendedFeatures(CxsmilesImport.java:916)
    at chemaxon.marvin.io.formats.smiles.SmilesImport.readMol(SmilesImport.java:569)
    at chemaxon.marvin.io.formats.smiles.CxsmilesImport.readMol(CxsmilesImport.java:63)
[catch] at chemaxon.jchem.db.JChemSearch$ABASThread.run(JChemSearch.java:619)


The log file is empty and the query is:


C(C1CCCC1)C1CCCC1 |LN:0:1.100,2:1.20,10:1.20|


What is wrong with the query?


Best, Hinnerk


 


 


 


The environment is:


Instant JChem Version: 5.6.0.2 (build: 201110041526-149372)
JChem Version: 5.6.0.2
JChem Table Version: 5060000
Marvin Version: 5.6.0.2 (build date: 2011-09-30)
Java: 1.6.0_26; Java HotSpot(TM) 64-Bit Server VM 20.1-b02
System: Windows 7 version 6.1 running on amd64; Cp1252; de_DE (instantjchem)
NetBeans build: 110214-aec102d89c78
Userdir: C:\Users\...\AppData\Roaming\.instantjchem\ijc_5_6
Java Web Start: No
Plugins:
    chemaxon.ijc.updatecenter [5.6 201110041526-149372]
    chemaxon.jchem/1 [5.6.0.2 201110041526-149372]
    com.codehaus.groovy [1.7.10 201110041526-149372]
    com.compositesw.jdbc/1 [5.1.0 201110041526-149372]
    com.google.common.guava [8.0 201110041526-149372]
    com.im.commons [5.6 201110041526-149372]
    com.im.commons.db [5.6 201110041526-149372]
    com.im.commons.db.test [5.6 201110041526-149372]
    com.im.commons.nbcommons [5.6 201110041526-149372]
    com.im.commons.ui [5.6 201110041526-149372]
    com.im.db.composite/1 [5.6 201110041526-149372]
    com.im.df.api [5.6 201110041526-149372]
    com.im.df.api.friend [5.6 201110041526-149372]
    com.im.df.core.derby/1 [5.6 201110041526-149372]
    com.im.df.core.oracle/1 [5.6 201110041526-149372]
    com.im.df.db.mysql/1 [5.6 201110041526-149372]
    com.im.df.exportimport [5.6 201110041526-149372]
    com.im.df.localdb/1 [5.6 201110041526-149372]
    com.im.df.server.local [5.6 201110041526-149372]
    com.im.df/1 [5.6 201110041526-149372]
    com.im.ijc.autoupdate/1 [5.6 201110041526-149372]
    com.im.ijc.branding/1 [5.6.0.2 201110041526-149372]
    com.im.ijc.cf [5.6 201110041526-149372]
    com.im.ijc.chem.overlap/1 [5.6 201110041526-149372]
    com.im.ijc.core/1 [5.6.0.2 201110041526-149372]
    com.im.ijc.extraloaders [5.6 201110041526-149372]
    com.im.ijc.formview/1 [5.6 201110041526-149372]
    com.im.ijc.gridview/1 [5.6 201110041526-149372]
    com.im.ijc.groovy [5.6 201110041526-149372]
    com.im.ijc.io [5.6 201110041526-149372]
    com.im.ijc.jrprinting [5.6 201110041526-149372]
    com.im.ijc.logviewer [5.6 201110041526-149372]
    com.im.ijc.project/1 [5.6 201110041526-149372]
    com.im.ijc.querytextpanel [5.6 201110041526-149372]
    com.im.ijc.reactor/1 [5.6 201110041526-149372]
    com.im.ijc.renderers/1 [5.6 201110041526-149372]
    com.im.ijc.security/1 [5.6 201110041526-149372]
    com.im.ijc.server.api [5.6 201110041526-149372]
    com.im.ijc.server.impl [5.6 201110041526-149372]
    com.im.ijc.serverconnect [5.6 201110041526-149372]
    com.im.ijc.sfs [5.6 201110041526-149372]
    com.im.ijc.sketchreg [5.6 201110041526-149372]
    com.im.ijc.sketchreg.chemdraw [5.6 201110041526-149372]
    com.im.ijc.standardizer/1 [5.6 201110041526-149372]
    com.im.ijc.structurefiles/1 [5.6 201110041526-149372]
    com.im.ijc.training [5.6 201110041526-149372]
    com.im.ijc.update.pack [5.6.0.2 201110041526-149372]
    com.im.ijc.versionprovider [5.6.0.2 201110041526-149372]
    com.im.ijc.welcome/1 [5.6 201110041526-149372]
    com.im.ijc.widgets/1 [5.6 201110041526-149372]
    com.im.ijcs.test [5.6 201110041526-149372]
    com.im.ijcs.test.tomcat [5.6 201110041526-149372]
    com.im.uiutil [5.6 201110041526-149372]
    com.jacob.com [1.0 201110041526-149372]
    com.jamesmurty.util [0.5 201110041526-149372]
    com.l2fprod.common.swing.outlookbar [1.0 201110041526-149372]
    com.lowagie.iia [2.1.7 201110041526-149372]
    com.michaelbaranov.microba/1 [0.4.4.3 201110041526-149372]
    com.mysql.jdbc/1 [5.1.13 201110041526-149372]
    embedded.ldap [1.0 2.4.2 201110041526-149372]
    it.tidalwave.image [0.9.6.1.1 201110041526-149372]
    net.sf.cglib/1 [2.1.3 201110041526-149372]
    net.sf.jasperreports/1 [3.7.6 201110041526-149372]
    net.sf.jsqlparser/0 [0.7.0.1 201110041526-149372]
    o.mozilla.rhino/1 [1.7.2 110214-aec102d89c78]
    oracle.jdbc/1 [11.2.0.2.0.1 201110041526-149372]
    org.acegisecurity/1 [3.0.5.1 201110041526-149372]
    org.apache.commons.beanutils/1 [1.8.3 201110041526-149372]
    org.apache.commons.collections/1 [3.2.1 201110041526-149372]
    org.apache.commons.dbcp/1 [1.4 201110041526-149372]
    org.apache.commons.digester/1 [2.1 201110041526-149372]
    org.apache.commons.lang/1 [2.5 201110041526-149372]
    org.apache.commons.pool/1 [1.5.5 201110041526-149372]
    org.apache.derby/1 [10.5.1.1.1 201110041526-149372]
    org.apache.poi [3.7 201110041526-149372]
    org.apache.tomcat [7.0.14 201110041526-149372]
    org.apache.tools.ant/1 [1.8.2 201110041526-149372]
    org.apache.xml.resolver [1.11.1.12 12 110214-aec102d89c78]
    org.ccil.cowan.tagsoup [1.2 201110041526-149372]
    org.dom4j/1 [1.6.1 201110041526-149372]
    org.eclipse.jdt.core.compiler [5.3.1 201110041526-149372]
    org.freehep/1 [5.2.6 201110041526-149372]
    org.jdesktop.layout/1 [1.13.1 110214-aec102d89c78]
    org.jfree.chart [1.0.13.2 201110041526-149372]
    org.netbeans.api.annotations.common/1 [1.5.1 110214-aec102d89c78]
    org.netbeans.api.java.classpath/1 [1.25.1 110214-aec102d89c78]
    org.netbeans.api.progress/1 [1.20.2 110214-aec102d89c78]
    org.netbeans.api.visual [2.23.1.1 110214-aec102d89c78]
    org.netbeans.api.xml/1 [1.22.1 110214-aec102d89c78]
    org.netbeans.bootstrap/1 [2.33.2 110214-aec102d89c78]
    org.netbeans.core.browser/1 [1.6.1.1 1 110214-aec102d89c78]
    org.netbeans.core.execution/1 [1.20.1 110214-aec102d89c78]
    org.netbeans.core.ide/1 [1.20.1 110214-aec102d89c78]
    org.netbeans.core.io.ui/1 [1.8.1 110214-aec102d89c78]
    org.netbeans.core.multiview/1 [1.18.1 110214-aec102d89c78]
    org.netbeans.core.nativeaccess/1 [1.7.1 110214-aec102d89c78]
    org.netbeans.core.netigso [1.4.3 110214-aec102d89c78]
    org.netbeans.core.osgi [1.1.1 110214-aec102d89c78]
    org.netbeans.core.output2/1 [1.18.2 110214-aec102d89c78]
    org.netbeans.core.startup/1 [1.25.3 110214-aec102d89c78]
    org.netbeans.core.ui/1 [1.22.1 110214-aec102d89c78]
    org.netbeans.core.windows/2 [2.21.1.1 110214-aec102d89c78]
    org.netbeans.core/2 [3.20.2.1 110214-aec102d89c78]
    org.netbeans.insane/1 [1.9.1.1 1 110214-aec102d89c78]
    org.netbeans.libs.commons_codec/1 [1.5.1 110214-aec102d89c78]
    org.netbeans.libs.commons_logging/1 [1.13.1.11 11 110214-aec102d89c78]
    org.netbeans.libs.felix [1.1.1 110214-aec102d89c78]
    org.netbeans.libs.freemarker/1 [2.11.1.238 238 110214-aec102d89c78]
    org.netbeans.libs.jna/1 [1.7.2 110214-aec102d89c78]
    org.netbeans.libs.jsr223/1 [1.15.1 110214-aec102d89c78]
    org.netbeans.libs.junit4 [1.9.1 110214-aec102d89c78]
    org.netbeans.libs.jzlib/1 [1.4.1.107 107 110214-aec102d89c78]
    org.netbeans.libs.lucene/1 [2.10.1.232 232 110214-aec102d89c78]
    org.netbeans.libs.nbi.ant [1.2.2 110214-aec102d89c78]
    org.netbeans.libs.nbi.engine [1.1.1 110214-aec102d89c78]
    org.netbeans.libs.osgi [1.1.1 110214-aec102d89c78]
    org.netbeans.libs.swingx/1 [1.6.1 110214-aec102d89c78]
    org.netbeans.libs.xerces/1 [1.18.1.280 280 110214-aec102d89c78]
    org.netbeans.modules.applemenu/1 [1.16.1 110214-aec102d89c78]
    org.netbeans.modules.autoupdate.services [1.20.1 110214-aec102d89c78]
    org.netbeans.modules.autoupdate.ui [1.16.1 110214-aec102d89c78]
    org.netbeans.modules.csl.api/2 [2.5.1.2.1.1.4 2 110214-aec102d89c78]
    org.netbeans.modules.db.core [1.15.2 110214-aec102d89c78]
    org.netbeans.modules.db.dataview [1.7.1 110214-aec102d89c78]
    org.netbeans.modules.db.metadata.model/0 [0.9.1 110214-aec102d89c78]
    org.netbeans.modules.db.sql.editor [1.15.1.30 110214-aec102d89c78]
    org.netbeans.modules.db.sql.visualeditor/1 [2.9.1.30 110214-aec102d89c78]
    org.netbeans.modules.db/1 [1.38.2.30 30 110214-aec102d89c78]
    org.netbeans.modules.dbapi [1.13.1.30 110214-aec102d89c78]
    org.netbeans.modules.defaults/1 [1.11.1 110214-aec102d89c78]
    org.netbeans.modules.derby [1.18.1 110214-aec102d89c78]
    org.netbeans.modules.diff/1 [1.28.2.42.1 42 110214-aec102d89c78]
    org.netbeans.modules.editor.actions/1 [1.5.1.2 110214-aec102d89c78]
    org.netbeans.modules.editor.bookmarks/1 [1.13.1 110214-aec102d89c78]
    org.netbeans.modules.editor.bracesmatching/0 [1.13.1 110214-aec102d89c78]
    org.netbeans.modules.editor.codetemplates/1 [1.17.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.editor.completion/1 [1.20.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.editor.deprecated.pre61settings/0 [1.8.1.1.3.10.2 1 110214-aec102d89c78]
    org.netbeans.modules.editor.errorstripe.api/1 [2.11.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.editor.errorstripe/2 [2.12.1.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.editor.fold/1 [1.18.1.2 110214-aec102d89c78]
    org.netbeans.modules.editor.guards/1 [1.8.1 110214-aec102d89c78]
    org.netbeans.modules.editor.indent.project/0 [1.1.1 110214-aec102d89c78]
    org.netbeans.modules.editor.indent/2 [1.19.1.10 110214-aec102d89c78]
    org.netbeans.modules.editor.lib/2 [2.10.2.10.2 10 110214-aec102d89c78]
    org.netbeans.modules.editor.lib2/1 [1.28.1.2 2 110214-aec102d89c78]
    org.netbeans.modules.editor.macros/0 [1.9.1.1.10 1 110214-aec102d89c78]
    org.netbeans.modules.editor.mimelookup.impl/1 [1.9.1 110214-aec102d89c78]
    org.netbeans.modules.editor.mimelookup/1 [1.16.1 110214-aec102d89c78]
    org.netbeans.modules.editor.plain.lib/1 [1.13.1 110214-aec102d89c78]
    org.netbeans.modules.editor.plain/2 [1.14.1 110214-aec102d89c78]
    org.netbeans.modules.editor.settings.storage/1 [1.25.1 110214-aec102d89c78]
    org.netbeans.modules.editor.settings/1 [1.31.1 110214-aec102d89c78]
    org.netbeans.modules.editor.structure/1 [1.24.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.editor.util/1 [1.36.1 110214-aec102d89c78]
    org.netbeans.modules.editor/3 [1.50.1.3.10.2 3 110214-aec102d89c78]
    org.netbeans.modules.extbrowser/1 [1.19.1 110214-aec102d89c78]
    org.netbeans.modules.favorites/1 [1.20.1 110214-aec102d89c78]
    org.netbeans.modules.javahelp/1 [2.17.1 110214-aec102d89c78]
    org.netbeans.modules.jumpto/1 [1.17.1 110214-aec102d89c78]
    org.netbeans.modules.keyring [1.1.2 110214-aec102d89c78]
    org.netbeans.modules.keyring.impl [1.0.1 110214-aec102d89c78]
    org.netbeans.modules.lexer.nbbridge/1 [1.10.1.1 110214-aec102d89c78]
    org.netbeans.modules.lexer/2 [1.35.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.masterfs/2 [2.25.2 110214-aec102d89c78]
    org.netbeans.modules.nbjunit/1 [1.63.1 110214-aec102d89c78]
    org.netbeans.modules.options.api/1 [1.18.1 110214-aec102d89c78]
    org.netbeans.modules.options.editor/1 [1.21.1 110214-aec102d89c78]
    org.netbeans.modules.options.keymap [1.10.1 110214-aec102d89c78]
    org.netbeans.modules.parsing.api/1 [1.33.2.4 4 110214-aec102d89c78]
    org.netbeans.modules.print.editor [7.6.1 110214-aec102d89c78]
    org.netbeans.modules.progress.ui [1.12.1 110214-aec102d89c78]
    org.netbeans.modules.projectapi/1 [1.31.1 110214-aec102d89c78]
    org.netbeans.modules.projectui [1.21.3.8 110214-aec102d89c78]
    org.netbeans.modules.projectuiapi/1 [1.47.2.8 8 110214-aec102d89c78]
    org.netbeans.modules.queries/1 [1.19.1 110214-aec102d89c78]
    org.netbeans.modules.refactoring.api [1.11.1 110214-aec102d89c78]
    org.netbeans.modules.schema2beans/1 [1.25.1 110214-aec102d89c78]
    org.netbeans.modules.sendopts/2 [2.9.1 110214-aec102d89c78]
    org.netbeans.modules.server/0 [1.9.1 110214-aec102d89c78]
    org.netbeans.modules.settings/1 [1.26.1 110214-aec102d89c78]
    org.netbeans.modules.spi.actions/1 [1.7.1 110214-aec102d89c78]
    org.netbeans.modules.swing.validation/1 [1.7.1 110214-aec102d89c78]
    org.netbeans.modules.target.iterator/1 [1.2.1 110214-aec102d89c78]
    org.netbeans.modules.usersguide/1 [1.28.1 110214-aec102d89c78]
    org.netbeans.modules.utilities/1 [1.35.1 110214-aec102d89c78]
    org.netbeans.modules.web.common [1.6.1 110214-aec102d89c78]
    org.netbeans.modules.web.flyingsaucer/1 [1.8.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.xml [1.9.1 110214-aec102d89c78]
    org.netbeans.modules.xml.axi [1.10.1 110214-aec102d89c78]
    org.netbeans.modules.xml.core/2 [1.21.1.4 4 110214-aec102d89c78]
    org.netbeans.modules.xml.lexer [1.9.1 110214-aec102d89c78]
    org.netbeans.modules.xml.retriever/1 [1.10.2 110214-aec102d89c78]
    org.netbeans.modules.xml.schema.completion [1.9.2 110214-aec102d89c78]
    org.netbeans.modules.xml.schema.model/1 [1.10.1.1 1 110214-aec102d89c78]
    org.netbeans.modules.xml.text/2 [1.24.1.5 5 110214-aec102d89c78]
    org.netbeans.modules.xml.xam/1 [1.10.2.1 1 110214-aec102d89c78]
    org.netbeans.modules.xml.xdm/1 [1.11.2.1 1 110214-aec102d89c78]
    org.netbeans.spi.editor.hints/0 [1.14.1.7.2 7 110214-aec102d89c78]
    org.netbeans.spi.navigator/1 [1.13.1 110214-aec102d89c78]
    org.netbeans.spi.palette/1 [1.22.1 110214-aec102d89c78]
    org.netbeans.spi.quicksearch [1.6.1 110214-aec102d89c78]
    org.netbeans.spi.tasklist/1 [1.11.1.1 1 110214-aec102d89c78]
    org.netbeans.swing.dirchooser [1.8.1 110214-aec102d89c78]
    org.netbeans.swing.outline [1.9.1 110214-aec102d89c78]
    org.netbeans.swing.plaf [1.16.1 110214-aec102d89c78]
    org.netbeans.swing.tabcontrol [1.21.1 110214-aec102d89c78]
    org.openide.actions [6.16.1 110214-aec102d89c78]
    org.openide.awt [7.23.1 110214-aec102d89c78]
    org.openide.compat [6.13.1 110214-aec102d89c78]
    org.openide.dialogs [7.15.1 110214-aec102d89c78]
    org.openide.execution [1.18.1 110214-aec102d89c78]
    org.openide.explorer [6.28.2 110214-aec102d89c78]
    org.openide.filesystems [7.38.2 110214-aec102d89c78]
    org.openide.io [1.23.1 110214-aec102d89c78]
    org.openide.loaders [7.16.1 110214-aec102d89c78]
    org.openide.modules [7.17.2 110214-aec102d89c78]
    org.openide.nodes [7.16.1 110214-aec102d89c78]
    org.openide.options [6.15.1 110214-aec102d89c78]
    org.openide.text [6.30.1 110214-aec102d89c78]
    org.openide.util [8.6.1 110214-aec102d89c78]
    org.openide.util.lookup [8.3.1 110214-aec102d89c78]
    org.openide.windows [6.33.1 110214-aec102d89c78]
    org.openidex.util/3 [3.25.1 110214-aec102d89c78]
    org.quartz/1 [1.8.4.1 201110041526-149372]
    org.springframework/1 [3.0.5.1 201110041526-149372]
    org.xhtmlrenderer [8.0 201110041526-149372]
    swingx/1 [1.6 201110041526-149372]

ChemAxon fb166edcbd

31-10-2011 13:44:05

It seems that the query is OK and it is the target which causes the problem: there is a ';' character in its CXSMILES representation and this character cannot be interpreted by CXSMILES import.

User 1887159699

31-10-2011 13:48:38

Many thx for the quick answwer. How do I figure out, which entry in my Table (100k compounds, based on MOL input) causes the problem and how can i fix it? I canceled the query, as it seems to run some hours.

ChemAxon fa971619eb

03-11-2011 12:43:54

Hi Hinnerk


I think you need to search the database to find these. The data is stored in the CD_SMILES column. I'm not sure what you need to search for as its not eactly clear what he offending characters are, but it seems that a seach for


;:

(that's semi-colon followed by colon) migth find it.


If you have direct access to the database then you can query this using SQL. You would likley need SQL like this:


select CD_ID from <your_table> where CD_SMILES like '%;:%'

In IJC you can promote the CD_SMILES column so that it is a normal IJC field (text field) and then run searches on it in IJC.e.g seeach using the contains operator and search for ;:


Not sure if this will find just the offending record, but hopefully you should be able to find it with an approach like this.


Once you do find it please send us the offending mol file (from the CD_STRUCTURE column).


Thanks


Tim


 


 

User 1887159699

04-11-2011 15:36:27

Hi Tim,


I am new to IJC, therefore i need some assistance, where / how to find the needed information.


My workflow was:


Creating a localdb from a sdfile (100k compounds, organic, oranometallics, inorganic, markush).


I used the default values and always clicked OK if needed.


The I created my query, which produced the crash. Other (simpler queries) are OK. Maybe the screening did not select the problematic compound for further abas. I know, that the complex query uses abas at an quite early stage in the query (or do you have screens for linknode?).


Since i use a localDB, i do not know, how to access the structures from "external" (like in an external database via sql). Where are the structures stored and how could I access them (is it for example a mysql DB, or is it a proprietary db-engine / file)?


Best, Hinnerk

ChemAxon fa971619eb

04-11-2011 15:49:10

The local DB is a Derby DB. It can be acccessed as a normal database. Instructions can be found here:
http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/tips_and_tricks/db_explorer.html


But most likley you wll find it easier to do this directly in IJC. Try this:


1. open the schema editor by double clicking on the 'localdb' node in the projects window


2. find the appropriate entity under the Entities section and expand the Fields node.


3. right click on the fields node and choose 'Promote field' and choose CD_SMILES. This column should be added as a field.


4. Go to the grid view for that entity. Show the Smiles column (if not already shown)


5. Run the query mentioned earlier on this field.


 


Tim

User 1887159699

04-11-2011 19:58:28

Hi Tim,


after some iterative testing, I found this structure, which causes the errors (above query as substructure).


It is not the only one, which has ";" in cxsmiles. I hve dozens, which also have ";" and are OK with the query.


Best, Hinnerk


-----------



  Mrv0541 11041117482D          

  9  8  0  0  0  0            999 V2000
    3.2711   -1.7964    0.0000 R#  0  0  0  0  0  0  0  0  0  0  0  0
    2.8492   -1.0862    0.0000 C   0  0  0  0  0  0  0  0  0  0  0  0
    2.4440   -1.8048    0.0000 C   0  0  0  0  0  0  0  0  0  0  0  0
    3.5719   -0.6600    0.0000 N   0  0  0  0  0  0  0  0  0  0  0  0
    4.2988   -1.0736    0.0000 C   0  0  0  0  0  0  0  0  0  0  0  0
    3.5636    0.1671    0.0000 R#  0  0  0  0  0  0  0  0  0  0  0  0
    2.1306   -0.6810    0.0000 C   0  0  0  0  0  0  0  0  0  0  0  0
    1.4162   -1.1029    0.0000 O   0  0  0  0  0  0  0  0  0  0  0  0
    2.1181    0.1546    0.0000 O   0  0  0  0  0  0  0  0  0  0  0  0
  2  7  1  0  0  0  0
  2  4  1  0  0  0  0
  7  8  1  0  0  0  0
  2  1  1  0  0  0  0
  7  9  2  0  0  0  0
  4  5  1  0  0  0  0
  3  2  1  0  0  0  0
  4  6  1  0  0  0  0
A    3
^$R1
A    5
^$R4
M  RGP  2   1   1   6   4
M  END

----------------------

ChemAxon 25dcd765a3

07-11-2011 10:58:20

Hi Hinnerk,


Thank you for the report. We start to fix this issue ASAP.


Andras

ChemAxon 25dcd765a3

09-11-2011 13:03:09

Hi Hinnerk,


We have fixed this issue.


The 5.7 release commit deadline is over but the 5.8 release will contain the fix.


Andras