---------------------------------------- Timestamp: 1/6/2017 8:25:00 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Column 'ArtistuserId' does not belong to table . StackTrace - at System.Data.DataRow.get_Item(String columnName) at Grid_API.DataAccessLayer.Grid_PaymentDataAccessLayer.GetWorkOrderDetailsForPayement(String workOrderId) at Grid_API.BusinessLayer.PaymentGateway.MakeShootPayment(String workOrderId, String ClientId, String TokenId, String StripeTokenId, String agentUserId) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 8:25:00 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.BusinessLayer.PaymentGateway.MakeShootPayment(String workOrderId, String ClientId, String TokenId, String StripeTokenId, String agentUserId) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 9:02:43 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Error converting data type nvarchar to uniqueidentifier. 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 Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchArtistBasedOnArtistFirm(String artistFirmID, String searchText) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 9:02:43 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchArtistBasedOnArtistFirm(String artistFirmID, String searchText) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchArtistBasedOnArtistFirm(String artistFirmID, String searchText) 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.FetchArtistBasedOnArtistFirm(String artistFirmID, String searchText) ClientConnectionId:d9126c50-b845-4d75-994c-90dd3bed0bef Error Number:8114,State:1,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 12:11:02 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Error converting data type nvarchar to uniqueidentifier. 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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPropertyTypes(String clientId, String parentId, String artistFirmId) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 12:11:02 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPropertyTypes(String clientId, String parentId, String artistFirmId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchPropertyTypes(String clientId, String parentId, String artistFirmId) 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.FetchPropertyTypes(String clientId, String parentId, String artistFirmId) ClientConnectionId:459b57d6-202c-4b20-aeab-6c557d455072 Error Number:8114,State:1,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 12:11:02 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Conversion failed when converting from a character string to uniqueidentifier. 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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrdersBySearchString(SearchByQueryDTO workOrderSearchObj) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 12:11:02 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrdersBySearchString(SearchByQueryDTO workOrderSearchObj) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrdersBySearchString(SearchByQueryDTO workOrderSearchObj) InnerException - System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string 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.FetchWorkOrdersBySearchString(SearchByQueryDTO workOrderSearchObj) ClientConnectionId:459b57d6-202c-4b20-aeab-6c557d455072 Error Number:8169,State:2,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 1:18:05 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - The time zone ID 'US/Pacific' was not found on the local computer. StackTrace - at System.TimeZoneInfo.FindSystemTimeZoneById(String id) at BOS_CalendarDataAccessLayer.CalendarDataAccessLayer.FetchCalendarDetails(CalendarDTO appointments) at BOS_CalendarBusinessLayer.CalendarBusinessLayer.FetchCalendarDetails(CalendarDTO appointments) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 1:18:21 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - The time zone ID 'US/Pacific' was not found on the local computer. StackTrace - at System.TimeZoneInfo.FindSystemTimeZoneById(String id) at BOS_CalendarDataAccessLayer.CalendarDataAccessLayer.FetchCalendarDetails(CalendarDTO appointments) at BOS_CalendarBusinessLayer.CalendarBusinessLayer.FetchCalendarDetails(CalendarDTO appointments) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 1:18:29 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - The time zone ID 'US/Pacific' was not found on the local computer. StackTrace - at System.TimeZoneInfo.FindSystemTimeZoneById(String id) at BOS_CalendarDataAccessLayer.CalendarDataAccessLayer.FetchCalendarDetails(CalendarDTO appointments) at BOS_CalendarBusinessLayer.CalendarBusinessLayer.FetchCalendarDetails(CalendarDTO appointments) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 1:18:40 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - The time zone ID 'US/Pacific' was not found on the local computer. StackTrace - at System.TimeZoneInfo.FindSystemTimeZoneById(String id) at BOS_CalendarDataAccessLayer.CalendarDataAccessLayer.FetchCalendarDetails(CalendarDTO appointments) at BOS_CalendarBusinessLayer.CalendarBusinessLayer.FetchCalendarDetails(CalendarDTO appointments) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 1:20:14 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - The time zone ID 'Coordinated Universal Time' was not found on the local computer. StackTrace - at System.TimeZoneInfo.FindSystemTimeZoneById(String id) at BOS_CalendarDataAccessLayer.CalendarDataAccessLayer.FetchCalendarDetails(CalendarDTO appointments) at BOS_CalendarBusinessLayer.CalendarBusinessLayer.FetchCalendarDetails(CalendarDTO appointments) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 1:20:50 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - The time zone ID 'Coordinated Universal Time' was not found on the local computer. StackTrace - at System.TimeZoneInfo.FindSystemTimeZoneById(String id) at BOS_CalendarDataAccessLayer.CalendarDataAccessLayer.FetchCalendarDetails(CalendarDTO appointments) at BOS_CalendarBusinessLayer.CalendarBusinessLayer.FetchCalendarDetails(CalendarDTO appointments) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 6:37:07 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.UpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 6:38:03 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.UpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 6:38:05 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.UpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 6:52:10 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.UpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 6:52:33 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at Grid_API.BusinessLayer.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.UpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 1/6/2017 8:40:16 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText) 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText) ClientConnectionId:b32fcd22-19ad-4e6b-a497-262cea1afe2b Error Number:8114,State:1,Class:16 ----------------------------------------