[IMP] Import start
[IMP] Import type - Excel file
[IMP] Import from - D:\文档\工作簿1.xlsx
[IMP] Import data [t_ebc_prod_instr]
[ERR] ERROR: duplicate key value violates unique constraint "tmas_t_ebc_prod_instr_pk"
DETAIL: Key (epi_id)=(A342B10893BA4D5999E58091AE0A2026) already exists.
[ERR] INSERT INTO "tmas"."t_ebc_prod_instr" ("epi_id", "inv_organization_code", "prod_instr_no", "item_code", "item_name", "prod_model_code", "service_item_flag", "sku_number", "vendor_code", "mfg_site_code", "bom_version", "wip_class_code", "ppo_type_code", "order_category", "order_type", "inhouse_flag", "feed_mode", "bs_mode", "kit_relation_flag", "material_fullset_flag", "engineer_fullset_flag", "release_time", "plan_start_time", "plan_online_time", "plan_end_time", "actual_start_time", "actual_online_time", "actual_end_time", "bom_extact_time", "first_issue_date", "close_time", "cancel_time", "start_qty", "mrp_net_qty", "completed_qty", "scrapped_qty", "qty_uom", "completion_subinventory_name", "completion_locator_code", "released_by", "board_type", "routing", "routing_version", "factory_code", "eco", "eca", "inbound_complete_flag", "all_complete_flag", "open_qty", "write_off_reserved_qty", "net_supply_qty", "customer_bg_code", "auto_pr_flag", "ppo_status_code", "ppo_progress_code", "bs_po_number", "ppo_demand_number", "ppo_demand_plan_id", "manufacture_mode", "supply_mode", "prod_lifecycle", "supply_center_id", "supply_center_code", "demand_type_code", "source_bill_type", "source_bill_number", "original_bill_type", "original_bill_number", "prod_fulfillment", "prod_category", "responsible_department", "auto_routing_flag", "price_check_flag", "fullset_check_flag", "auto_bom_flag", "auto_inbound_flag", "allow_over_send_flag", "allow_over_recv_flag", "auto_schedule_flag", "bonded_flag", "oversea_flag", "manufacturer_category", "temporary_technology_flag", "verification_flag", "description", "log_msg", "version_number", "version_date", "created_by", "creation_date", "last_updated_by", "last_updated_date", "is_delete", "delete_by", "delete_date", "mfg_stage_type1", "mfg_stage_type2", "mfg_stage_type3", "data_from", "mixed_with_board_flag", "reference_flag", "plan_user", "no_used_qty", "item_class", "net_quantity", "bjitem_flag", "entity_type_name", "entity_subtype_name", "mfg_site_name", "is_model", "created_by_type", "source_service_name", "inventory_org_id", "hwip_release_time", "is_lock", "tmas_release_by", "tmas_release_time", "prod_instr_id", "start_qty_first", "plan_start_time_first", "workorder_plan_online_time", "workorder_plan_end_time", "po_writeoff_finished", "all_issue_flag", "revision_control_code", "eco_num") VALUES ('A342B10893BA4D5999E58091AE0A2026', 'DG1', 'DPZHT59G034', '51098HQW-001', '智能手机-Lamarr-AL00CK-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*1/中式旅充*1-直板-釉金', 'Lamarr-AL00CK', 'N', '51098HQW', '021356', '021356_T', NULL, 'T1ZZ', NULL, NULL, NULL, 'Y', 'CS', NULL, 'N', NULL, NULL, to_timestamp('0001-01-01 12:14:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, NULL, to_timestamp('0001-01-01 23:56:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, NULL, 1500, 1500, 1450, 0, 'PCS', NULL, NULL, 'l00468209', NULL, '500354607', NULL, 'JUXIN', NULL, NULL, NULL, NULL, 50, 0, 50, NULL, NULL, '2', '4', NULL, 'cPlan20250916S01X4', '20250916', 'EMS', 'STO', 'Pilot', 'SZ', NULL, '排产需求-标准', 'PPO-Require', 'cPlan20250916S01X4', NULL, '51098HQW-001021356_T2534489', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '智能手机-Lamarr-AL00CK-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*1/中式旅充*1-直板-釉金', NULL, NULL, NULL, 'q00612034', to_timestamp('0001-01-01 11:36:00', 'YYYY-MM-DD HH24:MI:SS'), 'l00468209', to_timestamp('0001-01-01 10:30:00', 'YYYY-MM-DD HH24:MI:SS'), 0, NULL, NULL, '量产', NULL, NULL, 'PPO', 'N', 'N', 'l00468209', 50, 'FG', '1500', 'N', '标准', '正常生产', NULL, 'Y', NULL, NULL, '85443', to_timestamp('0001-01-01 12:15:11', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'l00468209', to_timestamp('0001-01-01 12:14:32.573856', 'YYYY-MM-DD HH24:MI:SS.US'), '1127773644154404864', 1500, to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM
[ERR] ERROR: duplicate key value violates unique constraint "tmas_t_ebc_prod_instr_pk"
DETAIL: Key (epi_id)=(A0DEEB7053FC4D11884417D0D796352A) already exists.
[ERR] INSERT INTO "tmas"."t_ebc_prod_instr" ("epi_id", "inv_organization_code", "prod_instr_no", "item_code", "item_name", "prod_model_code", "service_item_flag", "sku_number", "vendor_code", "mfg_site_code", "bom_version", "wip_class_code", "ppo_type_code", "order_category", "order_type", "inhouse_flag", "feed_mode", "bs_mode", "kit_relation_flag", "material_fullset_flag", "engineer_fullset_flag", "release_time", "plan_start_time", "plan_online_time", "plan_end_time", "actual_start_time", "actual_online_time", "actual_end_time", "bom_extact_time", "first_issue_date", "close_time", "cancel_time", "start_qty", "mrp_net_qty", "completed_qty", "scrapped_qty", "qty_uom", "completion_subinventory_name", "completion_locator_code", "released_by", "board_type", "routing", "routing_version", "factory_code", "eco", "eca", "inbound_complete_flag", "all_complete_flag", "open_qty", "write_off_reserved_qty", "net_supply_qty", "customer_bg_code", "auto_pr_flag", "ppo_status_code", "ppo_progress_code", "bs_po_number", "ppo_demand_number", "ppo_demand_plan_id", "manufacture_mode", "supply_mode", "prod_lifecycle", "supply_center_id", "supply_center_code", "demand_type_code", "source_bill_type", "source_bill_number", "original_bill_type", "original_bill_number", "prod_fulfillment", "prod_category", "responsible_department", "auto_routing_flag", "price_check_flag", "fullset_check_flag", "auto_bom_flag", "auto_inbound_flag", "allow_over_send_flag", "allow_over_recv_flag", "auto_schedule_flag", "bonded_flag", "oversea_flag", "manufacturer_category", "temporary_technology_flag", "verification_flag", "description", "log_msg", "version_number", "version_date", "created_by", "creation_date", "last_updated_by", "last_updated_date", "is_delete", "delete_by", "delete_date", "mfg_stage_type1", "mfg_stage_type2", "mfg_stage_type3", "data_from", "mixed_with_board_flag", "reference_flag", "plan_user", "no_used_qty", "item_class", "net_quantity", "bjitem_flag", "entity_type_name", "entity_subtype_name", "mfg_site_name", "is_model", "created_by_type", "source_service_name", "inventory_org_id", "hwip_release_time", "is_lock", "tmas_release_by", "tmas_release_time", "prod_instr_id", "start_qty_first", "plan_start_time_first", "workorder_plan_online_time", "workorder_plan_end_time", "po_writeoff_finished", "all_issue_flag", "revision_control_code", "eco_num") VALUES ('A0DEEB7053FC4D11884417D0D796352A', 'DG1', 'DPZHT5920MZ', '51098JNP-001', '智能手机-Lem-AL50C-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*2/中式旅充*1-折叠-大溪地灰', 'Lem-AL50C', 'N', '51098JNP', '021356', '021356_T', NULL, 'T1ZZ', NULL, NULL, NULL, 'Y', 'CS', NULL, 'N', NULL, NULL, to_timestamp('0001-01-01 16:03:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000, 1000, 0, 0, 'PCS', NULL, NULL, 'c84372025', NULL, '950599630', NULL, 'JUXIN', NULL, NULL, NULL, NULL, 1000, 0, 1000, NULL, NULL, '2', '3', NULL, 'cPlan20250902S03V8', '20250902', 'EMS', 'STO', 'Develop', 'SZ', 'SCCN0002', '排产需求-标准', 'PPO-Require', 'cPlan20250902S03V8', NULL, '51098JNP-001021356_T2490661', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '智能手机-Lem-AL50C-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*2/中式旅充*1-折叠-大溪地灰', NULL, NULL, NULL, 'd00837601', to_timestamp('0001-01-01 21:12:00', 'YYYY-MM-DD HH24:MI:SS'), 'c84372025', to_timestamp('0001-01-01 15:11:00', 'YYYY-MM-DD HH24:MI:SS'), 0, NULL, NULL, '量产', NULL, NULL, 'PPO', 'N', 'N', 'c84372025', 1000, 'FG', '1000', 'N', '标准', '正常生产', NULL, 'Y', NULL, NULL, '85443', to_timestamp('0001-01-01 16:03:56', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'c84372025', to_timestamp('0001-01-01 16:03:49.262737', 'YYYY-MM-DD HH24:MI:SS.US'), '1122845044082274304', 1000, to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'N', '1', '[],[],[P_17202465;0
[ERR] ERROR: duplicate key value violates unique constraint "tmas_t_ebc_prod_instr_pk"
DETAIL: Key (epi_id)=(4EF4E63DFC9348F092D9A5D28AC55A9F) already exists.
[ERR] INSERT INTO "tmas"."t_ebc_prod_instr" ("epi_id", "inv_organization_code", "prod_instr_no", "item_code", "item_name", "prod_model_code", "service_item_flag", "sku_number", "vendor_code", "mfg_site_code", "bom_version", "wip_class_code", "ppo_type_code", "order_category", "order_type", "inhouse_flag", "feed_mode", "bs_mode", "kit_relation_flag", "material_fullset_flag", "engineer_fullset_flag", "release_time", "plan_start_time", "plan_online_time", "plan_end_time", "actual_start_time", "actual_online_time", "actual_end_time", "bom_extact_time", "first_issue_date", "close_time", "cancel_time", "start_qty", "mrp_net_qty", "completed_qty", "scrapped_qty", "qty_uom", "completion_subinventory_name", "completion_locator_code", "released_by", "board_type", "routing", "routing_version", "factory_code", "eco", "eca", "inbound_complete_flag", "all_complete_flag", "open_qty", "write_off_reserved_qty", "net_supply_qty", "customer_bg_code", "auto_pr_flag", "ppo_status_code", "ppo_progress_code", "bs_po_number", "ppo_demand_number", "ppo_demand_plan_id", "manufacture_mode", "supply_mode", "prod_lifecycle", "supply_center_id", "supply_center_code", "demand_type_code", "source_bill_type", "source_bill_number", "original_bill_type", "original_bill_number", "prod_fulfillment", "prod_category", "responsible_department", "auto_routing_flag", "price_check_flag", "fullset_check_flag", "auto_bom_flag", "auto_inbound_flag", "allow_over_send_flag", "allow_over_recv_flag", "auto_schedule_flag", "bonded_flag", "oversea_flag", "manufacturer_category", "temporary_technology_flag", "verification_flag", "description", "log_msg", "version_number", "version_date", "created_by", "creation_date", "last_updated_by", "last_updated_date", "is_delete", "delete_by", "delete_date", "mfg_stage_type1", "mfg_stage_type2", "mfg_stage_type3", "data_from", "mixed_with_board_flag", "reference_flag", "plan_user", "no_used_qty", "item_class", "net_quantity", "bjitem_flag", "entity_type_name", "entity_subtype_name", "mfg_site_name", "is_model", "created_by_type", "source_service_name", "inventory_org_id", "hwip_release_time", "is_lock", "tmas_release_by", "tmas_release_time", "prod_instr_id", "start_qty_first", "plan_start_time_first", "workorder_plan_online_time", "workorder_plan_end_time", "po_writeoff_finished", "all_issue_flag", "revision_control_code", "eco_num") VALUES ('4EF4E63DFC9348F092D9A5D28AC55A9F', 'DG1', 'DPZHT58E0GF', '51098EER-002', '智能手机-Icelan-AL10CS-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*2/中式旅充*1-折叠-寰宇红', 'Icelan-AL10CS', 'N', '51098EER', '021356', '021356_T', NULL, 'T1ZZ', NULL, NULL, NULL, 'Y', 'CS', NULL, 'N', NULL, NULL, to_timestamp('0001-01-01 21:36:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, NULL, to_timestamp('0001-01-01 22:30:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, to_timestamp('0001-01-01 13:56:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 23:31:01', 'YYYY-MM-DD HH24:MI:SS'), NULL, 1000, 1000, 1000, 0, 'PCS', NULL, NULL, 'h00544570', NULL, '500314573', NULL, 'JUXIN', NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, '4', '6', NULL, 'cPlan20250814S01WK', '20250814', 'EMS', 'STO', 'Develop', 'SZ', 'SCCN0002', '排产需求-标准', 'PPO-Require', 'cPlan20250814S01WK', NULL, '51098EER-002021356_T2430373', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '智能手机-Icelan-AL10CS-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*2/中式旅充*1-折叠-寰宇红', NULL, NULL, NULL, 'd00837601', to_timestamp('0001-01-01 17:52:00', 'YYYY-MM-DD HH24:MI:SS'), 'd00837601', to_timestamp('0001-01-01 23:31:00', 'YYYY-MM-DD HH24:MI:SS'), 0, NULL, NULL, '量产', NULL, NULL, 'PPO', 'N', 'N', 'h00544570', 0, 'FG', '1000', 'N', '标准', '正常生产', NULL, 'Y', NULL, NULL, '85443', to_timestamp('0001-01-01 21:36:16', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'h00544570', to_timestamp('0001-01-01 21:36:00.014217', 'YYYY-MM-DD HH24:MI:SS.US'), '1115909347625631744', 1000, to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD H
[ERR] ERROR: duplicate key value violates unique constraint "tmas_t_ebc_prod_instr_pk"
DETAIL: Key (epi_id)=(6B531483AA89488D99B0DCFFB92DFA65) already exists.
[ERR] INSERT INTO "tmas"."t_ebc_prod_instr" ("epi_id", "inv_organization_code", "prod_instr_no", "item_code", "item_name", "prod_model_code", "service_item_flag", "sku_number", "vendor_code", "mfg_site_code", "bom_version", "wip_class_code", "ppo_type_code", "order_category", "order_type", "inhouse_flag", "feed_mode", "bs_mode", "kit_relation_flag", "material_fullset_flag", "engineer_fullset_flag", "release_time", "plan_start_time", "plan_online_time", "plan_end_time", "actual_start_time", "actual_online_time", "actual_end_time", "bom_extact_time", "first_issue_date", "close_time", "cancel_time", "start_qty", "mrp_net_qty", "completed_qty", "scrapped_qty", "qty_uom", "completion_subinventory_name", "completion_locator_code", "released_by", "board_type", "routing", "routing_version", "factory_code", "eco", "eca", "inbound_complete_flag", "all_complete_flag", "open_qty", "write_off_reserved_qty", "net_supply_qty", "customer_bg_code", "auto_pr_flag", "ppo_status_code", "ppo_progress_code", "bs_po_number", "ppo_demand_number", "ppo_demand_plan_id", "manufacture_mode", "supply_mode", "prod_lifecycle", "supply_center_id", "supply_center_code", "demand_type_code", "source_bill_type", "source_bill_number", "original_bill_type", "original_bill_number", "prod_fulfillment", "prod_category", "responsible_department", "auto_routing_flag", "price_check_flag", "fullset_check_flag", "auto_bom_flag", "auto_inbound_flag", "allow_over_send_flag", "allow_over_recv_flag", "auto_schedule_flag", "bonded_flag", "oversea_flag", "manufacturer_category", "temporary_technology_flag", "verification_flag", "description", "log_msg", "version_number", "version_date", "created_by", "creation_date", "last_updated_by", "last_updated_date", "is_delete", "delete_by", "delete_date", "mfg_stage_type1", "mfg_stage_type2", "mfg_stage_type3", "data_from", "mixed_with_board_flag", "reference_flag", "plan_user", "no_used_qty", "item_class", "net_quantity", "bjitem_flag", "entity_type_name", "entity_subtype_name", "mfg_site_name", "is_model", "created_by_type", "source_service_name", "inventory_org_id", "hwip_release_time", "is_lock", "tmas_release_by", "tmas_release_time", "prod_instr_id", "start_qty_first", "plan_start_time_first", "workorder_plan_online_time", "workorder_plan_end_time", "po_writeoff_finished", "all_issue_flag", "revision_control_code", "eco_num") VALUES ('6B531483AA89488D99B0DCFFB92DFA65', 'DG1', 'DPZHT58U046', '51098FKK-005', '智能手机-Verde-AL00C-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*2/中式旅充*1-折叠-幻夜黑', 'Verde-AL00C', 'N', '51098FKK', '021356', '021356_T', NULL, 'T1ZZ', NULL, NULL, NULL, 'Y', 'CS', NULL, 'N', NULL, NULL, to_timestamp('0001-01-01 18:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, NULL, to_timestamp('0001-01-01 10:45:00', 'YYYY-MM-DD HH24:MI:SS'), NULL, to_timestamp('0001-01-01 22:36:00', 'YYYY-MM-DD HH24:MI:SS'), to_timestamp('0001-01-01 12:02:18', 'YYYY-MM-DD HH24:MI:SS'), NULL, 1001, 1000, 1001, 0, 'PCS', NULL, NULL, 'l00638209', NULL, '950597229', NULL, 'JUXIN', NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, '4', '6', NULL, 'cPlan20250827S0218', '20250827', 'EMS', 'STO', 'Develop', 'SZ', 'SCCN0002', '排产需求-标准', 'PPO-Require', 'cPlan20250827S0218', NULL, '51098FKK-005021356_T2471560', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '智能手机-Verde-AL00C-LTE/WCDMA/GSM手机-USB线缆-内置锂离子电池*2/中式旅充*1-折叠-幻夜黑', NULL, NULL, NULL, 'x00920590', to_timestamp('0001-01-01 17:30:00', 'YYYY-MM-DD HH24:MI:SS'), 'l00638209', to_timestamp('0001-01-01 12:02:00', 'YYYY-MM-DD HH24:MI:SS'), 0, NULL, NULL, '量产', NULL, NULL, 'PPO', 'N', 'N', 'l00638209', 0, 'FG', '1000', 'N', '标准', '正常生产', NULL, 'Y', NULL, NULL, '85443', to_timestamp('0001-01-01 18:00:28', 'YYYY-MM-DD HH24:MI:SS'), 'N', 'l00638209', to_timestamp('0001-01-01 18:00:17.808084', 'YYYY-MM-DD HH24:MI:SS.US'), '1120614989751361536', 1001, to_timestamp('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI
[IMP] Processed: 1000, Added: 0, Updated: 0, Deleted: 0, Errors: 1000
[IMP] Finished with error