PROBLEM:
A user of ELN 11.0.2.32 reported an error while saving/updating the
contents of a reaction section. This error is also seen in ELN
11.0.3.51.
---------------------------
Error Saving Contents
---------------------------
Sorry, while saving chemistry experiment ".................", an error
occurred while executing the SQL "UPDATE ELN_table_cells SET foreColor =
:foreC, backColor = :backC, tag = :tagV, enteredValue = :val, min_value
= :minV, max_value = :maxV, path = :pathV, path_collection_key = :pathCKey
WHERE primary_key = :piKey": ORA-01426: numeric overflow.
To discard any changes and continue, click Yes.
To back up any changes, make further changes or try to save again, click
No.
Do you want to discard any changes made to chemistry experiment
"........................" and continue?
---------------------------
Yes No
---------------------------
Note: The error is seen while saving a Chemistry experiment with a
reaction section. The reaction section contains reactants, productd, and
a solvent with no volume defined. When the user adds a 'Sample Mass'
value to one of the reactants, the Solvent volume is updated to
"Infinity ml" (case sensitive) and if the users tries to save afterwards
he/she will get the error.
CAUSE OF THE ISSUE:
Turns out the customer's 'Reaction' section type, 'Reaction Conditions'
property list field, 'Reaction Molarity' property, contains a space for
a value rather than NULL or a number. Clear out this value and
everything should work fine.
Putting in a space, for some reason results in the infinity calculation
for volume.
Any non-numeric value entered into this property will lead to this
error.
Usually from the normal Pro Config section type this property should be
set to value="" or there is no Value tag in the XML.
In this particular case there was a value=" " (space between the quotes)
in the XML. For some reason numeric field properties in tables and or
property lists are accepting non numeric values.
CS Formula listener should check for spaces in values such as this and
convert them to Null. This is considered a core bug.
With regards to "Infinity", this is a reserved word and its meaning in
code language is a long number that ELN's 'Volume' field type does not
accept and therefore it breaks.
WORKAROUND:
Clear out the space in the 'Reaction Molarity' field of the 'Reaction
Conditions' property list field.
or
Fill in the 'Volume' field of the 'Solvent' table with an actual
volume value. The experiment is saved with no errors.
Comments
0 comments
Article is closed for comments.