2025-01-22 08:48:48 | ReportListingController | Session Expired for ReportDetails. 2025-01-22 09:38:08 | ReportListingController | Session Expired for ReportDetails. 2025-01-22 09:45:09 | ReportListingController | Session Expired for GetMasterReports. 2025-01-22 09:56:35 | ReportListingController | Session Expired for GetAllReports. 2025-01-22 10:11:07 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:6b87777c-8b3d-4e46-a20c-3e0974795973 Error Number:547,State:0,Class:16 2025-01-22 10:11:07 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:14:07 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:6b87777c-8b3d-4e46-a20c-3e0974795973 Error Number:547,State:0,Class:16 2025-01-22 10:14:07 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:15:12 | ReportListingController | Session Expired for ReportDetails. 2025-01-22 10:16:07 | ReportListingController | Session Expired for GetSlaveReportsByOrgID 2025-01-22 10:16:07 | ReportListingController | Session Expired for GetAllCategory. 2025-01-22 10:16:07 | ReportListingController | Session Expired for GetAllRoleNames. 2025-01-22 10:32:30 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:be5ed721-b339-466c-9234-d21f225ae073 Error Number:547,State:0,Class:16 2025-01-22 10:32:30 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:33:01 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:f9d713f7-666c-437c-a5aa-3f969d1fb483 Error Number:547,State:0,Class:16 2025-01-22 10:33:01 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:35:05 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:be5ed721-b339-466c-9234-d21f225ae073 Error Number:547,State:0,Class:16 2025-01-22 10:35:05 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:41:06 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:be5ed721-b339-466c-9234-d21f225ae073 Error Number:547,State:0,Class:16 2025-01-22 10:41:06 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:41:08 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:7b4b13aa-c325-420b-846d-dc0dd86f53c2 Error Number:547,State:0,Class:16 2025-01-22 10:41:08 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 10:43:22 | ReportListingController | Session Expired for GetMasterReports. 2025-01-22 10:49:13 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:f7ddea45-7c80-400f-ad66-91f5daac8d3b Error Number:547,State:0,Class:16 2025-01-22 10:49:13 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 11:02:01 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:0eb4688f-9256-4fb2-a409-d6d4abcf42fb Error Number:547,State:0,Class:16 2025-01-22 11:02:01 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 11:03:40 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "PasswordTypeCheck_Draft". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMasterDraft", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:b2f951f0-eb3f-47cc-a550-bf41f7f40ea8 Error Number:547,State:0,Class:16 2025-01-22 11:03:40 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 12:53:38 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "RB_PasswordTypeCheck". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMaster", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "RB_PasswordTypeCheck". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMaster", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:96c8ad51-c340-4901-b5fe-ba10731f99a9 Error Number:547,State:0,Class:16 2025-01-22 12:53:38 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 12:58:58 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "RB_PasswordTypeCheck". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMaster", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "RB_PasswordTypeCheck". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMaster", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:63ef82b3-2e6d-44c9-ae94-7c440322daf2 Error Number:547,State:0,Class:16 2025-01-22 12:58:58 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145 2025-01-22 13:04:50 | ReportListingRepository | An error occurred in UpdateScheduledJobs: The INSERT statement conflicted with the CHECK constraint "RB_PasswordTypeCheck". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMaster", column 'ReportLockPasswordType'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the CHECK constraint "RB_PasswordTypeCheck". The conflict occurred in database "VaLocal-Reports", table "dbo.ScheduledReportDistributionMaster", column 'ReportLockPasswordType'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 ClientConnectionId:63ef82b3-2e6d-44c9-ae94-7c440322daf2 Error Number:547,State:0,Class:16 2025-01-22 13:04:50 | ReportListingController | Error while fecthing UpdateScheduledJobs , Message - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ReportBuilderAPI.Repositories.ReportListingRepository.UpdateScheduledJobs(List`1 ReportsToUpdateList, ILog _logger) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Repositories\ReportListingRepository.cs:line 261 at ReportBuilderAPI.Controllers.ReportListingController.UpdateScheduledJobs(List`1 ToUpdateReportList) in D:\VitalAxis\Jenkins_Build\REPORT-BUILDER\buildspace\ReportBuilderAPI\QC\051_220120250125\processing\src\ReportBuilderAPI\Controllers\ReportListingController.cs:line 145