起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 3386|回复: 5

[处理中] OA无法保存数据

[复制链接]

70

主题

320

帖子

579

积分

高级会员

Rank: 4

积分
579
QQ
发表于 2017-4-24 15:16:19 | 显示全部楼层 |阅读模式
引入了OA的源码。将源码提供的三个sql库附着在sql2008环境里,
数据源配置如下:

demo--justep_oa
system--JYLN
doc--x5doc
oa--JYLN

JYLN库是我自建的,我的所有业务关系都在这个库里,用户名系统也在这里。
遇到的问题是:我用系统管理员操作OA里的表单,保存都没问题,但我新建了组织机构,没用起步软件,新建了一个组织A与起步软件平级,在A里新建了个账号A1,赋予它访问OA的权限,但是A1无法保存数据,一保存就直接报ksql查询失败

70

主题

320

帖子

579

积分

高级会员

Rank: 4

积分
579
QQ
 楼主| 发表于 2017-4-24 15:36:50 | 显示全部楼层
顺带一提,justep_oa里的业务表我都在JYLN里通过本体生成了表格,现在除了管理员可以正常操作以外,我新建的组织里的人员无法新建,保存的话会报编码:JUSTEP150210
控制台报错:
2017-04-24 15:32:47 excute stream action, params:{"actions":[{"accept":"application/json","action":"saveOA_Pub_BaseCodeAction","actionFlag":"__action_0__","activity":"assetDealModeSetActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"fCode":{"changed":"1"},"fCreateDeptID":{"changed":"1","value":"0EpL9qikKFSTre3BCuX"},"fCreateDeptName":{"changed":"1","value":"产品研发部"},"fCreateOgnID":{"changed":"1","value":"dgIuHmUNYfyHogSwsZf"},"fCreateOgnName":{"changed":"1","value":"京仪绿能"},"fCreatePsnFID":{"changed":"1","value":"/dgIuHmUNYfyHogSwsZf.ogn/0EpL9qikKFSTre3BCuX.dpt/DFNJijZUgaFUYIfy7TH.pos/pvovRWAG1hd0oqVCoEj@DFNJijZUgaFUYIfy7TH.psm"},"fCreatePsnID":{"changed":"1","value":"pvovRWAG1hd0oqVCoEj"},"fCreatePsnName":{"changed":"1","value":"任和勋"},"fCreateTime":{"changed":"1","value":"2017-04-24T15:32:45.873Z"},"fDescription":{"changed":"1"},"fLevel":{"changed":"1"},"fName":{"changed":"1"},"fParentCode":{"changed":"1"},"fScope":{"changed":"1","value":"资产处置类型"},"fSequence":{"changed":"1"},"fURL":{"changed":"1"},"fUpdatePsnID":{"changed":"1","value":"pvovRWAG1hd0oqVCoEj"},"fUpdatePsnName":{"changed":"1","value":"任和勋"},"fUpdateTime":{"changed":"1","value":"2017-04-24T15:32:45.877Z"},"fUseStatus":{"changed":"1","value":"0"},"fUseStatusName":{"changed":"1","value":"未启用"},"userdata":{"id":{"value":"A34EE57A555444948B03F7E3D599561E"},"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","sys.count":6,"sys.rowid":"OA_Pub_BaseCode","updateMode":"whereVersion"}}},"process":"/OA/asset/process/baseSet/assetDealModeSet/assetDealModeSetProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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: [A34EE57A555444948B03F7E3D599561E, 0, null, 0EpL9qikKFSTre3BCuX, 产品研发部, dgIuHmUNYfyHogSwsZf, 京仪绿能, /dgIuHmUNYfyHogSwsZf.ogn/0EpL9qikKFSTre3BCuX.dpt/DFNJijZUgaFUYIfy7TH.pos/pvovRWAG1hd0oqVCoEj@DFNJijZUgaFUYIfy7TH.psm, pvovRWAG1hd0oqVCoEj, 任和勋, 2017-04-24 15:32:45.873, null, null, null, null, 资产处置类型, null, null, pvovRWAG1hd0oqVCoEj, 任和勋, 2017-04-24 15:32:45.877, 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

70

主题

320

帖子

579

积分

高级会员

Rank: 4

积分
579
QQ
 楼主| 发表于 2017-4-25 09:38:28 | 显示全部楼层
老大们呢
点评回复

使用道具 举报

70

主题

320

帖子

579

积分

高级会员

Rank: 4

积分
579
QQ
 楼主| 发表于 2017-4-26 13:29:23 | 显示全部楼层
OA板块没有人么

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35880
发表于 2017-5-8 17:42:17 | 显示全部楼层
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴

70

主题

320

帖子

579

积分

高级会员

Rank: 4

积分
579
QQ
 楼主| 发表于 2017-5-9 10:55:22 | 显示全部楼层
我看了OA的使用手册,看到关于资产处置方式等基础数据都是系统管理员权限才可以使用,我想问从w文件里哪里体现了这个权限呢?
高级模式
B Color Image Link Quote Code Smilies |上传

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-3-29 14:23 , Processed in 0.063960 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表