---------------------------------------- Timestamp: 10/31/2017 3:41:08 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Could not find stored procedure 'Proc_BOS_SearchUsers'. 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 BOS_UserManagementDataAccessLayer.BOS_UserManagementDAL.SearchUserByUserType(BOS_UserSearchDTO userSearchObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 3:41:08 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at BOS_UserManagementDataAccessLayer.BOS_UserManagementDAL.SearchUserByUserType(BOS_UserSearchDTO userSearchObj) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.SearchUser(BOS_UserSearchDTO userSearchObj) InnerException - System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'Proc_BOS_SearchUsers'. 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 BOS_UserManagementDataAccessLayer.BOS_UserManagementDAL.SearchUserByUserType(BOS_UserSearchDTO userSearchObj) ClientConnectionId:30389fee-153b-4714-a0d9-c7e42761d39a Error Number:2812,State:62,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:18:06 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Could not find stored procedure 'Proc_BOS_SearchUsers'. 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 BOS_UserManagementDataAccessLayer.BOS_UserManagementDAL.SearchUserByUserType(BOS_UserSearchDTO userSearchObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:18:06 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - SQLException StackTrace - at BOS_UserManagementDataAccessLayer.BOS_UserManagementDAL.SearchUserByUserType(BOS_UserSearchDTO userSearchObj) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.SearchUser(BOS_UserSearchDTO userSearchObj) InnerException - System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'Proc_BOS_SearchUsers'. 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 BOS_UserManagementDataAccessLayer.BOS_UserManagementDAL.SearchUserByUserType(BOS_UserSearchDTO userSearchObj) ClientConnectionId:27dd92fe-2c08-4f72-9f09-65217807a805 Error Number:2812,State:62,Class:16 ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:19:17 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.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.AddOnlineSchedulingWorkOrder(CustomerDTO agent, AddWorkOrderDTO workOrderObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:21:16 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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: 10/31/2017 5:21:17 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_Email.BOS_EmailService_ArtistPro.FetchWhiteLabelRecord(String artistfirmId, String type) at BOS_Email.BOS_EmailService_ArtistPro.UpdateThemeColor(String emailtemplate, String searchid, String searchtype) InnerException - LogUtility.CustomApplicationException: GenericException ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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) --- End of inner exception stack trace --- at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at BOS_Email.BOS_EmailService_ArtistPro.FetchWhiteLabelRecord(String artistfirmId, String type) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:21:17 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at BOS_Email.BOS_EmailService_ArtistPro.BOS_SendMail(BOS_EmailDTO emailObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:21:17 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at BOS_Email.BOS_EmailService_ArtistPro.BOS_SendMail(BOS_EmailDTO emailObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:21:17 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Object reference not set to an instance of an object. StackTrace - at BOS_Email.BOS_EmailService_ArtistPro.BOS_SendMail(BOS_EmailDTO emailObj) at Grid_API.BusinessLayer.PaymentGateway.SendMailToAgentForPayement(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:23:23 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.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.AddCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:23:25 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.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.AddCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:23:26 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.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.AddCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 5:23:27 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.Grid_APIBusinessLayer.AddUpdateCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) at Grid_API.ServiceLayer.GridAPIService.AddCustomer(CustomerDTO agent, String operationType, AddressDTO addressDtoObj) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 4:26:08 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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: 10/31/2017 4:26:08 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) at Grid_API.ServiceLayer.GridAPIService.SendMailToAgentForUpdatePackage(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) InnerException - LogUtility.CustomApplicationException: GenericException ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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) --- End of inner exception stack trace --- at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 4:26:08 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at Grid_API.ServiceLayer.GridAPIService.SendMailToAgentForUpdatePackage(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) at Grid_API.ServiceLayer.GridAPIService.HandleWorkOrderPackageSuccess(UpdatePackageDTO packageObj) at Grid_API.ServiceLayer.GridAPIService.UpdatePackageDetails(UpdatePackageDTO packageObj) InnerException - LogUtility.CustomApplicationException: GenericException ---> LogUtility.CustomApplicationException: GenericException ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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) --- End of inner exception stack trace --- at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) --- End of inner exception stack trace --- at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) at Grid_API.ServiceLayer.GridAPIService.SendMailToAgentForUpdatePackage(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 4:32:27 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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: 10/31/2017 4:32:27 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) at Grid_API.ServiceLayer.GridAPIService.SendMailToAgentForUpdatePackage(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) InnerException - LogUtility.CustomApplicationException: GenericException ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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) --- End of inner exception stack trace --- at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) ---------------------------------------- ---------------------------------------- Timestamp: 10/31/2017 4:32:27 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at Grid_API.ServiceLayer.GridAPIService.SendMailToAgentForUpdatePackage(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) at Grid_API.ServiceLayer.GridAPIService.HandleWorkOrderPackageSuccess(UpdatePackageDTO packageObj) at Grid_API.ServiceLayer.GridAPIService.UpdatePackageDetails(UpdatePackageDTO packageObj) InnerException - LogUtility.CustomApplicationException: GenericException ---> LogUtility.CustomApplicationException: GenericException ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'Proc_Grid_FetchWhiteLabelData'. 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) --- End of inner exception stack trace --- at BOS_CommonUtility.BOS_CommonUtilityDataAccessLayer.BOS_ExecuteFetchCommand(String commandKey, SqlCommand cmd1, Boolean isReturnmsg, Boolean isStatuscode) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) --- End of inner exception stack trace --- at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWhiteLabelRecord(String artistfirmId, String type) at Grid_API.ServiceLayer.GridAPIService.SendMailToAgentForUpdatePackage(CustomerDetailForMail cusObj, WorkOrderViewDTO workorderObj, String pdfPath) ----------------------------------------