Skip to main content

Case History load Error 'DataTables Ajax Issue'

In this article, we explain the 'Ajax error' and NullPointerException seen when accessing Case History on a person record.

Y
Written by Yusef Abulaynain
Updated over 2 months ago

Error:

DataTables warning: table id=csh_case-history-table - Ajax error. For more information about this error, please see http://datatables.net/tn/7
​
The error in the application log is:

'java.lang.NullPointerException: null at uk.co.corelogic.mosaic.application.security.strategy.CaseHistoryStepEventPermissionStrategy.getStepContext(CaseHistoryStepEventPermissionStrategy.java:49) ~[mosaic.jar:?] at uk.co.corelogic.mosaic.application.security.strategy.AbstractStepPermissionStrategy.getPermissions(AbstractStepPermissionStrategy.java:16) ~[mosaic.jar:?]'

This is currently under investigation and appears to happen when one or more workflow steps with attachments are deleted but the related events from Case History are not removed.
​
This can be confirmed by running the following query, please raise a new case to have this checked (hosted customers) or the results reviewed, and advice provided (on premise customers).

select * from mo_case_history_events
where link_type = 'STEP'
and not exists (
select 'x'
from mo_workflow_steps mws
where mws.workflow_step_id = mo_case_history_events.link_id
);
Did this answer your question?