---------------------------------------- Timestamp: 2/28/2018 1:18:12 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Procedure or function 'Proc_Tours_PublishWorkOrder' expects parameter '@returnMessage', which was not supplied. StackTrace - at System.Data.SqlClient.SqlConnection.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 1:18:13 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.MarkWorkOrderAsComplete(WorkOrderFolderDetails workOrderForm) at Grid_API.ServiceLayer.GridAPIService.MarkWorkOrderAsComplete(WorkOrderFolderDetails WorkOrderDetails, String tokenID) InnerException - System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'Proc_Tours_PublishWorkOrder' expects parameter '@returnMessage', which was not supplied. at System.Data.SqlClient.SqlConnection.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) ClientConnectionId:5ca6d841-b7a7-4bac-8386-10ea1061f0e8 Error Number:201,State:4,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 4:34:11 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Procedure or function 'Proc_Tours_PublishWorkOrder' expects parameter '@returnMessage', which was not supplied. StackTrace - at System.Data.SqlClient.SqlConnection.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 4:34:11 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.MarkWorkOrderAsComplete(WorkOrderFolderDetails workOrderForm) at Grid_API.ServiceLayer.GridAPIService.MarkWorkOrderAsComplete(WorkOrderFolderDetails WorkOrderDetails, String tokenID) InnerException - System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'Proc_Tours_PublishWorkOrder' expects parameter '@returnMessage', which was not supplied. at System.Data.SqlClient.SqlConnection.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) ClientConnectionId:06dcbe0d-99fc-478d-9fb5-8aa6a2b62cc8 Error Number:201,State:4,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 1:18:38 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Procedure or function 'Proc_Tours_PublishWorkOrder' expects parameter '@returnMessage', which was not supplied. StackTrace - at System.Data.SqlClient.SqlConnection.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 1:18:38 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.MarkWorkOrderAsComplete(WorkOrderFolderDetails workOrderForm) at Grid_API.ServiceLayer.GridAPIService.MarkWorkOrderAsComplete(WorkOrderFolderDetails WorkOrderDetails, String tokenID) InnerException - System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'Proc_Tours_PublishWorkOrder' expects parameter '@returnMessage', which was not supplied. at System.Data.SqlClient.SqlConnection.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) ClientConnectionId:e07aaa57-ebe9-4db6-b2b0-56a8375f3ace Error Number:201,State:4,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 3:02:10 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Cannot find table 0. StackTrace - at System.Data.DataTableCollection.get_Item(Int32 index) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) ---------------------------------------- ---------------------------------------- Timestamp: 2/28/2018 3:03:09 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Cannot find table 0. StackTrace - at System.Data.DataTableCollection.get_Item(Int32 index) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) ----------------------------------------