The structure table contains newer data version

Dear ChemAxon team,

I am developing an application in Ruby using JChem web services, and when we tried to perform runCompleteSearch, we ran into this error,

#<SOAP::Mapping::Object:0x4fa3551c>: The structure table contains newer data version that this program version can handle. Please use a later version. (SOAP::FaultError)

Abhishek,

I  tried out the same scenario, and only got another (Null pointer) exception, which will be fixed in 5.3.3. If you got this, I can suggest a workaround which will possibly help you. But as I see it is not the case, because you got a table version related message. Could you dump your property table data and attach them to a post or send them to me? I am interested in your problematic table's tableType, version and tautomerDuplicateFiltering properties. Anyway, could you try out whether you get the same error if you use JChem 5.3.1 for creating the structure table. Thank you.

Regards,

Roland

Hi Roland,

Thanks for reply, I guess this was a problem of version incompatibility or something like that. A new table created using JChemManager solved the issue. Here I am attaching JChemProperty table for the database with both tables information. 

Table which worked, table.DrugBank.JChemVersion,5.3.0.2, (created using JChemManager)

Table which did not worked, table.ALL_3.JChemVersion,5.3.1, (created using Instance JChem)

I think this issues was also mentioned here in this topic, although in this case cd_pre_calclulated was in both tables. I also attached schema of both tables for your information.

JChemProperty,

prop_name,prop_value,prop_value_ext

option.structureCompressionDisabled,true,

option.commitInterval,50,

table.ALL_3.creationTime,"2010-04-24 05:51:19.199",

table.ALL_3.validityTimestamp,"2010-04-24 05:51:19.2",

table.ALL_3.version,5030100,

table.ALL_3.absoluteStereo,true,

table.ALL_3.tableType,0,

table.ALL_3.tautomerDuplicateFiltering,false,

table.ALL_3.JChemVersion,5.3.1,

table.ALL_3.fingerprint.numberOfBits,512,

table.ALL_3.fingerprint.numberOfOnes,2,

table.ALL_3.fingerprint.numberOfEdges,6,

table.ALL_3.fingerprint.numberOfStrucFPCols,0,

table.DrugBank.creationTime,"2010-04-28 22:42:12.521",

table.DrugBank.validityTimestamp,"2010-04-28 22:42:12.537",

table.DrugBank.version,5030002,

table.DrugBank.absoluteStereo,true,

table.DrugBank.tableType,0,

table.DrugBank.tautomerDuplicateFiltering,false,

table.DrugBank.JChemVersion,5.3.0.2,

table.DrugBank.fingerprint.numberOfBits,512,

table.DrugBank.fingerprint.numberOfOnes,2,

table.DrugBank.fingerprint.numberOfEdges,6,

table.DrugBank.fingerprint.numberOfStrucFPCols,0,

Table schemas,

`DrugBank`.`cd_id`, `DrugBank`.`cd_structure`, `DrugBank`.`cd_smiles`, `DrugBank`.`cd_formula`, `DrugBank`.`cd_sortable_formula`, `DrugBank`.`cd_molweight`, `DrugBank`.`cd_hash`, `DrugBank`.`cd_flags`, `DrugBank`.`cd_timestamp`, `DrugBank`.`cd_pre_calculated`, `DrugBank`.`cd_fp1`, `DrugBank`.`cd_fp2`, `DrugBank`.`cd_fp3`, `DrugBank`.`cd_fp4`, `DrugBank`.`cd_fp5`, `DrugBank`.`cd_fp6`, `DrugBank`.`cd_fp7`, `DrugBank`.`cd_fp8`, `DrugBank`.`cd_fp9`, `DrugBank`.`cd_fp10`, `DrugBank`.`cd_fp11`, `DrugBank`.`cd_fp12`, `DrugBank`.`cd_fp13`, `DrugBank`.`cd_fp14`, `DrugBank`.`cd_fp15`, `DrugBank`.`cd_fp16`

`ALL_3`.`cd_id`, `ALL_3`.`cd_structure`, `ALL_3`.`cd_smiles`, `ALL_3`.`cd_formula`, `ALL_3`.`cd_sortable_formula`, `ALL_3`.`cd_molweight`, `ALL_3`.`cd_hash`, `ALL_3`.`cd_flags`, `ALL_3`.`cd_timestamp`, `ALL_3`.`cd_pre_calculated`, `ALL_3`.`cd_fp1`, `ALL_3`.`cd_fp2`, `ALL_3`.`cd_fp3`, `ALL_3`.`cd_fp4`, `ALL_3`.`cd_fp5`, `ALL_3`.`cd_fp6`, `ALL_3`.`cd_fp7`, `ALL_3`.`cd_fp8`, `ALL_3`.`cd_fp9`, `ALL_3`.`cd_fp10`, `ALL_3`.`cd_fp11`, `ALL_3`.`cd_fp12`, `ALL_3`.`cd_fp13`, `ALL_3`.`cd_fp14`, `ALL_3`.`cd_fp15`, `ALL_3`.`cd_fp16`, `ALL_3`.`DRUGBANK_ID`, `ALL_3`.`DRUGBANK_GENERIC_NAME`, `ALL_3`.`DRUGBANK_MOLECULAR_FORMULA`, `ALL_3`.`DRUGBANK_MOLECULAR_WEIGHT`, `ALL_3`.`DRUGBANK_EXACT_MASS`, `ALL_3`.`DRUGBANK_IUPAC_NAME`, `ALL_3`.`DRUGBANK_INCHI`, `ALL_3`.`DRUGBANK_INCHI_KEY`, `ALL_3`.`DRUGBANK_CANONICAL_SMILES`, `ALL_3`.`DRUGBANK_ISOMERIC_SMILES`chemdb.DrugBankchemdb.DrugBankEDIT

 `chemdb`.`JChemProperties`;

Hi Abhishek,

I think, the problem is that you are using Web services 5.3.0.2 and not 5.3.2 which is older than the JChem used by your IJC. So your ALL_3 table is created with version 5.3.1 which cannot be handled with JChem (and WS) 5.3.0.2. Am I right? Anyway, we are considering to change the strictness of our table version handling to avoid these kind of situations in as many cases as possible.

Regards,

Roland

Hi Roland,

thanks very much to the pointer. I am just curious how I can download the older version of Instant JChem (5_3_0_2) or newer version of webservice 5.3.2. I can not find these links in download area.

Cheers

Abhishek

For example on the bottom of the page

http://www.chemaxon.com/download/jchem/

you can see a 'Test and Archive Versions' section where you can find links to the earliest and the latest developments of JChem.

Roland