19-05-2023 11:14:56 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 11:14:56 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 11:14:56 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 11:14:56 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 12:07:13 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:07:13', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69230.69, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.08, 10560.61, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.614, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:07:13', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69230.69, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.08, 10560.61, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.614, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 19-05-2023 12:09:07 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:09:07', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:09:07', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 19-05-2023 12:09:24 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:09:24', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:09:24', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 19-05-2023 12:09:34 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:09:34', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:09:34', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 19-05-2023 12:16:31 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:16:31', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 12:16:31', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 19-05-2023 13:22:30 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 13:22:30', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-19 13:22:30', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 19-05-2023 15:43:01 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 15:43:01 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 15:43:01 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 15:43:01 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 19:44:44 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 19:44:44 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 19:44:44 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 19:44:44 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:21:06 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 20:21:06 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 20:21:06 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 20:21:06 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:37:20 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 20:37:20 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 20:37:20 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 20:37:20 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:50:04 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 20:50:04 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 20:50:04 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 20:50:04 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:50:37 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 20:50:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 20:50:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 20:50:37 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:51:37 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 20:51:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 20:51:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 20:51:37 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:53:08 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 20:53:08 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 20:53:08 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 20:53:08 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 21:16:23 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 21:16:23 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 21:16:23 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 21:16:23 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 19-05-2023 21:22:59 ## Exception ## Table 'support.support_ticket' doesn't exist ## DataAccess.GetData ## ## GetEnterpriseInfoInSupportTicket Select phone_no, first_name, (select manager_id from support.support_ticket where enterprise_id = ent_enterprise.id and manager_id is not null and status in (0,2,5,6,9,10) order by updated_at desc limit 1) as suggested_manager_id from ent_enterprise where id = '6700a7e5-5008-4d8c-9671-26fe90448bce' Inner Exception: NULL Source: MySql.Data 19-05-2023 21:22:59 ## Error ## ## DataAccess.GetData ## ## GetSupportTicketNumber Unable to connect to data base 19-05-2023 21:22:59 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 21:22:59 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 21:22:59 ## Error ## ## DataAccess.SetData ## ## Error 19-05-2023 21:24:26 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 21:24:26 ## Error ## ## DataAccess.GetData ## ## GetSupportRegister Unable to connect to data base 19-05-2023 21:24:31 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 21:24:31 ## Error ## ## DataAccess.GetData ## ## GetSupportRegister Unable to connect to data base 19-05-2023 22:05:19 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 19-05-2023 22:05:19 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 19-05-2023 22:05:19 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 19-05-2023 22:05:19 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base