Unable to Insert Null
Users may encounter the error message, "The process failed with an Exception: Error storing results. (Root message: ORA-01400: cannot insert NULL into)" when trying to execute a process. When errors like this occur it is best to open the Calculation Log with AUTOMATIC CALCULATIONS switched off. This will allow the user to see what the calculation engine was able to calculate. From this point the user should be able to work backwards through the calculation to see why a null was calculated.