18-11-2025 05:43:26 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 18-11-2025 08:12:51 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 08:12:51 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 08:32:56 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 08:32:56 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 08:34:20 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 8 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 8 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '00000000-0000-0000-0000-000000000000', '2025-11-18 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-18 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 8 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-18 00:00:00' and r.company_id = 'e62e00b3-b87c-4827-8e79-a09bba3559df' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('e62e00b3-b87c-4827-8e79-a09bba3559df', '') and I.id = 'd7899fd3-9646-4697-8cca-44baf188d743' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 08:34:30 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 7 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 7 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2fc2e169-1253-4151-bcfb-b885ca98c277', I.id, '', '1584084b-a0f7-46f0-a7e2-acce8bd6523c', '00000000-0000-0000-0000-000000000000', '2025-11-17 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2fc2e169-1253-4151-bcfb-b885ca98c277', I.id, '', '1584084b-a0f7-46f0-a7e2-acce8bd6523c', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-17 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 7 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-17 00:00:00' and r.company_id = '2fc2e169-1253-4151-bcfb-b885ca98c277' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('2fc2e169-1253-4151-bcfb-b885ca98c277', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '49a62c0b-be0f-4014-ab80-502b8629f2b0' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 08:35:26 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 8 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 8 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '00000000-0000-0000-0000-000000000000', '2025-11-18 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-18 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 8 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-18 00:00:00' and r.company_id = 'e62e00b3-b87c-4827-8e79-a09bba3559df' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('e62e00b3-b87c-4827-8e79-a09bba3559df', '') and I.id = 'd7899fd3-9646-4697-8cca-44baf188d743' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 08:37:35 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 7 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 7 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2fc2e169-1253-4151-bcfb-b885ca98c277', I.id, '', '1584084b-a0f7-46f0-a7e2-acce8bd6523c', '00000000-0000-0000-0000-000000000000', '2025-11-17 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2fc2e169-1253-4151-bcfb-b885ca98c277', I.id, '', '1584084b-a0f7-46f0-a7e2-acce8bd6523c', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-17 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 7 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-17 00:00:00' and r.company_id = '2fc2e169-1253-4151-bcfb-b885ca98c277' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('2fc2e169-1253-4151-bcfb-b885ca98c277', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '49a62c0b-be0f-4014-ab80-502b8629f2b0' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 08:40:37 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 7 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 7 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2fc2e169-1253-4151-bcfb-b885ca98c277', I.id, '', '1584084b-a0f7-46f0-a7e2-acce8bd6523c', '00000000-0000-0000-0000-000000000000', '2025-11-17 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2fc2e169-1253-4151-bcfb-b885ca98c277', I.id, '', '1584084b-a0f7-46f0-a7e2-acce8bd6523c', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-17 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 7 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-17 00:00:00' and r.company_id = '2fc2e169-1253-4151-bcfb-b885ca98c277' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('2fc2e169-1253-4151-bcfb-b885ca98c277', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '49a62c0b-be0f-4014-ab80-502b8629f2b0' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 08:43:19 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 08:43:19 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 08:43:43 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 08:43:43 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 08:59:22 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 08:59:22 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 09:01:22 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 7 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 7 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'b7988426-383c-4e14-97a8-5e7b5c119bf7', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-17 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'b7988426-383c-4e14-97a8-5e7b5c119bf7', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-17 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 7 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-17 00:00:00' and r.company_id = 'b7988426-383c-4e14-97a8-5e7b5c119bf7' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('b7988426-383c-4e14-97a8-5e7b5c119bf7', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '2244c944-9e83-40ee-a933-cafed9c3f054' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 09:01:33 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 7 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 7 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'b7988426-383c-4e14-97a8-5e7b5c119bf7', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-17 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'b7988426-383c-4e14-97a8-5e7b5c119bf7', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-17 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 7 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-17 00:00:00' and r.company_id = 'b7988426-383c-4e14-97a8-5e7b5c119bf7' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('b7988426-383c-4e14-97a8-5e7b5c119bf7', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '4f3ff5ab-a3a4-4be9-b125-6c5258d9f282' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 09:03:12 ## Exception ## FUNCTION maindb001.GetStockValuation does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, I.Name as item_name, I.code as item_code, I.barcode as item_barcode, I.Separate_pack_unit as pack_unit_applicable, I.pack_unit_id, pack_unit.Name as pack_unit_name, I.stock_vs_pack, I.stock_unit_id, stock_unit.Name as stock_unit_name, I.gpack_unit_id, gpack_unit.Name as gpack_unit_name, I.pack_vs_gpack, I.serial_tracking, I.print_barcode, I.batch_wise_inventory, I.batch_wise_rate, I.group_id, mst_item_group.name as group_name, I.sub_item_applicable, I.rate_per, I.rate_per_purchase, mst_rate.master_id as rate_master_id, i.garment_item_type, i.vat_tax_id, mst_tax_code.rate as vat_tax_rate, (Case when 7 = 7 then I.sales_description else I.purchase_description end) as print_description, i.ask_udf_in_document, i.minimum_level, mst_gst_classification.name as hsn_code, I.udf1, I.udf2, I.udf3, I.udf4, I.udf5, I.markup_percentage, I.wholesales_markup_per, I.dealer_markup_per, I.item_mode, I.input_dimension, I.metal_purity, I.salesman_id, mst_brand.salesman_id as brand_salesman_id, I.sales_rate, i.einvoice_description, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (case when 7 = 7 then I.sales_warranty_months else I.purchase_warranty_months end) as warranty_months, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'b7988426-383c-4e14-97a8-5e7b5c119bf7', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-17 00:00:00') as item_balance, GetStockValuation('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'b7988426-383c-4e14-97a8-5e7b5c119bf7', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2017-01-01', '2025-11-17 00:00:00', 0, 0) as StockValuation, (Case when mst_jobwork_rate.id is null then(case when 7 = 7 then mst_process.sales_rate else mst_process.purchase_rate end) else mst_jobwork_rate.rate end) as process_rate, stock_unit.decimal_digit as stock_unit_decimal_digit, pack_unit.decimal_digit as pack_unit_decimal_digit, gpack_unit.decimal_digit as gpack_unit_decimal_digit From mst_item I LEFT OUTER JOIN mst_item_unit pack_unit ON pack_unit.ID = I.pack_unit_id LEFT OUTER JOIN mst_item_unit gpack_unit ON gpack_unit.ID = I.gpack_unit_id LEFT OUTER JOIN mst_item_unit stock_unit ON stock_unit.ID = I.stock_unit_id LEFT OUTER JOIN mst_item_group on mst_item_group.id = I.group_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = I.gst_classification_id LEFT OUTER JOIN mst_brand ON mst_brand.id = I.brand_id LEFT OUTER JOIN mst_tax_code on mst_tax_code.id = I.vat_tax_id LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2025-11-17 00:00:00' and r.company_id = 'b7988426-383c-4e14-97a8-5e7b5c119bf7' order by branch_id desc, effective_from desc limit 1) LEFT OUTER JOIN mst_item mst_process on mst_process.id = '' LEFT OUTER JOIN mst_jobwork_rate on (mst_jobwork_rate.finish_item_id = I.id and mst_jobwork_rate.process_id = mst_process.id) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('b7988426-383c-4e14-97a8-5e7b5c119bf7', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '2244c944-9e83-40ee-a933-cafed9c3f054' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuation does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 09:03:48 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 09:03:48 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 09:05:44 ## Exception ## Unable to connect to the remote server ## FABUtilityService.DeleteFileOnFTP ## ## FTP File Delete Error **** Unable to connect to the remote server 18-11-2025 09:06:25 ## Exception ## Unable to connect to the remote server ## FABUtilityService.DeleteFileOnFTP ## ## FTP File Delete Error **** Unable to connect to the remote server 18-11-2025 09:07:14 ## Exception ## Unable to connect to the remote server ## FABUtilityService.DeleteFileOnFTP ## ## FTP File Delete Error **** Unable to connect to the remote server 18-11-2025 09:07:40 ## Exception ## Unable to connect to the remote server ## FABUtilityService.DeleteFileOnFTP ## ## FTP File Delete Error **** Unable to connect to the remote server 18-11-2025 09:13:48 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 09:13:48 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_desktop, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 09:22:34 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 09:22:34 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 09:23:25 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 09:23:25 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 09:31:00 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 09:31:00 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 10:03:14 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 10:03:14 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 10:29:40 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 10:29:40 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 10:41:58 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 10:41:58 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 10:55:17 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 10:55:17 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 11:01:56 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 11:01:56 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 11:25:51 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2025-11-13 00:00:00' and r.company_id = 'fdc8f563-1978-412f-b2a6-89ffba4cffbb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('fdc8f563-1978-412f-b2a6-89ffba4cffbb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '88dd00ce-96d1-4e4e-8497-08c1bd23b080' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 11:29:35 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2025-11-13 00:00:00' and r.company_id = 'fdc8f563-1978-412f-b2a6-89ffba4cffbb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('fdc8f563-1978-412f-b2a6-89ffba4cffbb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '88dd00ce-96d1-4e4e-8497-08c1bd23b080' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 11:36:54 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2025-11-13 00:00:00' and r.company_id = 'fdc8f563-1978-412f-b2a6-89ffba4cffbb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('fdc8f563-1978-412f-b2a6-89ffba4cffbb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '88dd00ce-96d1-4e4e-8497-08c1bd23b080' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 14:11:27 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 14:11:27 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 14:55:20 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set mob_log_count = ifnull(mob_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set mob_log_count = ifnull(mob_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Mobile 18-11-2025 14:55:20 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_mobile, 0) <> 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 14:58:19 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 14:58:19 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 14:59:04 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set mob_log_count = ifnull(mob_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set mob_log_count = ifnull(mob_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Mobile 18-11-2025 14:59:04 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_mobile, 0) <> 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 15:01:45 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'fdc8f563-1978-412f-b2a6-89ffba4cffbb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-13 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2025-11-13 00:00:00' and r.company_id = 'fdc8f563-1978-412f-b2a6-89ffba4cffbb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('fdc8f563-1978-412f-b2a6-89ffba4cffbb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '88dd00ce-96d1-4e4e-8497-08c1bd23b080' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 18-11-2025 20:09:36 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set mob_log_count = ifnull(mob_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set mob_log_count = ifnull(mob_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Mobile 18-11-2025 20:09:36 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_mobile, 0) <> 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 22:15:18 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 18-11-2025 22:15:18 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 18-11-2025 22:25:17 ## Exception ## Table 'support.crmtrn_training_detail' doesn't exist ## DataAccess.GetData ## ## GetMisc Select seq, title, description, hindi_link, english_link, updated_at from ab_video_link UNION ALL select 0 as seq, '' as title, remark as description, training_url as hindi_link, training_url as english_link, dated as updated_at from support.crmtrn_training_detail trn where trn.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(training_url,'')<>'' order by seq, updated_at Inner Exception: NULL Error: Table 'support.crmtrn_training_detail' doesn't exist Source: MySql.Data