Problem:
QuickDIR client fails when saving missing or found person.
Symptoms
The WCF trace log shows the errormessage below when the QuickDIR client post the data insert at the DataService.
By monitoring the database with SQL Profiler, You can see the insert into the Quickdir tables are triggered without any errors shown, but when running the query manually the error message below is shown:
Calling spAutCreateNewCase
Calling spAutUpdatePerson for Informant
Calling spUpdateCaseRelation for Informant
Msg 524, Level 16, State 1, Procedure spAddMPRegistration, Line 226 [Batch Start Line 0]
A trigger returned a resultset and the server option 'disallow results from triggers' is true.
Resolution:
The disallow results from triggers settings need to be set to false (which is the default SQL server setting).
The setting can be changed by running the command below:
exec sp_configure 'show advanced options',1
RECONFIGURE
exec sp_configure 'disallow results from triggers',0
RECONFIGURE