-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Production
-
Module:BenAdmin - Report
-
Reported by:Harbinger
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)
- relates to
-
WT-6331 BCC Invoice Management - Adjustments in future Invoice
-
- Closed
-
We need go ahead from you to drop trigger TR_ProtectTables as this issue is caused because of the trigger on Production.
cc: Satya
This issue is resolved with WT-9681.
Jyoti Agrawal (Inactive)
added a comment - This issue is resolved with WT-9681 . 
3C:
Concern:
Server Error is displayed on continuous deletion of two invoice one after the other.
Cause:
Drop the table cause server error because trigger TR_ProtectTables is enable on Production.
Correction:
We have to disable TR_ProtectTables trigger on Production.