保存数据失败！重复添加的列定义

cookzhu · 发表于 2013-8-30 16:45:34

在自定义的Action中保存数据出现“保存数据失败！重复添加的列定义”错误，
根据管理员zhaixin 的意见设置 TranslateParam等属性，还是一样的错误

zhaixin · 发表于 2013-8-30 16:49:25

设置rowid了吗

cookzhu · 发表于 2013-8-30 17:02:04

设置了

jishuang · 发表于 2013-8-30 17:14:57

控制台详细的错误信息发一下

cookzhu · 发表于 2013-8-30 17:21:47

2013-08-30 17:20:36 invokeActions error！
com.justep.model.exception.ModelException: com.justep.model.exception.ModelException: 重复添加的列定义：ZD016
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.model.exception.ModelException: 重复添加的列定义：ZD016
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)
at com.justep.system.transform.Row2Table.createTable(Unknown Source)
at com.justep.system.transform.Row2Table.transform(Unknown Source)
at com.justep.system.transform.ActionParameterTransform.transTableParam(Unknown Source)
at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
at com.justep.system.transform.ActionParameterTransform.helpTransformByElement(Unknown Source)
at com.justep.system.transform.ActionParameterTransform.transform(Unknown Source)
at com.justep.system.transform.RequestTransform.transParamValue(Unknown Source)
at com.justep.system.transform.RequestTransform.transActionParams(Unknown Source)
at com.justep.system.transform.RequestTransform.transform(Unknown Source)
at com.justep.system.action.Engine.translateParameters(Unknown Source)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 21 more

jishuang · 发表于 2013-9-2 10:04:22

自定义的action对应的java代码发一下看看

cookzhu · 发表于 2013-9-3 09:42:03

//取得薪酬关系数据
public static Table GetXCGX(){
try {

//定义查询ksql，在KSQL中必须使用别名，概念标识和关系标识是大小写敏感的
         String kSql = "select SAL_XCGXB.* from SAL_XCGXB SAL_XCGXB where SAL_XCGXB.DAKJ = 1 and " +
            "SAL_XCGXB.GXBBH = '92FB6A6330414D10A0B7D1F63BC7B7DF'";
         //执行select取得数据。Table是返回的数据集
         Table table = KSQL.select(kSql, null, "/salary/databaseset/data", null);
         table.getProperties().put(Table.PROP_NAME_ROWID, "SAL_XCGXB");
         return table;

      } catch (Exception e) {
         throw new RuntimeException (e.getMessage());
   }

}

//取得薪酬档案数据
public static Table GetXCDA(String CompanyID){
try {
//定义查询ksql，在KSQL中必须使用别名，概念标识和关系标识是大小写敏感的
         String kSql="select SAL_YGXCDAB.* from SAL_YGXCDAB SAL_YGXCDAB";
         //执行select取得数据。Table是返回的数据集
         Table table = KSQL.select(kSql, null, "/salary/databaseset/data", null);
         table.getProperties().put(Table.PROP_NAME_ROWID, "SAL_YGXCDAB");
         return table;
   } catch (Exception e) {
         throw new RuntimeException (e.getMessage());
   }
}

