|
本帖最后由 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 |
|