09:45:08 03 August 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:04:24 03 August 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 -------------------------------------------------- 12:07:44 03 August 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 -------------------------------------------------- 12:59:34 03 August 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:30:45 03 August 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 -------------------------------------------------- 13:39:39 03 August 2024 Violation of PRIMARY KEY constraint 'PK_'. Cannot insert duplicate key in object 'dbo.voucherMaster'. The duplicate key value is (150373). The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2616 {"empid":"12418","companyid":"1","data":[{"id":"c95404d2-e2b8-42e3-88f7-f3022a7665e3","type":3,"dataid":"6a4e82b6-ecf8-4233-983c-f027be989325","dataObj":{"id":"6a4e82b6-ecf8-4233-983c-f027be989325","companyid":"1","clsdate":"2024-08-03","distributorid":"3968cf06-5920-4673-a622-14dae5f0c85f","value":"123281.26","createdDate":"2024-08-03 13:39:36","createdBy":"12418","details":[{"itemId":"2634","name":"Mahak Tingler Jar (20 Jar X 160 Count X 3.5gm each)","rate":128,"purrate":0,"mrp":160,"qty":"19","amt":"2432.0","packqty":20},{"itemId":"3597","name":"Mahak Pan Gulkand Flavoured Candy Jar (20 Jar x 160 Counts)","rate":128,"purrate":0,"mrp":160,"qty":"20","amt":"2560.0","packqty":20},{"itemId":"3826","name":"Mahak Popon Milky Lolipop (20 Poly Bags x 48 Pcs)","rate":192,"purrate":0,"mrp":240,"qty":"11","amt":"2112.0","packqty":20},{"itemId":"3875","name":"MAHAK KANDIEZ ASSORTED MINI SMILEY DOLL ( 24 JAR X 100 COUNT )","rate":85,"purrate":0,"mrp":100,"qty":"34","amt":"2890.0","packqty":24},{"itemId":"3899","name":"Mahak Milk Lacto (20 Jar x 200 Pcs )","rate":160,"purrate":0,"mrp":200,"qty":"14","amt":"2240.0","packqty":20},{"itemId":"2814","name":"Mahak Kandiez Miss Imli Delicious Candy (20 Jar x 160 Counts)","rate":128,"purrate":0,"mrp":160,"qty":"27","amt":"3456.0","packqty":20},{"itemId":"3167","name":"Mahak Eclair Jar (MRP Rs. 1\/- per count) (20 Jar X 250 counts)","rate":208.33,"purrate":0,"mrp":250,"qty":"29","amt":"6041.57","packqty":20},{"itemId":"3154","name":"Mahak Jelly Belly Love Jelly Fruit Jel Jar ( MRP Rs. 10\/- per pcs)(28+2 pcs) (16 Jar x 28Pcs)","rate":215.38,"purrate":0,"mrp":280,"qty":"14","amt":"3015.32","packqty":16},{"itemId":"3189","name":"Mahak Jelly Belly Fruit Jel Mix Fruit (12 Jar x 125 Pcs) (12 Jar x 125 Pcs)","rate":208.33,"purrate":0,"mrp":250,"qty":"34","amt":"7083.22","packqty":12},{"itemId":"3744","name":"Mahak Jelly Belly Pudee Toy Jar (9JAR X 36+2 PCS)","rate":300,"purrate":0,"mrp":360,"qty":"16","amt":"4800.0","packqty":9},{"itemId":"3745","name":"Mahak Fruit Jel JB Mobile Jar (6 JarX36+3 Pcs)","rate":300,"purrate":0,"mrp":360,"qty":"5","amt":"1500.0","packqty":6},{"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":"43","amt":"11466.81","packqty":9},{"itemId":"3856","name":"Mahak Jelly Belly Armory Toy Jar Rs. 10. (6 JAR X 30+2 PCS)","rate":250,"purrate":0,"mrp":300,"qty":"39","amt":"9750.0","packqty":6},{"itemId":"3584","name":"Mahak JB Fruit Desert Box MRP 20 (16BoxX12Cup)","rate":184.62,"purrate":0,"mrp":240,"qty":"179","amt":"33046.98","packqty":16},{"itemId":"3753","name":"Mahak Jelly Belly Milk Fruit Jel Frugurt Jar (9 Jar x 70 Cups)","rate":291.67,"purrate":0,"mrp":350,"qty":"37","amt":"10791.79","packqty":9},{"itemId":"3897","name":"Mahak Jelly Belly Fruit Jel Drink (9 JarX 25 Pcs)","rate":208.33,"purrate":0,"mrp":250,"qty":"12","amt":"2499.96","packqty":9},{"itemId":"3549","name":"Mahak Milk-N-Nut Naryal Mithai Coconut Bar (MRP Rs 5 per Bar) (18 Box X 50 Bar)","rate":200,"purrate":0,"mrp":250,"qty":"15","amt":"3000.0","packqty":18},{"itemId":"3553","name":"Mahak Milk N Nut Nariyal Mithai (12 Jar X 300+3 Pcs)","rate":250,"purrate":0,"mrp":300,"qty":"19","amt":"4750.0","packqty":12},{"itemId":"3870","name":"Mahak Milk N Nut Nariyal Mithai (12JarX250+3Pcs )","rate":208.33,"purrate":0,"mrp":250,"qty":"12","amt":"2499.96","packqty":12},{"itemId":"2763","name":"Mahak Milk N Nut Naryal Mithai Coconut Box (12 Box x 36 Stick)","rate":288,"purrate":0,"mrp":360,"qty":"8","amt":"2304.0","packqty":12},{"itemId":"3883","name":"MNN Mango Bar (20Mono X 40Pcs X 15Gm) (20Mono X 40Pcs X 15Gm)","rate":160,"purrate":0,"mrp":200,"qty":"25","amt":"4000.0","packqty":20},{"itemId":"3886","name":"Mahak Milk N Nut Mango Mithai (12 Jar x 250+3 Counts)","rate":208.33,"purrate":0,"mrp":250,"qty":"5","amt":"1041.65","packqty":12}]}}]} -------------------------------------------------- 14:39:27 03 August 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:15:26 03 August 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:52 03 August 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:02:12 03 August 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:09:49 03 August 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:27:36 03 August 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:33:45 03 August 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 -------------------------------------------------- 21:23:42 03 August 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 --------------------------------------------------