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

QQ登录

只需一步,快速开始

查看: 2503|回复: 1

[处理中] 修改了界面后流转报错问题

[复制链接]

27

主题

92

帖子

253

积分

中级会员

Rank: 3Rank: 3

积分
253
QQ
发表于 2015-1-21 10:47:26 | 显示全部楼层 |阅读模式
本帖最后由 yuntianhuicyp 于 2015-1-21 10:48 编辑

界面被我修改后,分了三个bizdata插入数据,一次多条记录,可点击流转报错如下,求解决:

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO
OA_GZJH_Execute OA_GZJH_Execute(OA_GZJH_Execute, OA_GZJH_Execute.version, OA_GZJH_Execute.fMasterID
, OA_GZJH_Execute.fTaskID, OA_GZJH_Execute.fActivityFName, OA_GZJH_Execute.fActivityLabel, OA_GZJH_E
xecute.fOpinion, OA_GZJH_Execute.fVerdict, OA_GZJH_Execute.fState, OA_GZJH_Execute.fStateName, OA_GZ
JH_Execute.fCreateOgnID, OA_GZJH_Execute.fCreateOgnName, OA_GZJH_Execute.fCreateDeptID, OA_GZJH_Exec
ute.fCreateDeptName, OA_GZJH_Execute.fCreatePosID, OA_GZJH_Execute.fCreatePosName, OA_GZJH_Execute.f
CreatePsnID, OA_GZJH_Execute.fCreatePsnName, OA_GZJH_Execute.fCreatePsnFID, OA_GZJH_Execute.fCreateP
snFName, OA_GZJH_Execute.fCreateTime, OA_GZJH_Execute.fUpdatePsnID, OA_GZJH_Execute.fUpdatePsnName,
OA_GZJH_Execute.fUpdateTime) VALUES (:EXECUTE_CONCEPT, :version, :fMasterID, :fTaskID, :fActivityFNa
me, :fActivityLabel, :fOpinion, :fVerdict, :fState, :fStateName, :fCreateOgnID, :fCreateOgnName, :fC
reateDeptID, :fCreateDeptName, :fCreatePosID, :fCreatePosName, :fCreatePsnID, :fCreatePsnName, :fCre
atePsnFID, :fCreatePsnFName, :fCreateTime, :fUpdatePsnID, :fUpdatePsnName, :fUpdateTime)
        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.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.appCommon.ProcessExecute.autoCreateExecute(ProcessExecute.java:501)
        at com.justep.appCommon.ProcessExecute.doAfterAdvanceProcess(ProcessExecute.java:241)
        at com.justep.appCommon.ProcessExecute._doAfterProcessAction(ProcessExecute.java:202)
        at com.justep.appCommon.ProcessExecute.doAfterProcessAction(ProcessExecute.java:194)
        ... 36 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO OA_PUB_E
xecute (OA_PUB_Execute.fID, OA_PUB_Execute.VERSION, OA_PUB_Execute.fMasterID, OA_PUB_Execute.FTASKID
, OA_PUB_Execute.FACTIVITYFNAME, OA_PUB_Execute.FACTIVITYLABEL, OA_PUB_Execute.FOPINION, OA_PUB_Exec
ute.FVERDICT, OA_PUB_Execute.FSTATE, OA_PUB_Execute.FSTATENAME, OA_PUB_Execute.FCREATEOGNID, OA_PUB_
Execute.FCREATEOGNNAME, OA_PUB_Execute.FCREATEDEPTID, OA_PUB_Execute.FCREATEDEPTNAME, OA_PUB_Execute
.FCREATEPOSID, OA_PUB_Execute.FCREATEPOSNAME, OA_PUB_Execute.FCREATEPSNID, OA_PUB_Execute.FCREATEPSN
NAME, OA_PUB_Execute.FCREATEPSNFID, OA_PUB_Execute.FCREATEPSNFNAME, OA_PUB_Execute.FCREATETIME, OA_P
UB_Execute.FUPDATEPSNID, OA_PUB_Execute.FUPDATEPSNNAME, OA_PUB_Execute.FUPDATETIME, OA_PUB_Execute.f
BizKind) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?
,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), binds: [64B80B7956D542DDA9A77A6C41330E99, 0, 96445E58AA3A4A
51B47A59D87565F4AF, 2F7B73E78DAA41BD91285EF7B48FC90C, /OA_X/workPlan/process/officesWorkPlan/bizActi
vity1, 绩效考核编制, , , esExecuting, 处理中, DC071449CAD945B69188C7EFBC4627C4,***公司, ECAA4E0E08C14444BFACEA
C0A56B933E, 财富管理部, 9339F3D40CC440309AF0D52F984368E6, 财富管理部总监, 45F655EC1024479CA9A22210D89B61A6, **,
/DC071449CAD945B69188C7EFBC4627C4.ogn/ECAA4E0E08C14444BFACEAC0A56B933E.dpt/9339F3D40CC440309AF0D52F9
84368E6.pos/45F655EC1024479CA9A22210D89B61A6@9339F3D40CC440309AF0D52F984368E6.psm, /***公司/财富管理部/财富管理
部总监/**, 2015-01-21 10:40:43.765, 45F655EC1024479CA9A22210D89B61A6, **, 2015-01-21 10:40:43.765, 工作计划
]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 49 more
Caused by: java.sql.SQLException: The target table OA_PUB_Execute of the INSERT is not insertable-in
to
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatemen
t.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatemen
t.java:105)
        ... 50 more

39

主题

1379

帖子

2464

积分

金牌会员

Rank: 6Rank: 6

积分
2464
发表于 2015-1-26 11:07:35 | 显示全部楼层
楼主是用的最新资源吗?
检查一下OA_PUB_Execute  这个概念是视图还是一个表?
高级模式
B Color Image Link Quote Code Smilies |上传

本版积分规则

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

GMT+8, 2024-4-25 08:48 , Processed in 0.063922 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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