09:27:31 13 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 -------------------------------------------------- 09:29:30 13 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 -------------------------------------------------- 09:41:21 13 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 -------------------------------------------------- 09:48:13 13 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 -------------------------------------------------- 10:31:19 13 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 -------------------------------------------------- 10:31:53 13 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.getpartyclosingstock(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5716 -------------------------------------------------- 11:54:41 13 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.getpartyclosingstock(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5716 -------------------------------------------------- 13:06:45 13 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.getpartyclosingstock(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5716 -------------------------------------------------- 14:07:08 13 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.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2392 {"empid":"10979","companyid":"1","data":[{"id":"d87c4274-eb16-41b3-a986-78b2163bedda","type":2,"dataid":"b5edbae6-3bf6-4d85-8b6c-1b1d856c1fd0","dataObj":{"id":"b5edbae6-3bf6-4d85-8b6c-1b1d856c1fd0","orderno":"18015","companyid":"1","orderdate":"2024-06-13","marketid":"3427","distributorid":"89680e69-00de-4c7e-8e78-0ed6a4197332","retailerid":"6f425224-6167-42b0-adb0-59648b9df55e","calltype":1,"grossamt":"160.0","discper":"","discamt":"","netamt":"160.0","comments":"","createdDate":"2024-06-13 14:06:36","createdBy":"10979","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[{"itemId":"3899","name":"Mahak Milk Lacto (20 Jar x 200 Pcs )","rate":160,"purrate":0,"mrp":200,"qty":"1","amt":"160.0","packqty":20}],"latitude":"23.052256","longitude":"72.6281404","location":"6, Naroda Rd, near Bank, off Badauda, Saijpur Bogha, Ahmedabad, Gujarat 382345, India\n","cellInfo":{"radio":"gsm","cid":646419,"lac":114,"mcc":405,"mnc":857}}}]} -------------------------------------------------- 15:30:34 13 June 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 -------------------------------------------------- 15:32:43 13 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.getpartyclosingstock(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5716 -------------------------------------------------- 15:53:54 13 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.getpartyclosingstock(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5716 -------------------------------------------------- 16:00:36 13 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.getpartyclosingstock(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 5716 -------------------------------------------------- 17:04:39 13 June 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 --------------------------------------------------