SMART Connect patrol import error "could not execute query"

SMART Community Forum
,
1

Hello! We have encountered the following error many times when importing patrols using SMART Mobile Data Import from the Data Processing Queue: “Error linking incidents to patrol: org.hibernate.exception.LockAcquisitionException: could not execute query”.

After clicking OK, it continues the import without further errors. However, I am concerned that a patrol feature could have been corrupted or be missing.

Has anyone encountered this error and/or know the cause and fix? Most importantly, does this error imply there has been data loss?

Thanks!

Alice