It seems that when I set up a product system in openLCA and calculate it, everything is fine. If I calculate the same product system from python (the one from Developer Tools, not the IPC), sometimes it corrupts something inside the system and I get empty or 0 results. When I calculate in openLCA again, I get negative process inventories as well as "�" (replacement character) in the contribution tree. All I do in python is change a global parameter and calculate.
After reconnecting all flows, I get this error:
javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLDataException: The resulting value is outside the range for the data type DOUBLE.
Error Code: 20000
Call: INSERT INTO tbl_exchanges (id, resulting_amount_value, resulting_amount_formula, base_uncertainty, cost_formula, cost_value, f_default_provider, description, dq_entry, internal_id, avoided_product, is_input, distribution_type, parameter1_formula, parameter2_formula, parameter3_formula, parameter1_value, parameter2_value, parameter3_value, f_currency, f_flow, f_flow_property_factor, f_unit) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [23 parameters bound]
Query: InsertObjectQuery(Exchange [flow=RootEntity [type=Flow, refId=714958de-a211-4a3c-8dce-848ccb79b094, name=Tungsten], input=false,amount=NaN, unit=Unit [id=1056, name=kg]])
Any ideas where that could come from? It seems like something converted some values to NaN?