{"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-08-04 14:19:45","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.<GetStoreStatus>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-08-04 14:20:24","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-08-04 15:20:49","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-08-04 16:21:20","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-08-04 17:21:48","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-08-04 18:22:20","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-08-04 19:22:48","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-08-04 20:23:20","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 column name 'returnType'.\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 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(18,2)) AS docd_DiscAmount,\r\n\t\t\t\t\t\t\t\t(accnd.docd_subtota","method":"","class_name":"16","line_number":"200","time":"2024-08-04 20:27:02","error_code":"207","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>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.<ExecuteReportData>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.<GetReportConfiguration>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 'returnType'.\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 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(18,2)) AS docd_DiscAmount,\r\n\t\t\t\t\t\t\t\t(accnd.docd_subtota","method":"","class_name":"16","line_number":"200","time":"2024-08-04 20:29:05","error_code":"207","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>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.<ExecuteReportData>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.<GetReportConfiguration>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}
,