11:04:37 17 May 2025 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 -------------------------------------------------- 11:08:02 17 May 2025 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 -------------------------------------------------- 11:08:03 17 May 2025 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 -------------------------------------------------- 11:08:03 17 May 2025 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 -------------------------------------------------- 11:08:04 17 May 2025 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.module.GetProductsList(String companyid, String partyid, String syncDate, Int32 BillMode, String channelId, Object& response, SqlConnection& myconn) in E:\Dev\AppService\AppService\Classes\module.cs:line 1015 -------------------------------------------------- 11:08:04 17 May 2025 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.module.GetProductsList(String companyid, String partyid, String syncDate, Int32 BillMode, String channelId, Object& response, Sql11:08:04 17 May 2025 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__DisplayClass11_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1086 -------------------------------------------------- 11:08:04 17 May 2025 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.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 3241 {"empid":"13098","companyid":"1","data":[{"id":"03735eac-6555-4fd1-b9bc-eec1b94868ae","type":2,"dataid":"3b821de8-43ef-4c83-9402-921f2b69bd9f","dataObj":{"id":"3b821de8-43ef-4c83-9402-921f2b69bd9f","orderno":"35","companyid":"1","orderdate":"2025-05-17","marketid":"3147","distributorid":"22400d84-3b47-47b6-a992-6e18d81f6bfb","retailerid":"5a783701-3a1b-4c72-8b9d-12180dcc7446","calltype":0,"reasonid":"69d25109-7faf-4e6f-b6cc-aae16a331d6a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2025-05-17 11:07:03","createdBy":"13098","status":"1","locationEnabled":1,"latitude":28.3814544,"longitude":76.9668081,"location":"#7, D.N. Market, Rampura, NH-8, near IndianOil, Sector 78, Gurugram, Haryana 122004, India\n","gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[]}}]} -------------------------------------------------- 11:08:04 17 May 2025 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.apiservice.getdashboarddata(String compid, String empid, String type, String usertype, String dt, String stateid) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 11907 sp_employeestate -------------------------------------------------- 11:08:04 17 May 2025 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.module.GetProductsList(String companyid, String partyid, String syncDate, Int32 BillMode, String channelId, Object& response, SqlConnection& myconn) in E:\Dev\AppService\AppService\Classes\module.cs:line 1015 -------------------------------------------------- 11:08:04 17 May 2025 ExecuteScalar requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlCommand.ExecuteScalar() at AppService.module.find_cityId(String userid, String compid, SqlConnection& conn) in E:\Dev\AppService\AppService\Classes\module.cs:line 232 -------------------------------------------------- 11:08:04 17 May 2025 ExecuteReader requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.apiservice.dataSync(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 1158 -------------------------------------------------- 11:08:04 17 May 2025 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.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 3241 {"empid":"13078","companyid":"1","data":[{"id":"3728db7d-f6c5-4712-ba7f-abf46158a636","type":2,"dataid":"877256c6-29be-4fb4-afb9-3768d3b9867b","dataObj":{"id":"877256c6-29be-4fb4-afb9-3768d3b9867b","orderno":"336","companyid":"1","orderdate":"2025-05-17","marketid":"71402","distributorid":"1717369a-f6a5-48b4-b189-ddfb36446808","retailerid":"b865d9fe-c593-492b-9d5f-63100d154434","calltype":0,"reasonid":"38efb1b4-7eb6-44a0-bef4-a95f24c0068e","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2025-05-17 11:07:07","createdBy":"13078","status":"1","locationEnabled":1,"latitude":18.4599844,"longitude":74.5821309,"location":"FH6J+2R9, Shalimar Chowk, Daund, Maharashtra 413801, India\n","gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"80","details":[]}}]} -------------------------------------------------- 11:08:04 17 May 2025 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 -------------------------------------------------- 11:08:04 17 May 2025 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.apiservice.getmyteamv3(DataObj dobj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 13912 -------------------------------------------------- 11:09:35 17 May 2025 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 -------------------------------------------------- 12:06:38 17 May 2025 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 -------------------------------------------------- 12:11:37 17 May 2025 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__DisplayClass21_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 2022 -------------------------------------------------- 12:11:37 17 May 2025 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 810 -------------------------------------------------- 12:11:37 17 May 2025 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.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in E:\Dev\AppService\AppService\apiservice.svc.cs:line 2287 {"empid":"12761","companyid":"1","data":[{"id":"5cd2b082-63d2-4671-8f3b-fccd15b2a85d","type":2,"dataid":"ffbe77f3-d01a-4ed2-b9b2-3c141c86059d","dataObj":{"id":"ffbe77f3-d01a-4ed2-b9b2-3c141c86059d","orderno":"17736","companyid":"1","orderdate":"2025-05-17","marketid":"28745","distributorid":"82b842b5-1d5a-45f8-a866-9ef3035ae2c4","retailerid":"6a5fa5c3-dc02-4ad2-8339-59136ed10a10","calltype":0,"reasonid":"0fb317c3-ef0e-440d-9fe2-979e70a27052","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2025-05-17 12:10:59","createdBy":"12761","status":"1","locationEnabled":1,"latitude":21.2828289,"longitude":81.6190812,"location":"7JM9+5MJ, Nahar Rd, Chandi, Raipur, Sondongari, Chhattisgarh 492003, India\n","gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"78","details":[]}}]} -------------------------------------------------- 12:11:37 17 May 2025 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 -------------------------------------------------- 12:11:37 17 May 2025 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__DisplayClass26_0.b__0() in E:\Dev\AppService\AppService\Classes\Dashboard.cs:line 3040 -------------------------------------------------- 12:58:58 17 May 2025 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:06:16 17 May 2025 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 --------------------------------------------------