Most instances of this message should have been fixed. The problems will normally only appear in EPI. The problem is due to the Audit logs being enabled to look at the Deadlock problems. This had previously been enabled in v7 and then disabled. What that does is leave extra triggers on the tables that are involved in the Audit.
The audit triggers can be removed by carrying out following:
Find out the tables which would be used with the form in Syteline. e.g. The above message appeared when a new account was being added to EPIE. The form was Chart of Accounts and the main table involved in that form is chart_mst.
The database affected would be EPI.
Navigate to the table in SQL Management Studio and then to the Triggers for that table. The Trigger causing the problems will have 'Audit' in their name as highlighted above.
Right click on the Trigger and script Trigger as 'Drop and Create', this will open the SQL code to drop the Trigger.
Highlight the drop statement as below.
Select Execute this will then drop the selected trigger.
Carry this out for each Audit trigger associated with that table.
Now go back to the original form affected in CSI and check whether you can add a record.
Please note: If you are not sure do not carry out!!!
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article