Unable to save/update the contents in a reaction section, Error: ORA-01426:numeric overflow

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.