新建一个基础类型的数据，却无法保存和启用，求解~

菇凉微笑有酒窝

2016-06-03 15:23:47 excute stream action, params:{"actions":[{"accept":"application/json","action":"saveOA_Pub_BaseCodeAction","actionFlag":"__action_0__","activity":"startActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"fCode":{"changed":"1","value":"4"},"fCreateDeptID":{"changed":"1","value":"iCXbiUnbbMurA4FVpF7"},"fCreateDeptName":{"changed":"1","value":"脑科学软件研发部"},"fCreateOgnID":{"changed":"1","value":"ORG01"},"fCreateOgnName":{"changed":"1","value":"北京易飞华通科技开发有限公司"},"fCreatePsnFID":{"changed":"1","value":"/ORG01.ogn/iCXbiUnbbMurA4FVpF7.dpt/M3vnvOcLzCYphPOr0sp.pos/BvKjJ2lkmH7GMZLG0AK@M3vnvOcLzCYphPOr0sp.psm"},"fCreatePsnID":{"changed":"1","value":"BvKjJ2lkmH7GMZLG0AK"},"fCreatePsnName":{"changed":"1","value":"李蕊"},"fCreateTime":{"changed":"1","value":"2016-06-03T15:19:41.623Z"},"fDescription":{"changed":"1"},"fLevel":{"changed":"1"},"fName":{"changed":"1","value":"44"},"fParentCode":{"changed":"1"},"fScope":{"changed":"1","value":"借款类型"},"fSequence":{"changed":"1"},"fURL":{"changed":"1"},"fUpdatePsnID":{"changed":"1","value":"BvKjJ2lkmH7GMZLG0AK"},"fUpdatePsnName":{"changed":"1","value":"李蕊"},"fUpdateTime":{"changed":"1","value":"2016-06-03T15:23:18.363Z"},"fUseStatus":{"changed":"1","value":"0"},"fUseStatusName":{"changed":"1","value":"未启用"},"userdata":{"id":{"value":"A6B63A00A6BB4897B75C6E9AD81BF647"},"isModified":true,"recordState":"new"},"version":{"changed":"1","value":0}}],"userdata":{"idColumnDefine":"OA_Pub_BaseCode","idColumnName":"OA_Pub_BaseCode","idColumnType":"String","model":"/OA/common/data","relationAlias":"fCode,fCreateDeptID,fCreateDeptName,fCreateOgnID,fCreateOgnName,fCreatePsnFID,fCreatePsnID,fCreatePsnName,fCreateTime,fDescription,fLevel,fName,fParentCode,fScope,fSequence,fURL,fUpdatePsnID,fUpdatePsnName,fUpdateTime,fUseStatus,fUseStatusName,version","relationTypes":"String,String,String,String,String,String,String,String,DateTime,String,Integer,String,String,String,String,String,String,String,DateTime,String,String,Integer","relations":"OA_Pub_BaseCode.fCode,OA_Pub_BaseCode.fCreateDeptID,OA_Pub_BaseCode.fCreateDeptName,OA_Pub_BaseCode.fCreateOgnID,OA_Pub_BaseCode.fCreateOgnName,OA_Pub_BaseCode.fCreatePsnFID,OA_Pub_BaseCode.fCreatePsnID,OA_Pub_BaseCode.fCreatePsnName,OA_Pub_BaseCode.fCreateTime,OA_Pub_BaseCode.fDescription,OA_Pub_BaseCode.fLevel,OA_Pub_BaseCode.fName,OA_Pub_BaseCode.fParentCode,OA_Pub_BaseCode.fScope,OA_Pub_BaseCode.fSequence,OA_Pub_BaseCode.fURL,OA_Pub_BaseCode.fUpdatePsnID,OA_Pub_BaseCode.fUpdatePsnName,OA_Pub_BaseCode.fUpdateTime,OA_Pub_BaseCode.fUseStatus,OA_Pub_BaseCode.fUseStatusName,OA_Pub_BaseCode.version","updateMode":"whereVersion"}}},"process":"/OA/finance/process/financeLoanType/financeLoanTypeProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO OA_Pub_BaseCode OA_Pub_BaseCode(OA_Pub_BaseCode, OA_Pub_BaseCode.version, OA_Pub_BaseCode.fCode, OA_Pub_BaseCode.fCreateDeptID, OA_Pub_BaseCode.fCreateDeptName, OA_Pub_BaseCode.fCreateOgnID, OA_Pub_BaseCode.fCreateOgnName, OA_Pub_BaseCode.fCreatePsnFID, OA_Pub_BaseCode.fCreatePsnID, OA_Pub_BaseCode.fCreatePsnName, OA_Pub_BaseCode.fCreateTime, OA_Pub_BaseCode.fDescription, OA_Pub_BaseCode.fLevel, OA_Pub_BaseCode.fName, OA_Pub_BaseCode.fParentCode, OA_Pub_BaseCode.fScope, OA_Pub_BaseCode.fSequence, OA_Pub_BaseCode.fURL, OA_Pub_BaseCode.fUpdatePsnID, OA_Pub_BaseCode.fUpdatePsnName, OA_Pub_BaseCode.fUpdateTime, OA_Pub_BaseCode.fUseStatus, OA_Pub_BaseCode.fUseStatusName) VALUES (:OA_Pub_BaseCode, :version, :fCode, :fCreateDeptID, :fCreateDeptName, :fCreateOgnID, :fCreateOgnName, :fCreatePsnFID, :fCreatePsnID, :fCreatePsnName, :fCreateTime, :fDescription, :fLevel, :fName, :fParentCode, :fScope, :fSequence, :fURL, :fUpdatePsnID, :fUpdatePsnName, :fUpdateTime, :fUseStatus, :fUseStatusName)
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.BizData.save(Unknown Source)
        at BizProcedure.save(BizProcedure.java:18)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO OA_PUB_BASECODE (OA_PUB_BASECODE.fID, OA_PUB_BASECODE.VERSION, OA_PUB_BASECODE.FCODE, OA_PUB_BASECODE.FCREATEDEPTID, OA_PUB_BASECODE.FCREATEDEPTNAME, OA_PUB_BASECODE.FCREATEOGNID, OA_PUB_BASECODE.FCREATEOGNNAME, OA_PUB_BASECODE.FCREATEPSNFID, OA_PUB_BASECODE.FCREATEPSNID, OA_PUB_BASECODE.FCREATEPSNNAME, OA_PUB_BASECODE.FCREATETIME, OA_PUB_BASECODE.FDESCRIPTION, OA_PUB_BASECODE.FLEVEL, OA_PUB_BASECODE.FNAME, OA_PUB_BASECODE.FPARENTCODE, OA_PUB_BASECODE.FSCOPE, OA_PUB_BASECODE.FSEQUENCE, OA_PUB_BASECODE.FURL, OA_PUB_BASECODE.FUPDATEPSNID, OA_PUB_BASECODE.FUPDATEPSNNAME, OA_PUB_BASECODE.FUPDATETIME, OA_PUB_BASECODE.FUSESTATUS, OA_PUB_BASECODE.FUSESTATUSNAME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [A6B63A00A6BB4897B75C6E9AD81BF647, 0, 4, iCXbiUnbbMurA4FVpF7, 脑科学软件研发部, ORG01, 北京易飞华通科技开发有限公司, /ORG01.ogn/iCXbiUnbbMurA4FVpF7.dpt/M3vnvOcLzCYphPOr0sp.pos/BvKjJ2lkmH7GMZLG0AK@M3vnvOcLzCYphPOr0sp.psm, BvKjJ2lkmH7GMZLG0AK, 李蕊, 2016-06-03 15:19:41.623, null, null, 44, null, 借款类型, null, null, BvKjJ2lkmH7GMZLG0AK, 李蕊, 2016-06-03 15:23:18.363, 0, 未启用]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 36 more
Caused by: java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 37 more

jishuang

http://docs.wex5.com/bex5-server-question-list-10005/

应该是这个字段FCREATEPSNFID

菇凉微笑有酒窝

可以了，把FCREATEPSNFID的长度变大就没有问题了，谢谢哈