---------------------------------------- Timestamp: 8/8/2017 12:02:14 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.b__1(ArtistScheduleDTO i) at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext() at System.Xml.Linq.XContainer.AddContentSkipNotify(Object content) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.AddWorkOrder(AddWorkOrderDTO workOrderObj) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddWorkOrder(AddWorkOrderDTO workOrderObj) ---------------------------------------- ---------------------------------------- Timestamp: 8/8/2017 12:02:53 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.b__1(ArtistScheduleDTO i) at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext() at System.Xml.Linq.XContainer.AddContentSkipNotify(Object content) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.AddWorkOrder(AddWorkOrderDTO workOrderObj) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddWorkOrder(AddWorkOrderDTO workOrderObj) ---------------------------------------- ---------------------------------------- Timestamp: 8/8/2017 10:02:05 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.Fetch_WorkOrderProductAdOnsPerArea(String areaId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.Fetch_WorkOrderProductAdOnsPerArea(String areaId) InnerException - System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to uniqueidentifier. 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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.Fetch_WorkOrderProductAdOnsPerArea(String areaId) ClientConnectionId:8d96af4d-f13a-4c5f-8e98-bd9b7389bad3 Error Number:8114,State:1,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 8/8/2017 10:02:05 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPackagesPerArea(String areaId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchPackagesPerArea(String areaId) InnerException - System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to uniqueidentifier. 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 Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPackagesPerArea(String areaId) ClientConnectionId:8d96af4d-f13a-4c5f-8e98-bd9b7389bad3 Error Number:8114,State:1,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 8/8/2017 10:02:34 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPackagesPerArea(String areaId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchPackagesPerArea(String areaId) InnerException - System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to uniqueidentifier. 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 Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPackagesPerArea(String areaId) ClientConnectionId:8d96af4d-f13a-4c5f-8e98-bd9b7389bad3 Error Number:8114,State:1,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 8/8/2017 10:02:34 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.Fetch_WorkOrderProductAdOnsPerArea(String areaId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.Fetch_WorkOrderProductAdOnsPerArea(String areaId) InnerException - System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to uniqueidentifier. 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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.Fetch_WorkOrderProductAdOnsPerArea(String areaId) ClientConnectionId:8d96af4d-f13a-4c5f-8e98-bd9b7389bad3 Error Number:8114,State:1,Class:16 ----------------------------------------