Trouble with Marvin sketch applet 6.0.0. with IE

User 34df8f131d

29-08-2013 10:12:21

Hello,


I've some trouble when testing the Marvin Sketch applet implementation in our AgiLab ELN with IE. I'm going to try to give you all the necessary information. Please note that all works fine with Mozilla and Chrome (even if sometimes Chrome crashes, certainement because of the too heavy weight of the applet).


When trying to update a reaction with IE 10 or 9 (it worked fine with the preceding version 5.12 of the applet with IE9), my application crashes with that kind of message :


Failed to
parse target procedure




SIGNATURE
(parameter names) MISMATCH




VARIABLES IN
FORM NOT IN PROCEDURE: MOLEDITOR



NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM


where MolEditor is the name of the Marvin Sketch Applet.


I'm using the Marvin Sketch Applet :






































Product
Version:



MarvinSketch
6.0.0



Build
Date:



2013-05-22



Internal
build id:



6.0.0_b63



Operating
System:



x86
Windows 8 6.2



Java:



Oracle
Corporation Java 1.7.0_25



Memory:



494,9M maximum, 46,1M total, 21,4M free



Environment:



Trusted
Applet



Browser:



sun.plugin
1.1



and JChem cartridge version 6.0.0.


I've integrated the applet in the page like that :


<div
class="applet_dummy">




<script
type="text/javascript">




msketch_name="MolEditor";




msketch_begin(&JCHEM_PATH.,
1000, 450);




msketch_param("licenseFile",&JCHEM_LICENCE.);




msketch_param("splashScreenImage",
&JCHEM_SPLASH.);




msketch_end();




</script>




</div>




<script
type="text/javascript">




var vMolfile
= $v('SMILES');  text containing smiles string.




document.MolEditor.setMol(vMolfile);




</script>


When clicking on the Update button to update the reaction, at first I launch the JS :


NEW_SMILES := document.MolEditor.getMol("smiles");


in order to get the structure in smiles and then I submit the page that launches the following PL/SQL function :


declare




n number;




b boolean :=
true;




begin




if :CD_ID is
null then




    n := agilab_jchem.ag_jchem.add_reaction(:NEW_SMILES,
:EXPERIMENT_ID);




    update agilab_jchem.AG_REACTION set
REACTION_DESC = :REACTION_DESC, REACTION_STATUS = CVL('cs_reaction',1),
REACTIOn_EXP_CONDS = :REACTION_EXP_CONDS where




    CD_ID = n;




else




    if :SMILES <> :NEW_SMILES then




         b := agilab_jchem.ag_jchem.modify_reaction(:NEW_SMILES,
:CD_ID);




    end if;




    if b then




         update agilab_jchem.AG_REACTION set
REACTION_DESC = :REACTION_DESC, REACTION_EXP_CONDS = :REACTION_EXP_CONDS where
CD_ID = :CD_ID;




    end if;




end if;




end;


where the function add_reaction implements the JCHEM cartridge function :


reac_id :=
agilab_jchem.jchem_table_pkg.jc_insert(p_structure,'agilab_jchem.AG_REACTION',
null, 'false','false',' haltOnBadFormat:y');


where p_structure is the first parameter (smiles) of the add_reaction function,


and the function modify_reaction implements the JCHEM cartridge function :


agilab_jchem.jchem_table_pkg.jc_update(p_structure,'agilab_jchem.AG_REACTION', cd_id);


Do you have any idea why all works fine with Firefox and Chrome and not with IE ? Is there a special parameter to add in the applet or a special configuration of IE ? Thanks for your feedback.


 


Renaud


 

ChemAxon 5433b8e56b

29-08-2013 13:26:49

Hi Renaud,


from the error message I would say this is an issue with the data and its runtime type on the database side when it was called from IE.


Can you check that the smiles is returned by the getMol method, and its value is not null, I suggest to check also its runtime type, because the error message tells that it does not find the procedure based on the parameters given, and this could be because the runtime type of the value is different then the accepted value.


I am not really know much about the database side, so I hope based on this information you can track this issue down. If not, feel free to write us with the results, and we will try to find out what happens.


Regards,
Istvan