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

QQ登录

只需一步,快速开始

查看: 1131|回复: 1

[结贴] 更新至5.2.5出错!

[复制链接]

35

主题

76

帖子

141

积分

初级会员

Rank: 2

积分
141
QQ
发表于 2013-7-16 11:20:07 | 显示全部楼层 |阅读模式
更新至 5.2.5 执行了更新操作,但系统运行时出现如下提示:
查看了数据库库中相应的表,有这些字段!
执行sql:(SELECT  c.SCONTENT AS sContent FROM SA_ProcessControl c  WHERE  (c.SPROCESS = ?) AND (c.SACTIVITY = ?) AND (c.SOPERATORID = ?) AND (c.SACTION = ?) AND ( (c.SPROCESSTEMPLATEID2 IS NULL) OR (c.SPROCESSTEMPLATEID2 = ?) ) ), binds:[/PBC_RA/StaffManage/process/StaffInfo/staffInfoProcess, mainActivity, B275071976B94CE48E02B20DA9D77C84, startProcessAction, ]出错!
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 56 more
Caused by: java.sql.SQLException: ORA-00904: "C"."SPROCESSTEMPLATEID2": 标识符无效


执行sql:(SELECT  t.sID, t.sParentID AS sParent, t.SNAME AS sName, t.SSOURCEID AS sSourceID, t.SFLOWID AS sFlowID, t.SPROCESS AS sProcess, t.SACTIVITY AS sActivity, t.SCATALOGID AS sCatalogID, t.SKINDID AS sKindID, t.SCREATETIME AS sCreateTime, t.SEXPECTSTARTTIME AS sExpectStartTime, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SACTUALSTARTTIME AS sActualStartTime, t.SACTUALFINISHTIME AS sActualFinishTime, t.SLASTMODIFYTIME AS sLastModifyTime, t.SCURL AS sCURL, t.SEURL AS sEURL, t.SCREATORFID AS sCreatorFID, t.SCREATORFNAME AS sCreatorFName, t.SEXECUTORFID AS sExecutorFID, t.SEXECUTORFNAME AS sExecutorFName, t.SEXECUTORNAMES AS sExecutorNames, t.SEXECUTEMODE AS sExecuteMode, t.SEXECUTEMODE2 AS sExecuteMode2, t.SDATA1 AS sData1, t.SDATA2 AS sData2, t.SDATA3 AS sData3, t.SDATA4 AS sData4, t.SVARIABLE AS sVariable, t.SACTIVE AS sActive, t.SSTATUSID AS sStatusID, t.SAIID AS sAIID, t.SSTATUSNAME AS sStatusName, t.SAIACTIVE AS sAIActive, t.SAISTATUSID AS sAIStatusID, t.SLOCK AS sLock, t.SSEQUENCE AS sSequence, t.SPREEMPTMODE AS sPreemptMode, t.SRESPONSIBLE AS sResponsible, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SFRONTID AS sFrontID, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SACTIVITYINTEMPLATE AS sActivityInTemplate FROM SA_Task t  WHERE  (t.sID = ?) OR (t.sParentID = ?) ), binds:[7B8F6237A0C44E4EB5BFFE34E3D1C7DE, 7B8F6237A0C44E4EB5BFFE34E3D1C7DE]出错!
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 35 more
Caused by: java.sql.SQLException: ORA-00904: "T"."SACTIVITYINTEMPLATE": 标识符无效

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35945
发表于 2013-7-16 11:38:55 | 显示全部楼层
数据库没有升级,升级之前用的什么版本,参考http://bbs.justep.com/forum.php?mod=viewthread&tid=46737中升级说明对数据库进行升级
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-5-21 11:29 , Processed in 0.062510 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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