09:38:44 18 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:48:44 18 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:09:02 18 July 2024 Error converting data type nvarchar 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 -------------------------------------------------- 10:30:43 18 July 2024 Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at AppService.apiservice.getdashboarddata(String compid, String empid, String type, String usertype, String dt, String stateid) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 11933 -------------------------------------------------- 14:14:04 18 July 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":"4159","companyid":"1","data":[{"id":"ed4dd5cc-0210-41ac-b8be-e3a99dc2553a","type":2,"dataid":"795080c8-905f-453b-8ad8-989ae1e14476","dataObj":{"id":"795080c8-905f-453b-8ad8-989ae1e14476","orderno":"7989","companyid":"1","orderdate":"2024-07-18","marketid":"1496","distributorid":"ef741e68-0198-4d36-b780-9ce1c10b53ef","retailerid":"39ff0c33-ae6d-4cf0-871d-ddd9ebd79653","calltype":0,"reasonid":"1f382d63-1e87-4251-adea-269dce252c13","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2024-07-18 14:13:15","createdBy":"4159","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"74","details":[],"latitude":"28.3579348","longitude":"79.4036815","location":"9C53+5GW, Mohalla Jasoli, Bareilly, Uttar Pradesh 243003, India\n","cellInfo":{"radio":"gsm","cid":23902466,"lac":3703,"mcc":404,"mnc":97}}}]} -------------------------------------------------- 14:14:04 18 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.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass8_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 698 -------------------------------------------------- 16:33:48 18 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 -------------------------------------------------- 20:04:06 18 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 --------------------------------------------------