{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 09:38:07","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-07-08 09:39:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 10:29:11","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 10:29:24","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"BPPI.CPOS.BAL","message":"No columns were selected","method":"","class_name":"","line_number":"","time":"2024-07-08 10:37:57","error_code":"","procedure":"","server":"","stack_trace":"at BPPI.CPOS.BAL.ReturnPolicy.ReturnPolicyRepository.d__5.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\ReturnPolicy\\ReturnPolicyRepository.cs:line 137\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.ReturnPolicyController.d__2.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\ReturnPolicyController.cs:line 60","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-07-08 10:39:31","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"BPPI.CPOS.BAL","message":"No columns were selected","method":"","class_name":"","line_number":"","time":"2024-07-08 10:57:38","error_code":"","procedure":"","server":"","stack_trace":"at BPPI.CPOS.BAL.ReturnPolicy.ReturnPolicyRepository.d__5.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\ReturnPolicy\\ReturnPolicyRepository.cs:line 137\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.ReturnPolicyController.d__2.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\ReturnPolicyController.cs:line 60","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 11:54:53","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-07-08 11:55:46","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 11:57:27","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-07-08 12:55:59","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 13:27:42","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 13:29:07","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 13:29:49","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:11:53","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:12:18","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:12:37","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:13:54","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:15:01","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:15:01","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:15:14","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Could not find stored procedure 'JHARKHAND'.","method":"","class_name":"16","line_number":"1","time":"2024-07-08 14:19:00","error_code":"2812","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2024-07-08 14:46:38","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 548\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"mscorlib","message":"Could not find a part of the path 'D:\\DavaIndia\\POSPublish\\AutoUpdater\\1.0.0.4.zip'.","method":"","class_name":"","line_number":"","time":"2024-07-08 15:04:09","error_code":"","procedure":"","server":"","stack_trace":"at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n at System.IO.File.InternalReadAllBytes(String path, Boolean checkHost)\r\n at BPPI.CPOS.API.Controllers.UploadFileController.<>c__DisplayClass8_0.b__0() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 208\r\n at System.Threading.Tasks.Task`1.InnerInvoke()\r\n at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.UploadFileController.d__8.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 202","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 15:04:14","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:40","method":"","class_name":"","line_number":"","time":"2024-07-08 15:07:26","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Procedure or function 'USP_productwise_salesReturnwihtout_tax_new' expects parameter '@dOC_PM_Id', which was not supplied.","method":"","class_name":"16","line_number":"0","time":"2024-07-08 16:26:27","error_code":"201","procedure":"USP_productwise_salesReturnwihtout_tax_new","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:09:51","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:18:48","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:39:51","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:40:29","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:43:48","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:47:06","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"The parameterized query '(@UserId INT, @PageNumber INT, @PageSize INT,@doc_date_from DATE' expects the parameter '@docd_ExpDate_to', which was not supplied.\r\n\r\n\t\tSELECT * ,\r\n\t\tCount(*)\r\n OVER() AS totalRecord\r\n\t\tFROM (\r\n\t\t SELECT\t\t\tDISTINCT --ACCNH.*\r\n\t\t\t\t\t\t\t\tstore.state AS state,\r\n\t\t\t\t\t\t\t\tstore.category AS category,\r\n\t\t\t\t\t\t\t\tstore.storeno AS storeNo,\r\n\t\t\t\t\t\t\t\tRTRIM(LTRIM(REPLACE(REPLACE(REPLACE(store.store_name, char(13), ' '), char(10), ' '),',',''))) as store_Name,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 0 THEN 'Sales Return'\r\n\t\t\t\t\t\t\t\t\twhen doc_type = 1 THEN 'Debit Note'\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 2 THEN 'Credit Note'\r\n\t\t\t\t\t\t\t\tEND\tAS returnType,\r\n\t\t\t\t\t\t\t\tdoc_type AS doc_Type,\r\n\t\t\t\t\t\t\t\taccnh.doc_date AS doc_Date,\r\n\t\t\t\t\t\t\t\t--~~~~~~~~~~~ tushar 12-01-2024 Gid.: 694\r\n\t\t\t\t\t\t\t\t--isnull(accnh.doc_pm_id,0) AS dOC_PM_Id,\r\n\t\t\t\t\t\t\t\t--isnull(patim.pm_fullname,'') AS pm_Fullname,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 1 THEN isnull(cast(accnh.DOC_Cust_Code AS varchar),'')\r\n\t\t\t\t\t\t\t\t\tELSE isnull(cast(accnh.doc_pm_id AS varchar),'')\r\n\t\t\t\t\t\t\t\tEND\tAS dOC_PM_Id,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 1 THEN isnull(cast(supplierstore.Store_Name AS varchar),'')\r\n\t\t\t\t\t\t\t\t\tELSE isnull(patim.pm_fullname,'')\r\n\t\t\t\t\t\t\t\tEND\tAS pm_Fullname,\r\n\t\t\t\t\t\t\t\t--~~~~~~~~~~~ Gid.: 694 \r\n\t\t\t\t\t\t\t\tisnull(m.mm_code,'') AS mm_code,\r\n\t\t\t\t\t\t\t\tisnull(m.mm_name ,'') AS mm_Name,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_batchno,'') AS docd_BatchNo,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_expdate,NULL) AS docd_ExpDate,\r\n\t\t\t\t\t\t\t\tisnull(m.mm_packsize,0) AS mM_PackSize,\r\n\t\t\t\t\t\t\t\t(m.mm_hsncode) AS mm_HsnCode,\r\n\t\t\t\t\t\t\t\t/* --~~~~~~~~~~~~~~~ Rahul 11-06-2024 GID:822 */\r\n\t\t\t\t\t\t\t\t--CASE\r\n\t\t\t\t\t\t\t\t-- WHEN accnh.doc_type = 0 THEN sih.sih_no\r\n\t\t\t\t\t\t\t\t-- WHEN accnh.doc_type = 1 THEN pih.pih_no\r\n\t\t\t\t\t\t\t\t-- WHEN accnh.doc_type = 2 THEN sihcredi.sih_no\r\n\t\t\t\t\t\t\t\t--END AS invoiceRefNo, \r\n\t\t\t\t\t\t\t\tCASE \r\n WHEN accnh.doc_type = 0 THEN \r\n (CASE WHEN ISNULL(sih.Sih_No_New,'') <> '' THEN sih.Sih_No_New ELSE CAST(sih.Sih_No AS VARCHAR) END) \r\n WHEN accnh.doc_type = 1 THEN \r\n (CASE \r\n WHEN ISNULL(pih.Pih_No_New,'') <> '' THEN pih.Pih_No_New \r\n ELSE CAST(pih.Pih_No AS VARCHAR) \r\n END)\r\n WHEN accnh.doc_type = 2 THEN \r\n (CASE \r\n WHEN ISNULL(sihcredi.Sih_No_New,'') <> '' THEN sihcredi.Sih_No_New \r\n ELSE CAST(sihcredi.Sih_No AS VARCHAR) \r\n END)\r\n END AS invoiceRefNo,\r\n\t\t\t\t\t\t\t\t/* --~~~~~~~~~~~~~~~ GID:822 */\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 0 THEN isnull(sid.sid_salesqty,0) + isnull(sid.sid_free_qty,0) + isnull( sid.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 1 THEN isnull(pid.pid_qty,0) + isnull(pid.pid_freeqty,0)\r\n\t\t\t\t\t\t\t\t --~~~~Start Nidhi 13/03/2024 #708\r\n\t\t\t\t\t\t\t\t --WHEN accnh.doc_type = 2 THEN isnull(sid.sid_salesqty,0) + isnull(sid.sid_free_qty,0) + isnull( sid.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 2 THEN isnull(sidcredi.sid_salesqty,0) + isnull(sidcredi.sid_free_qty,0) + isnull( sidcredi.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t\t--~~~~End Nidhi 13/03/2024 #708\r\n\r\n\t\t\t\t\t\t\t\tEND AS invoiceQty,\r\n\t\t\t\t\t\t\t\tsum(isnull(accnd.docd_qty,0) + isnull(accnd.docd_freeqty,0))\tAS returnQty,\r\n\t\t\t\t\t\t\t\tisnull (pid.pid_rate,m.mm_purrate) AS purchaserate,\r\n\t\t\t\t\t\t\t\t((accnd.Docd_Mrp - accnd.Docd_Mrp * (isnull(accnd.docd_sgst_per,0) + isnull(accnd.docd_cgst_per,0) + isnull(accnd.docd_igst_per,0) +isnull(docd_cess_per,0))/100) ) AS salesRate,\r\n\t\t\t\t\t\t\t\tisnull(accnd.Docd_Mrp,0)\tAS stk_Mrp,\r\n\t\t\t\t\t\t\t\tcast(docd_disc AS numeric(18,2))\tAS docd_Disc,\r\n\t\t\t\t\t\t\t\tcast(docd_discamount AS numeric","method":"","class_name":"16","line_number":"0","time":"2024-07-08 17:52:13","error_code":"8178","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"The parameterized query '(@UserId INT, @PageNumber INT, @PageSize INT,@doc_date_from DATE' expects the parameter '@docd_ExpDate_to', which was not supplied.\r\n\r\n\t\tSELECT * ,\r\n\t\tCount(*)\r\n OVER() AS totalRecord\r\n\t\tFROM (\r\n\t\t SELECT\t\t\tDISTINCT --ACCNH.*\r\n\t\t\t\t\t\t\t\tstore.state AS state,\r\n\t\t\t\t\t\t\t\tstore.category AS category,\r\n\t\t\t\t\t\t\t\tstore.storeno AS storeNo,\r\n\t\t\t\t\t\t\t\tRTRIM(LTRIM(REPLACE(REPLACE(REPLACE(store.store_name, char(13), ' '), char(10), ' '),',',''))) as store_Name,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 0 THEN 'Sales Return'\r\n\t\t\t\t\t\t\t\t\twhen doc_type = 1 THEN 'Debit Note'\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 2 THEN 'Credit Note'\r\n\t\t\t\t\t\t\t\tEND\tAS returnType,\r\n\t\t\t\t\t\t\t\tdoc_type AS doc_Type,\r\n\t\t\t\t\t\t\t\taccnh.doc_date AS doc_Date,\r\n\t\t\t\t\t\t\t\t--~~~~~~~~~~~ tushar 12-01-2024 Gid.: 694\r\n\t\t\t\t\t\t\t\t--isnull(accnh.doc_pm_id,0) AS dOC_PM_Id,\r\n\t\t\t\t\t\t\t\t--isnull(patim.pm_fullname,'') AS pm_Fullname,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 1 THEN isnull(cast(accnh.DOC_Cust_Code AS varchar),'')\r\n\t\t\t\t\t\t\t\t\tELSE isnull(cast(accnh.doc_pm_id AS varchar),'')\r\n\t\t\t\t\t\t\t\tEND\tAS dOC_PM_Id,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 1 THEN isnull(cast(supplierstore.Store_Name AS varchar),'')\r\n\t\t\t\t\t\t\t\t\tELSE isnull(patim.pm_fullname,'')\r\n\t\t\t\t\t\t\t\tEND\tAS pm_Fullname,\r\n\t\t\t\t\t\t\t\t--~~~~~~~~~~~ Gid.: 694 \r\n\t\t\t\t\t\t\t\tisnull(m.mm_code,'') AS mm_code,\r\n\t\t\t\t\t\t\t\tisnull(m.mm_name ,'') AS mm_Name,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_batchno,'') AS docd_BatchNo,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_expdate,NULL) AS docd_ExpDate,\r\n\t\t\t\t\t\t\t\tisnull(m.mm_packsize,0) AS mM_PackSize,\r\n\t\t\t\t\t\t\t\t(m.mm_hsncode) AS mm_HsnCode,\r\n\t\t\t\t\t\t\t\t/* --~~~~~~~~~~~~~~~ Rahul 11-06-2024 GID:822 */\r\n\t\t\t\t\t\t\t\t--CASE\r\n\t\t\t\t\t\t\t\t-- WHEN accnh.doc_type = 0 THEN sih.sih_no\r\n\t\t\t\t\t\t\t\t-- WHEN accnh.doc_type = 1 THEN pih.pih_no\r\n\t\t\t\t\t\t\t\t-- WHEN accnh.doc_type = 2 THEN sihcredi.sih_no\r\n\t\t\t\t\t\t\t\t--END AS invoiceRefNo, \r\n\t\t\t\t\t\t\t\tCASE \r\n WHEN accnh.doc_type = 0 THEN \r\n (CASE WHEN ISNULL(sih.Sih_No_New,'') <> '' THEN sih.Sih_No_New ELSE CAST(sih.Sih_No AS VARCHAR) END) \r\n WHEN accnh.doc_type = 1 THEN \r\n (CASE \r\n WHEN ISNULL(pih.Pih_No_New,'') <> '' THEN pih.Pih_No_New \r\n ELSE CAST(pih.Pih_No AS VARCHAR) \r\n END)\r\n WHEN accnh.doc_type = 2 THEN \r\n (CASE \r\n WHEN ISNULL(sihcredi.Sih_No_New,'') <> '' THEN sihcredi.Sih_No_New \r\n ELSE CAST(sihcredi.Sih_No AS VARCHAR) \r\n END)\r\n END AS invoiceRefNo,\r\n\t\t\t\t\t\t\t\t/* --~~~~~~~~~~~~~~~ GID:822 */\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 0 THEN isnull(sid.sid_salesqty,0) + isnull(sid.sid_free_qty,0) + isnull( sid.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 1 THEN isnull(pid.pid_qty,0) + isnull(pid.pid_freeqty,0)\r\n\t\t\t\t\t\t\t\t --~~~~Start Nidhi 13/03/2024 #708\r\n\t\t\t\t\t\t\t\t --WHEN accnh.doc_type = 2 THEN isnull(sid.sid_salesqty,0) + isnull(sid.sid_free_qty,0) + isnull( sid.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 2 THEN isnull(sidcredi.sid_salesqty,0) + isnull(sidcredi.sid_free_qty,0) + isnull( sidcredi.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t\t--~~~~End Nidhi 13/03/2024 #708\r\n\r\n\t\t\t\t\t\t\t\tEND AS invoiceQty,\r\n\t\t\t\t\t\t\t\tsum(isnull(accnd.docd_qty,0) + isnull(accnd.docd_freeqty,0))\tAS returnQty,\r\n\t\t\t\t\t\t\t\tisnull (pid.pid_rate,m.mm_purrate) AS purchaserate,\r\n\t\t\t\t\t\t\t\t((accnd.Docd_Mrp - accnd.Docd_Mrp * (isnull(accnd.docd_sgst_per,0) + isnull(accnd.docd_cgst_per,0) + isnull(accnd.docd_igst_per,0) +isnull(docd_cess_per,0))/100) ) AS salesRate,\r\n\t\t\t\t\t\t\t\tisnull(accnd.Docd_Mrp,0)\tAS stk_Mrp,\r\n\t\t\t\t\t\t\t\tcast(docd_disc AS numeric(18,2))\tAS docd_Disc,\r\n\t\t\t\t\t\t\t\tcast(docd_discamount AS numeric","method":"","class_name":"16","line_number":"0","time":"2024-07-08 17:52:19","error_code":"8178","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:55:33","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 17:56:53","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 18:11:51","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-07-08 18:27:42","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} ,