09:31:20 04 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:54:37 04 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:57:32 04 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:59:19 04 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:03:34 04 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 -------------------------------------------------- 13:47:02 04 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 -------------------------------------------------- 14:27:03 04 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:45:38 04 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 -------------------------------------------------- 17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass6_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 393 -------------------------------------------------- 17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() 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 15349 -------------------------------------------------- 17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass8_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 618 ------------------------------------------------17:01:17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass7_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 498 -------------------------------------------------- zI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxODMwZDY4OS0yYjE4LTRmZTYtODExYy02MTQwMWU4MzY3OTMiLCJjb21wSWQiOiIxIiwidXNlcklkIjoiMTI3MzYiLCJ0eXBlIjoiQXBwVXNlciIsInVzZXJ0eXBlIjoiMyIsImRldmljZUlkIjoiNWQ3OTRjMDQtMzBkMS00MGMyLWFkZTgtYWMyMWI4OGI4ZGRmIiwibmJmIjoxNzA1Mzc5Mjk2LCJleHAiOjIwMjA5OTg0OTYsImlzcyI6IkZpZWxkTWFnbmEifQ.v_lJhPnGkoCPHw0ZlCsvBEKXmKuMYJgG4x27Gxgxkfw -------------------------------------------------- nection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass3_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 35 -------------------------------------------------- 17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass9_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 755 -------------------------------------------------- 17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbC17:01:44 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass10_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 865 -------------------------------------------------- IsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiJmYjFlNzMzZS0wNWE3LTQ5OGEtODVlZi1kZTZjNzdjZWFkMzEiLCJjb21wSWQiOiIxIiwidXNlcklkIjoiNTg5IiwidHlwZSI6IkFwcFVzZXIiLCJ1c2VydHlwZSI6IjMiLCJkZXZpY2VJZCI6IjIxYjlhMTFlLWEzNzgtNDdmZC1iYWEyLWY4MGY4MmUxMzhhYyIsIm5iZiI6MTcxNDgzMDA3NywiZXhwIjoyMDMwMzYyODc3LCJpc3MiOiJGaWVsZE1hZ25hIn0.zltXkGVNpVsw4TQgLHo29b4OOl7E9Qc_jOQ8ryjRlRE -------------------------------------------------- 17:01:45 04 June 2024 A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) The wait operation timed out at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at AppService.Classes.Dashboard.<>c__DisplayClass7_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 498 -------------------------------------------------- - 17:05:27 04 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":"12731","companyid":"1","data":[{"id":"45ccb53e-ebfe-4338-bb28-cd5311437038","type":2,"dataid":"699c87ae-0938-41d3-a2be-a2390c855686","dataObj":{"id":"699c87ae-0938-41d3-a2be-a2390c855686","orderno":"3889","companyid":"1","orderdate":"2024-06-04","marketid":"4925","distributorid":"4cdea410-488b-452d-ad89-d15c9746a725","retailerid":"881c1f24-e0ca-4c0b-8779-9724c6c87f03","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2024-06-04 17:04:49","createdBy":"12731","status":"1","locationEnabled":1,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"55","details":[],"latitude":"19.4238695","longitude":"72.8271935","location":"Unnamed Road, Vijay Nagar, Ambawadi, Nalasopara East, Nala Sopara, Maharashtra 401209, India\n","cellInfo":{"radio":"gsm","cid":230627842,"lac":6234,"mcc":404,"mnc":90}}}]} -------------------------------------------------- 17:48:22 04 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:48:32 04 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 --------------------------------------------------