注册

第一次用,这个是哪里的问题呢,dm.jdbc.driver.DMException message:Fail to cast string

小布、 2022/11/30 1153 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
在MySql执行是没问题,适配DM时出现的报错,但是没有用过,所以不知道是哪里的原因

错误及原SQL如下

dm.jdbc.driver.DMException message:Fail to cast string

DELETE FROM domain_make_bill_rule WHERE ID IN (‘1575359971027058689’,‘1575359971027058690’,‘1575359971027058691’,‘1575359971027058692’,‘1575359971027058693’,‘1575359971027058694’);

REPLACE INTO domain_make_bill_rule(id,name,filter_scheme,type,is_main_column,is_childer_column,button_type,origin_des,target_des,origin_type,target_type,time_stamp,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_group_id,i_bill_id,def_val,code,domain,is_sys,extend_data,c_data_rule,social_type,is_social,is_social_reverse,relation_bill,name2,name3,name4,name5,name6,is_hidden,category,origin_sub_id,target_sub_id,origin_domain,target_domain,origin_bill_type,target_bill_type,origin_busi_code,target_busi_code,origin_type_uri,target_type_uri,name_resid,origin_des_resid,target_des_resid,micro_service_code) VALUES
(‘1575359971027058689’,‘故障报修转借出申请’,‘po_picking_requisition’,0,true,true,NULL,‘故报维修’,‘借出申请’,‘imppes.pes_sos_failure_card’,‘po_picking_requisition’,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,NULL,‘pesSosFailureToLendApply’,‘imppes’,true,NULL,NULL,NULL,false,false,NULL,NULL,NULL,NULL,NULL,NULL,false,‘ST’,‘IMP_PES’,‘ST’,‘imppes’,‘ustock’,2,2,‘imppes.pes_sms_workva_card’,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ;
REPLACE INTO domain_make_bill_rule(id,name,filter_scheme,type,is_main_column,is_childer_column,button_type,origin_des,target_des,origin_type,target_type,time_stamp,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_group_id,i_bill_id,def_val,code,domain,is_sys,extend_data,c_data_rule,social_type,is_social,is_social_reverse,relation_bill,name2,name3,name4,name5,name6,is_hidden,category,origin_sub_id,target_sub_id,origin_domain,target_domain,origin_bill_type,target_bill_type,origin_busi_code,target_busi_code,origin_type_uri,target_type_uri,name_resid,origin_des_resid,target_des_resid,micro_service_code) VALUES
(‘1575359971027058690’,‘服务工单转借出申请’,‘po_picking_requisition’,0,true,true,NULL,‘服务工单’,‘借出申请’,‘imppes.pes_sos_service_card’,‘po_picking_requisition’,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,NULL,‘pesSosServiceToLendApply’,‘imppes’,true,NULL,NULL,NULL,false,false,NULL,NULL,NULL,NULL,NULL,NULL,false,‘ST’,‘IMP_PES’,‘ST’,‘imppes’,‘ustock’,2,2,‘imppes.pes_sms_workva_card’,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ;
REPLACE INTO domain_make_bill_rule(id,name,filter_scheme,type,is_main_column,is_childer_column,button_type,origin_des,target_des,origin_type,target_type,time_stamp,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_group_id,i_bill_id,def_val,code,domain,is_sys,extend_data,c_data_rule,social_type,is_social,is_social_reverse,relation_bill,name2,name3,name4,name5,name6,is_hidden,category,origin_sub_id,target_sub_id,origin_domain,target_domain,origin_bill_type,target_bill_type,origin_busi_code,target_busi_code,origin_type_uri,target_type_uri,name_resid,origin_des_resid,target_des_resid,micro_service_code) VALUES
(‘1575359971027058691’,‘返厂维修转借出申请’,‘po_picking_requisition’,0,true,true,NULL,‘返厂维修’,‘借出申请’,‘imppes.pes_sos_repair_card’,‘po_picking_requisition’,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,NULL,‘pesSosRepairToLendApply’,‘imppes’,true,NULL,NULL,NULL,false,false,NULL,NULL,NULL,NULL,NULL,NULL,false,‘ST’,‘IMP_PES’,‘ST’,‘imppes’,‘ustock’,2,2,‘imppes.pes_sms_workva_card’,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ;
REPLACE INTO domain_make_bill_rule(id,name,filter_scheme,type,is_main_column,is_childer_column,button_type,origin_des,target_des,origin_type,target_type,time_stamp,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_group_id,i_bill_id,def_val,code,domain,is_sys,extend_data,c_data_rule,social_type,is_social,is_social_reverse,relation_bill,name2,name3,name4,name5,name6,is_hidden,category,origin_sub_id,target_sub_id,origin_domain,target_domain,origin_bill_type,target_bill_type,origin_busi_code,target_busi_code,origin_type_uri,target_type_uri,name_resid,origin_des_resid,target_des_resid,micro_service_code) VALUES
(‘1575359971027058692’,‘安装工单转借出申请’,‘po_picking_requisition’,0,true,true,NULL,‘安装工单’,‘借出申请’,‘imppes.pes_sos_install_card’,‘po_picking_requisition’,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,NULL,‘pesSosInstallToLendApply’,‘imppes’,true,NULL,NULL,NULL,false,false,NULL,NULL,NULL,NULL,NULL,NULL,false,‘ST’,‘IMP_PES’,‘ST’,‘imppes’,‘ustock’,2,2,‘imppes.pes_sms_workva_card’,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ;
REPLACE INTO domain_make_bill_rule(id,name,filter_scheme,type,is_main_column,is_childer_column,button_type,origin_des,target_des,origin_type,target_type,time_stamp,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_group_id,i_bill_id,def_val,code,domain,is_sys,extend_data,c_data_rule,social_type,is_social,is_social_reverse,relation_bill,name2,name3,name4,name5,name6,is_hidden,category,origin_sub_id,target_sub_id,origin_domain,target_domain,origin_bill_type,target_bill_type,origin_busi_code,target_busi_code,origin_type_uri,target_type_uri,name_resid,origin_des_resid,target_des_resid,micro_service_code) VALUES
(‘1575359971027058693’,‘调试工单转借出申请’,‘po_picking_requisition’,0,true,true,NULL,‘调试工单’,‘借出申请’,‘imppes.pes_sos_moder_card’,‘po_picking_requisition’,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,NULL,‘pesSosModerToLendApply’,‘imppes’,true,NULL,NULL,NULL,false,false,NULL,NULL,NULL,NULL,NULL,NULL,false,‘ST’,‘IMP_PES’,‘ST’,‘imppes’,‘ustock’,2,2,‘imppes.pes_sms_workva_card’,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ;
REPLACE INTO domain_make_bill_rule(id,name,filter_scheme,type,is_main_column,is_childer_column,button_type,origin_des,target_des,origin_type,target_type,time_stamp,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_group_id,i_bill_id,def_val,code,domain,is_sys,extend_data,c_data_rule,social_type,is_social,is_social_reverse,relation_bill,name2,name3,name4,name5,name6,is_hidden,category,origin_sub_id,target_sub_id,origin_domain,target_domain,origin_bill_type,target_bill_type,origin_busi_code,target_busi_code,origin_type_uri,target_type_uri,name_resid,origin_des_resid,target_des_resid,micro_service_code) VALUES
(‘1575359971027058694’,‘验收工单转借出申请’,‘po_picking_requisition’,0,true,true,NULL,‘验收工单’,‘借出申请’,‘imppes.pes_sos_receipt_card’,‘po_picking_requisition’,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,NULL,‘pesSosReceiptToLendApply’,‘imppes’,true,NULL,NULL,NULL,false,false,NULL,NULL,NULL,NULL,NULL,NULL,false,‘ST’,‘IMP_PES’,‘ST’,‘imppes’,‘ustock’,2,2,‘imppes.pes_sms_workva_card’,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ;

DELETE FROM domain_make_bill_rule_detail WHERE makebill_id IN (‘1575359971027058689’,‘1575359971027058690’,‘1575359971027058691’,‘1575359971027058692’,‘1575359971027058693’,‘1575359971027058694’);

– 故障报修转借出申请
REPLACE INTO domain_make_bill_rule_detail(id,makebill_id,origin_field,target_field,mapped_relation,mapped_type,calculate_formulas,origin_key,is_write_back,write_back_type,write_back_str,is_comparefield,compare_rule,is_edit,create_time,modify_time,creator,modifier,is_deleted,pubts,sub_id,i_compute_type,child_key,is_sys,source_child_key,fullname_ext,attribute_ext,field_ext,relation_key,ref_field_ext,is_hidden,calculate_formulas_display,category,target_field_display,target_field_name,origin_field_display,origin_field_name,target_field_type,origin_field_type,seq,target_path,target_parent_path,parent_key,grand_parent_key,source_path,source_parent_path,source_parent_key,source_grand_parent_key,origin_field_option,target_field_option,origin_field_resid,micro_service_code) VALUES
– 申请组织(服务组织)
(‘1576126193192665093’,‘1575359971027058689’,‘serviceOrgId’,‘orgId’,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,true,NULL,NULL,NULL,NULL,NULL,NULL,false,NULL,‘ST’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
– 借用对象类型
(‘1576126193192665094’,‘1575359971027058689’,2,‘lendType’,0,3,NULL,NULL,0,NULL,NULL,NULL,NULL,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,true,NULL,NULL,NULL,NULL,NULL,NULL,false,NULL,‘ST’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
– 申请类型(借出申请)
(‘1576126193192665095’,‘1575359971027058689’,3,‘requisitionType’,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,true,NULL,NULL,NULL,NULL,NULL,NULL,false,NULL,‘ST’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
– 服务单号
(‘1576126193192665096’,‘1575359971027058689’,‘code’,‘serviceNo’,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,true,NULL,NULL,NULL,NULL,NULL,NULL,false,NULL,‘ST’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
– 单据状态
(‘1576126193192665097’,‘1575359971027058689’,0,‘status’,0,3,NULL,NULL,0,NULL,NULL,NULL,NULL,0,now(),NULL,NULL,NULL,false,now(),‘ST’,NULL,NULL,true,NULL,NULL,NULL,NULL,NULL,NULL,false,NULL,‘ST’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),

回答 0
暂无回答
扫一扫
联系客服