//打开薪酬档案
mainActivity.openClick = function(event){

//取得薪酬关系
justep.Request.sendBizRequest2({
dataType: "application/json",
action: "GetXCGX",
callback: function(result) {
if (result.state) {
justep.xbl('bizXCDA').loadJson(result.response);

//debugger;
for(var i=0; i<justep.xbl('bizXCDA').getCount(); i++){

var j = i;
var DAgrid = justep.xbl('grid').grid;
var FieldID = justep.xbl('bizXCDA').getValue('ZDBM',justep.xbl('bizXCDA').getID(i));
var FieldName = justep.xbl('bizXCDA').getValue('ZDZW',justep.xbl('bizXCDA').getID(i));

                  DAgrid.columnIds[j] = FieldID;
DAgrid.setColumnLabel(j,'<center>'+FieldID+FieldName+'</center>');
                  //DAgrid.setColumnHidden(j, false);


}

//隐藏多余列
                  for (var k=j+1; k<DAgrid.getColumnCount(); k++) {
                  DAgrid.setColumnHidden(k, true);
               }

//DAgrid.setSizes();
DAgrid.initField();

} else {
throw new Error("调用失败！|" + result.response.message);
}
}
});

var tp= new justep.Request.TranslateParam();
tp.rowOption.sequence = justep.xbl('main').getColumnIds();
var options = {};
options.translateParam = tp;
//options.contentType = "application/json";
options.dataType = "xml";
options.action = "GetXCDA";
var response = justep.Request.sendBizRequest2(options);

justep.xbl('main').loadXML(response.responseXML);

/*if (justep.Request.isBizSuccess(response, 'json')) {
   justep.xbl('main').loadJson(response);

} else {
throw new Error("调用失败！|" + result.response.message);
      }*/

//取得薪酬档案
/*justep.Request.sendBizRequest2({
dataType: "application/json",
action: "GetXCDA",
callback: function(result) {
if (result.state) {
justep.xbl('main').loadJson(result.response);

} else {
throw new Error("调用失败！|" + result.response.message);
}
}
}); */

alert("打开薪酬档案成功！");
};

jishuang · 发表于 2013-9-3 10:01:25

那个data保存失败？
参考http://bbs.justep.com/forum.php?mod=viewthread&tid=33524把详细的错误信息打出来然后发一下

cookzhu · 发表于 2013-9-3 10:20:10

本帖最后由 cookzhu 于 2013-9-3 10:46 编辑

