Error:
'org.springframework.dao.DataIntegrityViolationException:
Error querying database. Cause: java.sql.SQLException: Cannot insert the value NULL into column 'source_form_date', table '@v_prepop_from_workflow_tab'; column does not allow nulls'
This is a bug and is fixed in Mosaic 22.1.0.2 and from Mosaic 22.2.0.0.
When pre-population through workflow is used, an error can be thrown when trying to start a step that is looking to insert NULL into source_form_date.
This can happen in sent early next actions, when the parent step is not finished, and the finished date is NULL but is used in the pre-population stored procedure.
Customers experiencing this error in earlier versions, please raise a raise a new case referencing this article and we will provide an updated version of the mosaic_forms package containing the fix.
Steps to reproduce
These steps produce this error:
Set up template X with a field to pre-populate through Workflow from template Y.
Set up Step A (with template Y) and Step B (with template X) where Step B is send early next action.
Start Step A, complete fields, send early next action (Step B) - Save step A (do not finish).
Start Step B, and the error above is written to the logs.