重复添加的列定义

xiaowangjiayou

这是个查询功能，选择条件后点击查询 报错 重复添加的列定义"HAVE_WG"



2021-09-26 17:07:10 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/ProjectManager/ContractMgr/process/ContractProQuery/contractProQueryProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="pro_contract_queryAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="project_code"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[0005,]]></xbiz:simple></parameter><parameter name="CO_TYPE"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[196]]></xbiz:simple></parameter><parameter name="PO_NO"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="PO_C_NAME"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="CON_U"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="HAVE_WG"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="Dept"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="Dept2"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="CSFS"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="CON_STATUS"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="IS_RECORD"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="tdtSTA"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="tdtEND"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="PRIOD"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[202109]]></xbiz:simple></parameter><parameter name="IS_GTHT"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="IS_MAIN"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="FRCOMPANYTYPE"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter></parameters><translate-parameter data-type="row-tree" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="" sequence="PROJECT_NAME,PO_NO,PO_C_NAME,OWN_U_NAME,CON_U,CO_TYPE,DEPT,ITEM_DEPT,ASIGN_DATE,CSFS,FZB_TYPE_NAME,RECORD_STATUS,IS_GTHT,IS_MAIN,STATUS,PO_MAIN_TOTAL,PO_TOTAL,CHECK_TOTAL,ADD_TOTAL,BG_TOTAL,QS_TOTAL,TC_TOTAL,CHECK_TOTAL_PRICE,FINISH,FINISH_Q,FINISH_Y,FINISH_SUM,PAY,PAY_Q,PAY_Y,PAY_SUM,PAU_REWARD,DEL_PY,END_PAY_SUM,ARRSEAS,LEFT_VALUE,JS1_QD,JS1_TC,JS1_FS,JS1_SUB_TOTAL,JS1_ZY,JS1_SUM_TOTAL,JS2_SUB_TOTAL,JS1_N_QD,JS1_N_TC,JS1_N_FS,JS1_N_SUB_TOTAL,JS1_N_ZY,JS1_N_SUM_TOTAL,JSQD_SUB_TOTAL,JS3_N_QD,JS3_N_TC,JS3_N_FS,JS3_N_SUB_TOTAL,JS3_N_ZY,JS3_N_SUM_TOTAL,HAVE_WG,JS_STATUS,WG_YG,TCMFR_NAME,CDPBFR_NAME,WAT_U_NAME,DF_U_NAME,WF_U_NAME,JS1_ARREARS,JS2_ARREARS,JS3_ARREARS,space-column,version,DESCRIPTION,CWB_CODE,JHB_CODE,ITEM_CODE,IS_RECORD"/></translate-parameter></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql:  select c.po_no as C_PO_NO, c.po_c_name,  c.CON_U_NAME as con_u,c.OWN_U_NAME,c.WAT_U_NAME,c.DF_U_NAME,c.WF_U_NAME, tmp1.description as dept,          tmp2.description as item_dept, c.HAVE_WG, c.WG_YG,           to_char(c.asign_date, 'yyyy-mm-dd') as ASIGN_DATE, tmp3.description as CSFS, tmp4.description as FZB_TYPE_NAME,          p.DESCRIPTION as PROJECT_NAME,           (case c.IS_GTHT when 'Y' then '是' else '否' end) as IS_GTHT,         (case c.IS_MAIN when 'Y' then '是' else '否' end) as IS_MAIN,         (case c.IS_RECORD when 'Y' then '是' else '否' end) as IS_RECORD, c.PO_TOTAL,c.PO_MAIN_TOTAL,          (case c.STATUS when '0' then '初始录入' when '1' then '合同执行'          when '2' then '合同结算' when '3' then '合同废止'          else '无状态' end) as STATUS, cat.TYPE_NAME as co_type, pd.*           from (select project_code, po_no, po_c_name,c1.OWN_U_NAME,CON_U_NAME,c1.WAT_U_NAME,c1.DF_U_NAME,c1.WF_U_NAME, asign_date, BID_TYPE,FZB_TYPE,           IS_GTHT, IS_MAIN,IS_RECORD, PO_TOTAL,PO_MAIN_TOTAL, STATUS, con_u_code, co_type, dept,           item_dept, is_not_gj, nvl(HAVE_WG, 'N') as HAVE_WG, nvl(WG_YG, 0) as WG_YG           from contract c1 where  nvl(c1.is_not_gj,'N')='N' and c1.project_code in ('0005','') and c1.co_type in ('196')) c           left join project p on c.project_code = p.project_code           left join (select * from the ( select cast( Get_Con_Query_Data_New_PRJ('202109') as CON_QUERY_TABLE_NEW) from dual )) pd           on c.project_code = pd.project_code and c.po_no = pd.PO_NO           left join contract_cat cat on c.co_type = cat.co_type            left join (select * from code_table_items where code_table = 'DEPT') tmp1           on c.dept = tmp1.code_table_item           left join (select * from code_table_items where code_table = 'ITEM') tmp2           on c.item_dept = tmp2.code_table_item           left join (select * from code_table_items where code_table = 'CSFS') tmp3           on c.BID_TYPE = tmp3.fid           left join (select * from code_table_items where code_table = 'ZB') tmp4           on c.FZB_TYPE = tmp4.fid   order by cat.REPORT_ORDER, c.po_no, binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at ContractMgr.pro_contract_query(ContractMgr.java:8610)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150204; 提示: 重复添加的列定义"HAVE_WG"
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableMetaDataImpl.addColumnMetaData(Unknown Source)
        at com.justep.system.data.impl.TableImpl.addColumns(Unknown Source)
        at com.justep.system.data.impl.TableImpl.createTable(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.createTable(Unknown Source)
        at com.justep.system.data.TableUtils.createTable(Unknown Source)
        ... 29 more

xiaowangjiayou

已解决 结贴