2013-09-03 10:12:39 action result:<root><flag>true</flag><data>5ed3ddf685a4ba938f2bad4722ae4ec4</data></root>
2013-09-03 10:12:39 execute actions:<?xml version="1.0" encoding="UTF-8"?>
<actions><action direct-execute="false" process="/salary/salarymanage/process/salaryfiles/salaryfilesProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="saveSAL_YGXCDABAction" accept="*/*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="table"><xbiz:table><rows><userdata name="model">/salary/databaseset/data</userdata><userdata name="id-column-name">SAL_YGXCDAB</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">SAL_YGXCDAB</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">SAL_YGXCDAB.ZD050,SAL_YGXCDAB.ZD044,SAL_YGXCDAB.ZD014,SAL_YGXCDAB.ZD062,SAL_YGXCDAB.ZD061,SAL_YGXCDAB.ZD046,SAL_YGXCDAB.ZD041,SAL_YGXCDAB.ZD063,SAL_YGXCDAB.ZD034,SAL_YGXCDAB.ZD043,SAL_YGXCDAB.ZD030,SAL_YGXCDAB.ZD028,SAL_YGXCDAB.ZD031,SAL_YGXCDAB.ZD027,SAL_YGXCDAB.ZD029,SAL_YGXCDAB.ZD005,SAL_YGXCDAB.ZD003,SAL_YGXCDAB.ZD004,SAL_YGXCDAB.ZD017,SAL_YGXCDAB.ZD016,SAL_YGXCDAB.ZD012,SAL_YGXCDAB.ZD015,SAL_YGXCDAB.ZD013,SAL_YGXCDAB.ZD002,SAL_YGXCDAB.ZD011,SAL_YGXCDAB.ZD033,SAL_YGXCDAB.ZD035,SAL_YGXCDAB.ZD001,SAL_YGXCDAB.ZD032,SAL_YGXCDAB.ZD042,SAL_YGXCDAB.ZD045,SAL_YGXCDAB.ZD048,SAL_YGXCDAB.ZD049,SAL_YGXCDAB.ZD039,SAL_YGXCDAB.ZD047,SAL_YGXCDAB.ZD051,SAL_YGXCDAB.ZD016,SAL_YGXCDAB.ZD017,SAL_YGXCDAB.ZD018,SAL_YGXCDAB.ZD019,SAL_YGXCDAB.ZD020,SAL_YGXCDAB.ZD021,SAL_YGXCDAB.ZD022,SAL_YGXCDAB.ZD023,SAL_YGXCDAB.ZD024,SAL_YGXCDAB.ZD025,SAL_YGXCDAB.ZD026,SAL_YGXCDAB.ZD027,SAL_YGXCDAB.ZD028,SAL_YGXCDAB.ZD029,SAL_YGXCDAB.ZD030,SAL_YGXCDAB.ZD031,SAL_YGXCDAB.ZD032,SAL_YGXCDAB.ZD033,SAL_YGXCDAB.ZD034,SAL_YGXCDAB.ZD035,SAL_YGXCDAB.ZD036,SAL_YGXCDAB.ZD037,SAL_YGXCDAB.ZD038,SAL_YGXCDAB.ZD039,SAL_YGXCDAB.ZD040,SAL_YGXCDAB.ZD041,SAL_YGXCDAB.ZD042,SAL_YGXCDAB.ZD043,SAL_YGXCDAB.ZD044,SAL_YGXCDAB.ZD045,SAL_YGXCDAB.ZD046,SAL_YGXCDAB.ZD047,SAL_YGXCDAB.ZD048,SAL_YGXCDAB.ZD049,SAL_YGXCDAB.ZD050,SAL_YGXCDAB.ZD051,SAL_YGXCDAB.ZD052,SAL_YGXCDAB.ZD053,SAL_YGXCDAB.ZD054,SAL_YGXCDAB.ZD055,SAL_YGXCDAB.ZD056,SAL_YGXCDAB.ZD057,SAL_YGXCDAB.ZD058,SAL_YGXCDAB.ZD059,SAL_YGXCDAB.ZD060,SAL_YGXCDAB.ZD061,SAL_YGXCDAB.ZD062,SAL_YGXCDAB.ZD063,SAL_YGXCDAB.ZD064,SAL_YGXCDAB.ZD065,SAL_YGXCDAB.ZD066,SAL_YGXCDAB.ZD067,SAL_YGXCDAB.ZD068,SAL_YGXCDAB.ZD069,SAL_YGXCDAB.ZD070,SAL_YGXCDAB.ZD071,SAL_YGXCDAB.ZD072,SAL_YGXCDAB.ZD073,SAL_YGXCDAB.ZD074,SAL_YGXCDAB.ZD075,SAL_YGXCDAB.ZD076,SAL_YGXCDAB.ZD077,SAL_YGXCDAB.ZD078,SAL_YGXCDAB.ZD079,SAL_YGXCDAB.ZD080,SAL_YGXCDAB.ZD081,SAL_YGXCDAB.ZD082,SAL_YGXCDAB.ZD083,SAL_YGXCDAB.ZD084,SAL_YGXCDAB.ZD085,SAL_YGXCDAB.ZD086,SAL_YGXCDAB.ZD087,SAL_YGXCDAB.ZD088,SAL_YGXCDAB.ZD089,SAL_YGXCDAB.ZD090,SAL_YGXCDAB.ZD091,SAL_YGXCDAB.ZD092,SAL_YGXCDAB.ZD093,SAL_YGXCDAB.ZD094,SAL_YGXCDAB.ZD095,SAL_YGXCDAB.ZD096,SAL_YGXCDAB.ZD097,SAL_YGXCDAB.ZD098,SAL_YGXCDAB.ZD099,SAL_YGXCDAB.ZD100,SAL_YGXCDAB.CZRY,SAL_YGXCDAB.XGRQ,SAL_YGXCDAB.ZD999,SAL_YGXCDAB.BZ001,SAL_YGXCDAB.BZ002,SAL_YGXCDAB.BZ003,SAL_YGXCDAB.YGXZ,SAL_YGXCDAB.TJSJ,SAL_YGXCDAB.PHONE,SAL_YGXCDAB.EMAIL,SAL_YGXCDAB.XM,SAL_YGXCDAB.MCQC,EXPRESS,SAL_YGXCDAB.VERSION</userdata><userdata name="relation-types">Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,String,DateTime,Decimal,String,String,String,String,DateTime,String,String,String,String,Object,Integer</userdata><userdata name="relation-alias">ZD050,ZD044,ZD014,ZD062,ZD061,ZD046,ZD041,ZD063,ZD034,ZD043,ZD030,ZD028,ZD031,ZD027,ZD029,ZD005,ZD003,ZD004,ZD017,ZD016,ZD012,ZD015,ZD013,ZD002,ZD011,ZD033,ZD035,ZD001,ZD032,ZD042,ZD045,ZD048,ZD049,ZD039,ZD047,ZD051,ZD016,ZD017,ZD018,ZD019,ZD020,ZD021,ZD022,ZD023,ZD024,ZD025,ZD026,ZD027,ZD028,ZD029,ZD030,ZD031,ZD032,ZD033,ZD034,ZD035,ZD036,ZD037,ZD038,ZD039,ZD040,ZD041,ZD042,ZD043,ZD044,ZD045,ZD046,ZD047,ZD048,ZD049,ZD050,ZD051,ZD052,ZD053,ZD054,ZD055,ZD056,ZD057,ZD058,ZD059,ZD060,ZD061,ZD062,ZD063,ZD064,ZD065,ZD066,ZD067,ZD068,ZD069,ZD070,ZD071,ZD072,ZD073,ZD074,ZD075,ZD076,ZD077,ZD078,ZD079,ZD080,ZD081,ZD082,ZD083,ZD084,ZD085,ZD086,ZD087,ZD088,ZD089,ZD090,ZD091,ZD092,ZD093,ZD094,ZD095,ZD096,ZD097,ZD098,ZD099,ZD100,CZRY,XGRQ,ZD999,BZ001,BZ002,BZ003,YGXZ,TJSJ,PHONE,EMAIL,XM,MCQC,space-column,VERSION</userdata><userdata name="sys.rowid">SAL_YGXCDAB</userdata><userdata name="concept">SAL_YGXCDAB</userdata><userdata name="concept-alias">SAL_YGXCDAB</userdata><userdata name="update-mode">whereAll</userdata><row id="79F9D92C0C3246D68402B245BC1A8F48" original-id="79F9D92C0C3246D68402B245BC1A8F48" selected="1"><userdata name="recordState">edit</userdata><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0" changed="1">1</cell><cell original-value=""/><cell original-value=""/><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value=""/><cell original-value="11">11</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="22">22</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="11">11</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="11">11</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="11">11</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value="0">0</cell><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value="HDD">HDD</cell><cell original-value="2013-03-25T13%3A30%3A06.000Z">2013-03-25T13%3A30%3A06.000Z</cell><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value=""/><cell original-value="01">01</cell><cell original-value="2013-03-26T17%3A05%3A15.000Z">2013-03-26T17%3A05%3A15.000Z</cell><cell original-value=""/><cell original-value=""/><cell original-value="%E7%A5%9D%E6%A0%91%E5%B9%B3">%E7%A5%9D%E6%A0%91%E5%B9%B3</cell><cell original-value="%E4%BF%A1%E6%81%AF%E5%85%AC%E5%8F%B8%E5%BC%80%E5%8F%91%E9%83%A8">%E4%BF%A1%E6%81%AF%E5%85%AC%E5%8F%B8%E5%BC%80%E5%8F%91%E9%83%A8</cell><cell original-value=""/><cell original-value="0">0</cell></row></rows></xbiz:table></parameter></parameters></action></actions>

jishuang · 发表于 2013-9-3 11:09:57

检查这个概念的定义以及相关action的定义，确实定义了两次这个关系

		自动登录	找回密码
密码			注册

[结贴] 保存数据失败！ 重复添加的列定义

[结贴] 保存数据失败！重复添加的列定义