App error log-
ErrorID : 0
ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->ReportDetails.Save->ReportDetails.GetQuery
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.Save(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)

Web error log-
Exception : 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.
App Error Log : ControllerAppTier.Save->BenAdminControllerAppTier.Save->ReportDetails.Save->ReportDetails.GetQuery
Employee ID : 0
Action Name : SavePreviewReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : Report
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode)
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.PreviewReport(StandardReportsModel objStandardReportsModel)
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.SavePreviewReport(StandardReportsModel objStandardReportsModel, String SubmitType)
at lambda_method(Closure , ControllerBase , Object[] )

CC: Prasanna Karlekar

Hi Debbie Kulling,

We are working on it. Will update you by Monday(06/05/17).

Thanks,
Jyoti Agrawal

CC: Prasanna Karlekar

Please note we are having this issue pulling any custom form fields. It is not just the Tobacco questions. Please test all custom forms on the report.

Hi Debbie Kulling,

Below are 3C's :-
Concern:- Server Error when pulling report of custom form questions.

Cause :- On selection of custom form fields we were creating a physical temporary table at runtime. This table also needs to be dropped once used.
A trigger 'TR_ProtectTables' at database level was restricting the drop of table. This was causing server error.

Correction :- We observed this issue on Floyd and Barrow.Hence, for now we have disabled the trigger on Floyd and Barrow. We have verified by selecting all custom fields.
Also, we are checking with our DBA for permanent fix.

CC:Prasanna Karlekar,Indraprakash Tiwari,Satya

Thanks,
Jyoti Agrawal

Thank you. I confirmed I was able to run the reports. Please advise when a permanent fix is complete

Hi Debbie Kulling,

Permanent fix for this will be deployed on our environment by tomorrow(06/07/17). Further details for deployment on Stage and Production environment will be shared by QA.

CC: Sachin Hingole,Satya,Prasanna Karlekar,Indraprakash Tiwari

Thanks,
Jyoti Agrawal

Following permanent fix was done :-
After discussion with DBA, we have dropped the trigger 'TR_ProtectTables' from all databases as this was no more in use.

CC: Satya,Indraprakash Tiwari,Prasanna Karlekar

Thanks,
Jyoti Agrawal

Sanjana Jadhav Please check this issue.

[~meghana joshi]Sachin HingoleHrishikesh Deshpande

Verified on LB.
Report saved succesfully.
Ready for stage.
PFA,

Thanks,
Sanjana Jadhav

CC: Rakesh Roy Hrishikesh Deshpande Sachin Hingole

Hi Prasanna Karlekar
Verified on stage
Getting server error and not able to save report.
PFA and error log
9681_error log.txt

Thanks,
Sanjana Jadhav

CC: Rakesh Roy Hrishikesh Deshpande

Hi Sanjana Jadhav,

Please create new JIRA for this issue.
Fix done was related to TR_ProtectTables trigger. Issue mentioned in 9681_error log.txt is due to improper configuration of additional fields.

cc: Jyoti Agrawal, Hrishikesh Deshpande

Verified on stage.
Able to save report.
Ready for production.
PFA,

Thanks,
Sanjana Jadhav.

CC: Rakesh Roy Hrishikesh Deshpande

Verified on production.
Report saved succesfully.
PFA,

Thanks,
Sanjana Jadhav

CC: Rakesh Roy Hrishikesh Deshpande Sachin Hingole