09:35:00 09 July 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 -------------------------------------------------- 09:36:11 09 July 2024 Snapshot isolation transaction failed in database 'tempdb' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation. at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass12_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1212 -------------------------------------------------- 09:41:38 09 July 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 -------------------------------------------------- 10:01:04 09 July 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:08:42 09 July 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 -------------------------------------------------- 15:05:43 09 July 2024 Snapshot isolation transaction failed in database 'tempdb' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation. at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass12_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1212 -------------------------------------------------- 16:49:42 09 July 2024 Snapshot isolation transaction failed in database 'tempdb' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation. at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass12_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1212 -------------------------------------------------- 17:04:03 09 July 2024 Violation of PRIMARY KEY constraint 'PK__LastActi__2A3A18B313BCEBC1'. Cannot insert duplicate key in object 'dbo.LastActive'. The duplicate key value is (1, 12232). The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppService.apiservice.addPendingLocation(SqlConnection& conn, String id, Int32 type, Object dataObj, String empid, String companyid) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5455 -------------------------------------------------- 17:17:38 09 July 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.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2149 {"empid":"12415","companyid":"1","data":[{"id":"4624188f-981d-46af-98b5-567a265ebd43","type":2,"dataid":"471d8c5c-7325-4913-849f-15ec88aa0335","dataObj":{"id":"471d8c5c-7325-4913-849f-15ec88aa0335","orderno":"8703","companyid":"1","orderdate":"2024-07-09","marketid":"16335","distributorid":"3968cf06-5920-4673-a622-14dae5f0c85f","retailerid":"1cdc3ae9-1817-403e-8103-e75279816f10","calltype":1,"grossamt":"738.48","discper":"","discamt":"","netamt":"738.48","comments":"","createdDate":"2024-07-09 17:17:01","createdBy":"12415","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"71","details":[{"itemId":"3584","name":"Mahak JB Fruit Desert Box MRP 20 (16BoxX12Cup)","rate":184.62,"purrate":0,"mrp":240,"qty":"4","amt":"738.48","packqty":16}],"latitude":"26.853031","longitude":"80.9054845","location":"264\/115, Old Labour Colony, Lucknow, Uttar Pradesh 226004, India\n","cellInfo":{"radio":"gsm","cid":4708880,"lac":46,"mcc":405,"mnc":871}}}]} --------------------------------------------------