Steps:
1] Generate 2 invoices.
2] Delete 1st invoice.
3] Immediately delete the 2nd invoice and observe.
Actual Result:-
Server Error is displayed on delete of 2nd invoice.
Expected Result:-
Invoice should be deleted successfully.
Error Log:-
ErrorID : 0
ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->InvoiceDetails.Delete->InvoiceDetails.DeleteInvoiceList
ErrorMessage: SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput)
TargetSite: System.String Delete(ValueObjects.BenAdminControllerWebTierEntity)