FAILED
82 passed, 28 failed, 110 total
| Result | Test |
|---|---|
| No individual test rows were parsed. See raw output. | |
(0 rows affected) Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 NULL NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 16:00:00.000 1 2026-05-01 06:00:00.000 NULL NULL NULL NULL NULL NULL 0 0 1 2026-05-01 16:00:00.000 2026-05-02 00:00:00.000 1 2026-05-01 06:00:00.000 NULL NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 NULL NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 NULL 1 2026-05-01 06:00:00.000 NULL NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 02:00:00.000 2026-05-01 06:00:00.000 1 2026-05-01 02:00:00.000 2026-05-01 06:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 999 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 999 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 broken thing alice 2026-05-01 11:00:00.000 5 2 1 0 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 broken thing alice 2026-05-01 11:00:00.000 5 2 1 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 16:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 16:00:00.000 2026-05-01 18:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 16:00:00.000 1 2026-05-01 08:00:00.000 2026-05-01 16:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 16:00:00.000 2026-05-01 18:00:00.000 1 2026-05-01 16:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 16:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 16:00:00.000 2026-05-01 18:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 16:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 16:00:00.000 2026-05-01 18:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 18:00:00.000 NULL NULL NULL NULL NULL 0 0 1 Start End OriginalDelayId OriginalStart OriginalEnd Comments JustifiedByUser JustifiedDatetime DelayCodeId DelayCategoryId IsDelayManual IsMicroDelay AssetId ----------------------- ----------------------- --------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------------------- ----------- --------------- ------------- ------------ ----------- 2026-05-01 06:00:00.000 2026-05-01 08:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 2026-05-01 08:00:00.000 2026-05-01 10:00:00.000 1 2026-05-01 06:00:00.000 2026-05-01 10:00:00.000 NULL NULL NULL NULL NULL 0 0 1 .[test insert without code or category leaves Justified fields NULL] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert with code stamps JustifiedByUser and JustifiedDatetime] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update with non-NULL Comments overwrites] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert throws 51305 when range collides with existing delay] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update throws 51307 when DelayId does not exist] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert throws 51301 when AssetId is NULL] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update writes new Start End and recomputes ShiftId] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert open delay leaves End NULL] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update throws 51312 when inherited End is before new Start] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert throws 51306 when End is NULL and a later delay exists] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update with sentinel -1 keeps current code] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update with NULL wipes code] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update with sentinel -1 on code does not re-stamp Justified fields] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert with End sets IsDelayManual IsMicroDelay and ShiftId] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test NULL skips Code and Category existence check] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test throws 51309 when DelayCodeId does not exist] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test throws 51309 when DelayCategoryId does not exist] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update changing code re-stamps Justified fields] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert throws 51304 when End is before Start] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update throws 51308 when delay is not manual] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test sentinel -1 skips Code and Category existence check] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update inherits current Start when @Start is NULL] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update with same code does not re-stamp Justified fields] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert throws 51302 when Start is NULL] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update throws 51311 when an open delay precedes Start] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test insert throws 51303 when an open delay precedes Start] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test throws 51310 when no shift exists for Start] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 .[test update with NULL Comments keeps existing] failed: (Error) Message: INSERT 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. | Procedure: DEL_UpsertManualDelay_Tests.SetUp (30) | Severity, State: 16, 1 | Number: 1934 Status TotalAlerts Subject BodyLength ------- ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- Success 5 RBD-MS Alerts (5) 4110 Status TotalWarnings Subject BodyLength ----------- ------------- --------------------- ----------- No Warnings 0 No warnings to report 0 Status NewErrors StoppedJobs ------- ----------- ----------- Success 1 1 Status TotalAlerts Subject BodyLength ------- ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- Success 5 RBD-MS Alerts (5) 4110 Status NewErrors StoppedJobs ------- ----------- ----------- Success 1 0 Status TotalAlerts Subject BodyLength --------- ----------- ------------------- ----------- No Alerts 0 No alerts to report 0 Status TotalWarnings Subject BodyLength ------- ------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- Success 1 RBD-MS Warnings (1) 4704 Status NewErrors StoppedJobs -------------- ----------- ----------- No Diagnostics 0 0 Status TotalWarnings Subject BodyLength ------- ------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- Success 10 RBD-MS Warnings (10) 5566 Status TotalWarnings Subject BodyLength ------- ------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- Success 10 RBD-MS Warnings (10) 5566 Status NewErrors StoppedJobs ------- ----------- ----------- Success 0 1 +----------------------+ |Test Execution Summary| +----------------------+ |No |Test Case Name |Dur(ms)|Result | +---+----------------------------------------------------------------------------------------------------------------------+-------+-------+ |1 |[DEL_GetDelay_Tests].[test IsDelayManual is aliased as IsManual for manual delay] | 57|Success| |2 |[DEL_GetDelay_Tests].[test returns delay row when DelayId exists] | 28|Success| |3 |[DEL_GetDelay_Tests].[test returns empty result set when DelayId does not exist] | 665|Success| |4 |[DEL_GetDelay_Tests].[test returns NULL End for active delay] | 29|Success| |5 |[DEL_GetDelay_Tests].[test returns NULL justification fields for unjustified delay] | 37|Success| |6 |[DEL_GetDelay_Tests].[test returns only matching delay when multiple delays exist] | 28|Success| |7 |[DEL_GetDelay_Tests].[test returns split delay original fields] | 36|Success| |8 |[DEL_SpliceDelaysByShiftJob_Tests].[test assigns ShiftId via GetShiftId for new slices] | 37|Success| |9 |[DEL_SpliceDelaysByShiftJob_Tests].[test closes open delay at boundary for past shifts] | 41|Success| |10 |[DEL_SpliceDelaysByShiftJob_Tests].[test does not modify delay contained in one shift] | 53|Success| |11 |[DEL_SpliceDelaysByShiftJob_Tests].[test handles delay starting on shift boundary] | 37|Success| |12 |[DEL_SpliceDelaysByShiftJob_Tests].[test ignores delays before DaysBack window] | 37|Success| |13 |[DEL_SpliceDelaysByShiftJob_Tests].[test ignores delays starting after End parameter] | 36|Success| |14 |[DEL_SpliceDelaysByShiftJob_Tests].[test is idempotent on second run] | 49|Success| |15 |[DEL_SpliceDelaysByShiftJob_Tests].[test keeps open delay open in current shift] | 41|Success| |16 |[DEL_SpliceDelaysByShiftJob_Tests].[test marks slice non-micro when longer than MinDelayTime] | 52|Success| |17 |[DEL_SpliceDelaysByShiftJob_Tests].[test NULL AssetId processes only Caster EAF LMF] | 53|Success| |18 |[DEL_SpliceDelaysByShiftJob_Tests].[test preserves OriginalDelayId when re-splicing] | 40|Success| |19 |[DEL_SpliceDelaysByShiftJob_Tests].[test propagates justification and metadata to new slices] | 40|Success| |20 |[DEL_SpliceDelaysByShiftJob_Tests].[test sets OriginalDelayId to self for first splice] | 57|Success| |21 |[DEL_SpliceDelaysByShiftJob_Tests].[test splits delay crossing multiple shift boundaries] | 53|Success| |22 |[DEL_SpliceDelaysByShiftJob_Tests].[test splits delay crossing one shift boundary] | 45|Success| |23 |[DEL_SpliceDelaysByShiftJob_Tests].[test throws when AssetId does not exist] | 17|Success| |24 |[DEL_UpsertDelayCategory_Tests].[test insert ignores @IsActive parameter] | 16|Success| |25 |[DEL_UpsertDelayCategory_Tests].[test insert with name colliding inactive sibling succeeds] | 25|Success| |26 |[DEL_UpsertDelayCategory_Tests].[test insert with same name in different area succeeds] | 29|Success| |27 |[DEL_UpsertDelayCategory_Tests].[test insert writes Name Color and DelayAreaAssetId] | 37|Success| |28 |[DEL_UpsertDelayCategory_Tests].[test successful insert does not call WriteLog] | 20|Success| |29 |[DEL_UpsertDelayCategory_Tests].[test successful update calls WriteLog once] | 21|Success| |30 |[DEL_UpsertDelayCategory_Tests].[test throws 50000 when name collides with active sibling in same area] | 20|Success| |31 |[DEL_UpsertDelayCategory_Tests].[test throws 51001 when both DelayAreaAssetId and DelayCategoryId are NULL] | 16|Success| |32 |[DEL_UpsertDelayCategory_Tests].[test throws 51002 when DelayAreaAssetId is not a delay area] | 20|Success| |33 |[DEL_UpsertDelayCategory_Tests].[test throws 51002 when update reparents to a non-delay-area asset] | 21|Success| |34 |[DEL_UpsertDelayCategory_Tests].[test throws 51004 when DelayCategoryName is NULL] | 16|Success| |35 |[DEL_UpsertDelayCategory_Tests].[test throws 51005 when DelayCategoryColor is NULL] | 16|Success| |36 |[DEL_UpsertDelayCategory_Tests].[test throws 51006 when DelayCategoryId does not exist] | 16|Success| |37 |[DEL_UpsertDelayCategory_Tests].[test update inherits DelayAreaAssetId from existing row when NULL] | 21|Success| |38 |[DEL_UpsertDelayCategory_Tests].[test update reparents category to new DelayAreaAssetId] | 25|Success| |39 |[DEL_UpsertDelayCategory_Tests].[test update toggles IsActive] | 20|Success| |40 |[DEL_UpsertDelayCategory_Tests].[test update with same name as self does not throw 50000] | 24|Success| |41 |[DEL_UpsertDelayCategory_Tests].[test update writes new DelayCategoryColor] | 45|Success| |42 |[DEL_UpsertDelayCategory_Tests].[test update writes new DelayCategoryName] | 24|Success| |43 |[RBD_EmailJobRecipients_Tests].[test 1 alerts job enqueues db recipients comma delimited] | 73|Success| |44 |[RBD_EmailJobRecipients_Tests].[test 10 diagnostic errors and stopped jobs enqueue a single combined email] | 171|Success| |45 |[RBD_EmailJobRecipients_Tests].[test 11 warnings job includes LMF started before tap section when getter returns rows]| 138|Success| |46 |[RBD_EmailJobRecipients_Tests].[test 2 alerts job converts caller override to commas without forcing operations] | 350|Success| |47 |[RBD_EmailJobRecipients_Tests].[test 3 alerts job does not enqueue when no alerts] | 98|Success| |48 |[RBD_EmailJobRecipients_Tests].[test 4 warnings job enqueues db recipients comma delimited] | 118|Success| |49 |[RBD_EmailJobRecipients_Tests].[test 5 warnings job converts caller override to commas without forcing operations] | 114|Success| |50 |[RBD_EmailJobRecipients_Tests].[test 6 warnings job does not enqueue when no warnings] | 110|Success| |51 |[RBD_EmailJobRecipients_Tests].[test 7 diagnostic errors enqueue db recipients comma delimited] | 94|Success| |52 |[RBD_EmailJobRecipients_Tests].[test 8 diagnostic stopped jobs enqueue db recipients comma delimited] | 85|Success| |53 |[RBD_EmailJobRecipients_Tests].[test 9 diagnostic does not enqueue when no errors and no stopped jobs] | 90|Success| |54 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 1 LMF start before EAF tap end is flagged] | 25|Success| |55 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 10 multiple offending heats are all flagged] | 25|Success| |56 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 11 tapping in progress with open LMF is flagged] | 49|Success| |57 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 12 tapping in progress row reports status and null MinutesEarly] | 32|Success| |58 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 13 report LMF before tap end status] | 57|Success| |59 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 2 LMF start after EAF tap end is normal] | 24|Success| |60 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 3 LMF start equal to EAF tap end is not flagged] | 24|Success| |61 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 4 open EAF that has not started tapping is ignored] | 21|Success| |62 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 5 inactive heat is ignored] | 36|Success| |63 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 6 inactive EAF process is ignored] | 25|Success| |64 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 7 inactive LMF process is ignored] | 24|Success| |65 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 8 heat older than lookback window is ignored] | 25|Success| |66 |[RBD_GetAlertsLMFStartedBeforeTap_Tests].[test 9 MinutesEarly reflects the gap] | 24|Success| |67 |[RBD_GetRecipientsByCategory_Tests].[test 1 semicolon list returns comma delimited] | 8|Success| |68 |[RBD_GetRecipientsByCategory_Tests].[test 10 missing setting defaults to operations] | 4|Success| |69 |[RBD_GetRecipientsByCategory_Tests].[test 11 empty setting defaults to operations] | 8|Success| |70 |[RBD_GetRecipientsByCategory_Tests].[test 12 whitespace only setting defaults to operations] | 4|Success| |71 |[RBD_GetRecipientsByCategory_Tests].[test 13 delimiter only setting defaults to operations] | 4|Success| |72 |[RBD_GetRecipientsByCategory_Tests].[test 14 leading delimiter is trimmed] | 4|Success| |73 |[RBD_GetRecipientsByCategory_Tests].[test 15 trailing delimiter is trimmed] | 5|Success| |74 |[RBD_GetRecipientsByCategory_Tests].[test 16 consecutive delimiters are collapsed] | 8|Success| |75 |[RBD_GetRecipientsByCategory_Tests].[test 2 semicolon list preserved for semicolon delimiter] | 4|Success| |76 |[RBD_GetRecipientsByCategory_Tests].[test 3 mixed separators unified to requested delimiter] | 4|Success| |77 |[RBD_GetRecipientsByCategory_Tests].[test 4 spaces are stripped] | 4|Success| |78 |[RBD_GetRecipientsByCategory_Tests].[test 5 operations appended when missing] | 4|Success| |79 |[RBD_GetRecipientsByCategory_Tests].[test 6 operations not duplicated when present] | 8|Success| |80 |[RBD_GetRecipientsByCategory_Tests].[test 7 operations match is case insensitive] | 4|Success| |81 |[RBD_GetRecipientsByCategory_Tests].[test 8 operations appended when only a substring match exists] | 5|Success| |82 |[RBD_GetRecipientsByCategory_Tests].[test 9 lone operations value returned unchanged] | 8|Success| |83 |[DEL_UpsertManualDelay_Tests].[test insert open delay leaves End NULL] | 4|Error | |84 |[DEL_UpsertManualDelay_Tests].[test insert throws 51301 when AssetId is NULL] | 4|Error | |85 |[DEL_UpsertManualDelay_Tests].[test insert throws 51302 when Start is NULL] | 4|Error | |86 |[DEL_UpsertManualDelay_Tests].[test insert throws 51303 when an open delay precedes Start] | 0|Error | |87 |[DEL_UpsertManualDelay_Tests].[test insert throws 51304 when End is before Start] | 0|Error | |88 |[DEL_UpsertManualDelay_Tests].[test insert throws 51305 when range collides with existing delay] | 4|Error | |89 |[DEL_UpsertManualDelay_Tests].[test insert throws 51306 when End is NULL and a later delay exists] | 4|Error | |90 |[DEL_UpsertManualDelay_Tests].[test insert with code stamps JustifiedByUser and JustifiedDatetime] | 4|Error | |91 |[DEL_UpsertManualDelay_Tests].[test insert with End sets IsDelayManual IsMicroDelay and ShiftId] | 4|Error | |92 |[DEL_UpsertManualDelay_Tests].[test insert without code or category leaves Justified fields NULL] | 4|Error | |93 |[DEL_UpsertManualDelay_Tests].[test NULL skips Code and Category existence check] | 4|Error | |94 |[DEL_UpsertManualDelay_Tests].[test sentinel -1 skips Code and Category existence check] | 4|Error | |95 |[DEL_UpsertManualDelay_Tests].[test throws 51309 when DelayCategoryId does not exist] | 4|Error | |96 |[DEL_UpsertManualDelay_Tests].[test throws 51309 when DelayCodeId does not exist] | 4|Error | |97 |[DEL_UpsertManualDelay_Tests].[test throws 51310 when no shift exists for Start] | 0|Error | |98 |[DEL_UpsertManualDelay_Tests].[test update changing code re-stamps Justified fields] | 4|Error | |99 |[DEL_UpsertManualDelay_Tests].[test update inherits current Start when @Start is NULL] | 5|Error | |100|[DEL_UpsertManualDelay_Tests].[test update throws 51307 when DelayId does not exist] | 4|Error | |101|[DEL_UpsertManualDelay_Tests].[test update throws 51308 when delay is not manual] | 0|Error | |102|[DEL_UpsertManualDelay_Tests].[test update throws 51311 when an open delay precedes Start] | 4|Error | |103|[DEL_UpsertManualDelay_Tests].[test update throws 51312 when inherited End is before new Start] | 4|Error | |104|[DEL_UpsertManualDelay_Tests].[test update with non-NULL Comments overwrites] | 4|Error | |105|[DEL_UpsertManualDelay_Tests].[test update with NULL Comments keeps existing] | 4|Error | |106|[DEL_UpsertManualDelay_Tests].[test update with NULL wipes code] | 4|Error | |107|[DEL_UpsertManualDelay_Tests].[test update with same code does not re-stamp Justified fields] | 4|Error | |108|[DEL_UpsertManualDelay_Tests].[test update with sentinel -1 keeps current code] | 4|Error | |109|[DEL_UpsertManualDelay_Tests].[test update with sentinel -1 on code does not re-stamp Justified fields] | 4|Error | |110|[DEL_UpsertManualDelay_Tests].[test update writes new Start End and recomputes ShiftId] | 0|Error | -------------------------------------------------------------------------------------------- Msg 50000, Level 16, State 10, Server f5efe9c9ffe8, Line 1 Test Case Summary: 110 test case(s) executed, 82 succeeded, 0 skipped, 0 failed, 28 errored. --------------------------------------------------------------------------------------------