{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-27 00:32:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 01:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 02:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 03:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 04:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 05:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 06:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 07:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 08:38:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 09:38:54","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-05-27 09:45:16","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-05-27 09:45:48","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"jsonrpc": "2.0", "id": null, "result": {"id": 22067, "store_code": "MDLCEN3538", "status": "True", "message": "Update Successfully."}} , {"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-05-27 11:15:47","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-05-27 11:16:34","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 12:13:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 12:14:29","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 12:16:51","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 12:17:22","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 12:18:14","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 12:25:21","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"jsonrpc": "2.0", "id": null, "result": {"id": 22068, "store_code": "MDLCEN3539", "status": "True", "message": "Update Successfully."}} , {"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-05-27 12:43:34","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-05-27 13:03:35","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-05-27 13:17:12","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 13:17:28","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 13:18:06","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-05-27 14:01:18","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-05-27 14:15:21","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-05-27 14:18:36","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-05-27 14:35:02","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-05-27 14:57:00","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-05-27 15:18:04","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-05-27 15:34:43","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-05-27 15:39:09","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-05-27 15:58:54","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":"Incorrect syntax near 'BYmm_IsActive'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 15:59:42","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_IsActive'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 15:59:46","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_IsActive'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 15:59:49","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_IsActive'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:00:06","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_PurRate'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:00:10","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_SaleRate'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:00:12","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_HsnCode'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:00:13","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_Name'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:00:15","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_Code'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:00:17","error_code":"102","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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-27 16:18:04","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":"Incorrect syntax near 'BYmm_Name'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:01","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_HsnCode'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:02","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_SaleRate'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:04","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_HsnCode'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:06","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_SaleRate'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:07","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYmm_Name'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:08","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYid'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:13","error_code":"102","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":".Net SqlClient Data Provider","message":"Incorrect syntax near 'BYid'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"23","time":"2024-05-27 16:32:15","error_code":"102","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":".Net SqlClient Data Provider","message":"Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.","method":"","class_name":"13","line_number":"372","time":"2024-05-27 17:15:16","error_code":"1205","procedure":"Sync_StoreMaster_XML","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__18`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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.d__5.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 74\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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 37\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.SyncController.d__10.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\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.SyncController.d__2.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 26","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-05-27 17:18:04","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 17:40:59","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-05-27 17:50:50","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":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 17:54:23","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 17:54:57","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 17:56:59","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 17:58:21","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 18:00:53","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 18:03:51","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"\r\n\r\n \r\n An asynchronous module or handler completed while an asynchronous operation was still pending.\r\n \r\n \r\n \r\n\r\n \r\n\r\n

Server Error in '/' Application.

\r\n\r\n

An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n \r\n\r\n Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\n

\r\n\r\n Exception Details: System.InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.

\r\n\r\n Source Error:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. \r\n\r\n
\r\n\r\n
\r\n\r\n Stack Trace:

\r\n\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n[InvalidOperationException: An asynchronous module or handler completed while an asynchronous operation was still pending.]\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4320.0\r\n\r\n
\r\n\r\n \r\n\r\n","method":"","class_name":"","line_number":"","time":"2024-05-27 18:07:59","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 18:18:04","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-05-27 18:43: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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-27 18:45:40","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-05-27 18:46:25","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":"@posSyncStatus is not a parameter for procedure Filter_POSGRNReference_Report.","method":"","class_name":"16","line_number":"0","time":"2024-05-27 18:57:42","error_code":"8145","procedure":"Filter_POSGRNReference_Report","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":"@posSyncStatus is not a parameter for procedure Filter_POSGRNReference_Report.","method":"","class_name":"16","line_number":"0","time":"2024-05-27 18:57:50","error_code":"8145","procedure":"Filter_POSGRNReference_Report","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":"@posSyncStatus is not a parameter for procedure Filter_POSGRNReference_Report.","method":"","class_name":"16","line_number":"0","time":"2024-05-27 19:02:53","error_code":"8145","procedure":"Filter_POSGRNReference_Report","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":"@posSyncStatus is not a parameter for procedure Filter_POSGRNReference_Report.","method":"","class_name":"16","line_number":"0","time":"2024-05-27 19:05:16","error_code":"8145","procedure":"Filter_POSGRNReference_Report","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 column name 'Pih_CreatedDt'.\r\nInvalid column name 'Pih_CreatedDt'.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\tPI.Pih_vendor_code,SI.Sih_Store_Code,S.Store_Name,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_No,\r\n\t\t\t\t\t\t\t\t\t--CONVERT(VARCHAR(30)CAST(SI.Sih_Date AS date) AS Sih_Date,\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t \tSI.Sih_CreatedDate AS Sih_Date,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_DiscAmount,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_SubTotal,\r\n\t\t\t\t\t\t\t\t SumSih_SubTotal = CAST(SUM(ISNULL(SI.Sih_SubTotal,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t SumSih_Total = CAST(SUM(ISNULL(SI.Sih_Total,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t\tSI.Sih_Total_Tax, SI.Sih_Total,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN (CAST(ISNULL(Sih_LastUpdated,GETDATE())AS DATE)>= (SELECT\ttop 1 SyncDate \tFROM\tSyncLog (NOLOCK) WHERE\tSyncId = 2 \tORDER BY\tSyncDate DESC )) THEN 'No' ELSE 'Yes' END AS PosSyncStatus, \r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(PI.Pih_No,0)=0 THEN 'Pending' ELSE 'Done' END AS PosInStatus,\r\n\t\t\t\t\t\t\t\t\tPI.Pih_No,PI.Pih_CreatedDt AS Pih_Date,\r\n\t\t\t\t\t\t\t\t\tPI.Pih_DiscAmt,PI.Pih_GrossValue,PI.TaxAmount,PI.Pih_NetValue,\r\n\t\t\t\t\t\t\t\t\tSumPih_GrossValue = CAST(SUM(ISNULL(PI.Pih_GrossValue,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t SumPih_NetValue = CAST(SUM(ISNULL(PI.Pih_NetValue,0)) OVER() AS DECIMAL)\r\n\t\t\t\t\t\t\t\t\tFROM vwSalesInvoiceHeader (nolock) SI \r\n\t\t\t\t\t\t\t\t\tLEFT JOIN PurchaseInvoiceHeader_POS (NOLOCK) PI ON SI.Sih_No_New=PI.pih_Refno\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Store_Detail(NOLOCK) S on S.StoreNo=SI.Sih_Store_Code\r\n\t\t\t\t\t\t\t\t\t\t\t) AS A \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE 1=1 AND CONVERT(DATE,Sih_Date,103) BETWEEN CONVERT(DATE,@sih_Date_from,103) AND CONVERT(DATE,@sih_Date_to,103) AND Pih_CreatedDt BETWEEN CONVERT(DATE,@pih_Date_from,103) AND CONVERT(DATE,@pih_Date_to,103) ORDER BY Sih_Date desc, Sih_No DESC \r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"16","line_number":"30","time":"2024-05-27 19:05:42","error_code":"207","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 column name 'Pih_CreatedDt'.\r\nInvalid column name 'Pih_CreatedDt'.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\tPI.Pih_vendor_code,SI.Sih_Store_Code,S.Store_Name,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_No,\r\n\t\t\t\t\t\t\t\t\t--CONVERT(VARCHAR(30)CAST(SI.Sih_Date AS date) AS Sih_Date,\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t \tSI.Sih_CreatedDate AS Sih_Date,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_DiscAmount,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_SubTotal,\r\n\t\t\t\t\t\t\t\t SumSih_SubTotal = CAST(SUM(ISNULL(SI.Sih_SubTotal,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t SumSih_Total = CAST(SUM(ISNULL(SI.Sih_Total,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t\tSI.Sih_Total_Tax, SI.Sih_Total,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN (CAST(ISNULL(Sih_LastUpdated,GETDATE())AS DATE)>= (SELECT\ttop 1 SyncDate \tFROM\tSyncLog (NOLOCK) WHERE\tSyncId = 2 \tORDER BY\tSyncDate DESC )) THEN 'No' ELSE 'Yes' END AS PosSyncStatus, \r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(PI.Pih_No,0)=0 THEN 'Pending' ELSE 'Done' END AS PosInStatus,\r\n\t\t\t\t\t\t\t\t\tPI.Pih_No,PI.Pih_CreatedDt AS Pih_Date,\r\n\t\t\t\t\t\t\t\t\tPI.Pih_DiscAmt,PI.Pih_GrossValue,PI.TaxAmount,PI.Pih_NetValue,\r\n\t\t\t\t\t\t\t\t\tSumPih_GrossValue = CAST(SUM(ISNULL(PI.Pih_GrossValue,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t SumPih_NetValue = CAST(SUM(ISNULL(PI.Pih_NetValue,0)) OVER() AS DECIMAL)\r\n\t\t\t\t\t\t\t\t\tFROM vwSalesInvoiceHeader (nolock) SI \r\n\t\t\t\t\t\t\t\t\tLEFT JOIN PurchaseInvoiceHeader_POS (NOLOCK) PI ON SI.Sih_No_New=PI.pih_Refno\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Store_Detail(NOLOCK) S on S.StoreNo=SI.Sih_Store_Code\r\n\t\t\t\t\t\t\t\t\t\t\t) AS A \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE 1=1 AND CONVERT(DATE,Sih_Date,103) BETWEEN CONVERT(DATE,@sih_Date_from,103) AND CONVERT(DATE,@sih_Date_to,103) AND Pih_CreatedDt BETWEEN CONVERT(DATE,@pih_Date_from,103) AND CONVERT(DATE,@pih_Date_to,103) ORDER BY Sih_Date desc, Sih_No DESC \r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"16","line_number":"30","time":"2024-05-27 19:05:52","error_code":"207","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 column name 'Pih_CreatedDt'.\r\nInvalid column name 'Pih_CreatedDt'.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\tPI.Pih_vendor_code,SI.Sih_Store_Code,S.Store_Name,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_No,\r\n\t\t\t\t\t\t\t\t\t--CONVERT(VARCHAR(30)CAST(SI.Sih_Date AS date) AS Sih_Date,\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t \tSI.Sih_CreatedDate AS Sih_Date,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_DiscAmount,\r\n\t\t\t\t\t\t\t\t\tSI.Sih_SubTotal,\r\n\t\t\t\t\t\t\t\t SumSih_SubTotal = CAST(SUM(ISNULL(SI.Sih_SubTotal,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t SumSih_Total = CAST(SUM(ISNULL(SI.Sih_Total,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t\tSI.Sih_Total_Tax, SI.Sih_Total,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN (CAST(ISNULL(Sih_LastUpdated,GETDATE())AS DATE)>= (SELECT\ttop 1 SyncDate \tFROM\tSyncLog (NOLOCK) WHERE\tSyncId = 2 \tORDER BY\tSyncDate DESC )) THEN 'No' ELSE 'Yes' END AS PosSyncStatus, \r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(PI.Pih_No,0)=0 THEN 'Pending' ELSE 'Done' END AS PosInStatus,\r\n\t\t\t\t\t\t\t\t\tPI.Pih_No,PI.Pih_CreatedDt AS Pih_Date,\r\n\t\t\t\t\t\t\t\t\tPI.Pih_DiscAmt,PI.Pih_GrossValue,PI.TaxAmount,PI.Pih_NetValue,\r\n\t\t\t\t\t\t\t\t\tSumPih_GrossValue = CAST(SUM(ISNULL(PI.Pih_GrossValue,0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t SumPih_NetValue = CAST(SUM(ISNULL(PI.Pih_NetValue,0)) OVER() AS DECIMAL)\r\n\t\t\t\t\t\t\t\t\tFROM vwSalesInvoiceHeader (nolock) SI \r\n\t\t\t\t\t\t\t\t\tLEFT JOIN PurchaseInvoiceHeader_POS (NOLOCK) PI ON SI.Sih_No_New=PI.pih_Refno\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Store_Detail(NOLOCK) S on S.StoreNo=SI.Sih_Store_Code\r\n\t\t\t\t\t\t\t\t\t\t\t) AS A \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE 1=1 AND CONVERT(DATE,Sih_Date,103) BETWEEN CONVERT(DATE,@sih_Date_from,103) AND CONVERT(DATE,@sih_Date_to,103) AND Pih_CreatedDt BETWEEN CONVERT(DATE,@pih_Date_from,103) AND CONVERT(DATE,@pih_Date_to,103) ORDER BY Sih_Date desc, Sih_No DESC \r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"16","line_number":"30","time":"2024-05-27 19:08:36","error_code":"207","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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-27 19:18:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 20:18:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 21:18:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 22:18:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-05-27 23:18:11","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} ,