10:04:13 27 June 2024 Conversion failed when converting from a character string to uniqueidentifier. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 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 AppService.apiservice.startworkv6(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 13586 -------------------------------------------------- 14:06:55 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 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 AppService.Classes.Dashboard.<>c__DisplayClass22_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 2163 -------------------------------------------------- 17:06:56 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass21_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 2022 -------------------------------------------------- 17:07:04 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass21_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 2022 -------------------------------------------------- 17:11:30 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass21_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 2022 -------------------------------------------------- 17:12:50 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteScalar() at AppService.Classes.Dashboard.<>c__DisplayClass9_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 792 -------------------------------------------------- 17:12:50 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2158 {"empid":"12788","companyid":"1","data":[{"id":"a1bb482b-d547-40aa-a383-4342bc2fb227","type":2,"dataid":"e1263102-9edd-4252-8d95-6751e7c8c838","dataObj":{"id":"e1263102-9edd-4252-8d95-6751e7c8c838","orderno":"4568","companyid":"1","orderdate":"2024-06-27","marketid":"32573","distributorid":"b467ce1a-9747-4c21-bd2a-2497380d20f4","retailerid":"596fae49-30a6-463b-aeb7-d6d5e1a86ec9","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2024-06-27 17:11:23","createdBy":"12788","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"68","details":[],"latitude":"21.482645","longitude":"83.945685","location":"FWJW+QQJ, Ring Rd, Nirankari Colony, Khetrajpur, Sambalpur, Odisha 768003, India\n","cellInfo":{"radio":"gsm","cid":-1,"lac":153,"mcc":405,"mnc":866}}}]} -------------------------------------------------- 17:12:50 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2287 {"empid":"12843","companyid":"1","data":[{"id":"413b077e-582e-446e-b086-0417227dfce6","type":2,"dataid":"b32dcaea-02d2-45cf-b752-fc89fadfbff5","dataObj":{"id":"b32dcaea-02d2-45cf-b752-fc89fadfbff5","orderno":"1358","companyid":"1","orderdate":"2024-06-27","marketid":"172","distributorid":"80a96b4f-0409-407c-99af-bcf137749275","retailerid":"97db22f1-20d8-48e7-87a1-5f762bd89144","calltype":1,"grossamt":"266.67","discper":"","discamt":"","netamt":"266.67","comments":"","createdDate":"2024-06-27 17:11:21","createdBy":"12843","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"39","details":[{"itemId":"3747","name":"Mahak Jelly Belly Toy Jar MRP Rs. 5\/- per pcs (9 jar X 64+3 pcs)","rate":266.67,"purrate":0,"mrp":320,"qty":"1","amt":"266.67","packqty":9}],"latitude":"28.6283743","longitude":"77.0364765","location":"1, Central Market Road, near Soni Clinic, L-Extension, Mohan Garden, Uttam Nagar, Delhi, 110059, India\n","cellInfo":{"radio":"gsm","cid":737300,"lac":139,"mcc":404,"mnc":11}}}]} -------------------------------------------------- 17:12:50 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The wait operation timed out at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2304 {"empid":"2375","companyid":"1","data":[{"id":"4ea6f52e-a59c-42da-ba14-0bad217e7a28","type":2,"dataid":"61897a5c-dd04-45cf-8e61-f8bd9e61d220","dataObj":{"id":"61897a5c-dd04-45cf-8e61-f8bd9e61d220","orderno":"47290","companyid":"1","orderdate":"2024-06-27","marketid":"14910","distributorid":"7d81e954-5b96-461b-9562-54841cdb9ddf","retailerid":"0039c6a4-e78e-43b6-beba-4d6210c02847","calltype":1,"grossamt":"378.0","discper":"","discamt":"","netamt":"378.0","comments":"","createdDate":"2024-06-27 16:34:56","createdBy":"2375","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"48","details":[{"itemId":"2634","name":"Mahak Tingler Jar (20 Jar X 160 Count X 3.5gm each)","rate":128,"purrate":0,"mrp":160,"qty":"1","amt":"128.0","packqty":20},{"itemId":"3553","name":"Mahak Milk N Nut Nariyal Mithai (12 Jar X 300+3 Pcs)","rate":250,"purrate":0,"mrp":300,"qty":"1","amt":"250.0","packqty":12}]}},{"id":"004b0859-bcf6-4cd7-b46f-84bb61392fff","type":2,"dataid":"a0a8a455-b16a-44dc-860c-c00b69f8d0fa","dataObj":{"id":"a0a8a455-b16a-44dc-860c-c00b69f8d0fa","orderno":"47292","companyid":"1","orderdate":"2024-06-27","marketid":"14910","distributorid":"7d81e954-5b96-461b-9562-54841cdb9ddf","retailerid":"a2190b34-53f3-470d-b449-a554a3237479","calltype":1,"grossamt":"128.0","discper":"","discamt":"","netamt":"128.0","comments":"","createdDate":"2024-06-27 17:08:18","createdBy":"2375","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"44","details":[{"itemId":"3597","name":"Mahak Pan Gulkand Flavoured Candy Jar (20 Jar x 160 Counts)","rate":128,"purrate":0,"mrp":160,"qty":"1","amt":"128.0","packqty":20}],"latitude":"12.3525782","longitude":"76.6272801","location":"9J3G+2V9, Jayadevanagar, Vijay Nagar, Hebbal Industrial Estate, Hebbal, Mysuru, Karnataka 570016, India\n","cellInfo":{"radio":"gsm","cid":-1,"lac":116,"mcc":405,"mnc":861}}}]} -------------------------------------------------- 17:12:50 27 June 2024 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out 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.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler) at AppService.apiservice.getbeatretailers(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5807 -------------------------------------------------- 17:12:50 27 June 2024 This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback() at AppService.apiservice.UpdateLastLocation(String companyid, String empid, Object dataObj, Int32 type, String id, String locationdate) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 15399 at AppService.apiservice.sendlocationv2(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 3858 --------------------------------------------------