Skip to main content

Error when trying to delete a step where documents are stored in Civica or Information at Work

In this article, we look at why deleting a step with external documents can fail due to a NullPointerException.

Y
Written by Yusef Abulaynain
Updated over 5 months ago

Error:

' java.lang.RuntimeException: java.lang.NullPointerException
at uk.co.corelogic.mosaic.application.workflow.service.DeleteStepServiceImpl.deleteStepDocuments'

A workaround as confirmed by Development is to run the following to remove the documents associated with the step to be deleted:
​
1. Check how many documents are linked to the step (replacing workflow_step_id with the id of the step to be deleted)

select * from MO_DOCUMENT_METADATA where workflow_step_id = workflow_step_id

2. Delete the documents associate with the step (replacing workflow_step_id with the id of the step to be deleted)

delete from mo_document_metadata where workflow_step_id = workflow_step_id

πŸ“Œ Note: The relevant files must then be removed from the external documents system - the customer will need to do this.


​

Did this answer your question?