用升级工具从2.5SP2升级到2.5sp5后出错。

10:16:35,171  INFO AbstractDocStaticTblDAO:1481 - MY SQL: SELECT d.* FROM JSGL.T
LK_人员选项卡 d WHERE d.ID=?
10:16:35,171  INFO AbstractFlowStateRTDAO:106 - MY SQL: SELECT * FROM JSGL.T_FLO
WSTATERT WHERE ID=?
10:16:35,187 ERROR OBPMFilterDispatcher:48 - URL: /obpm/portal/dynaform/document
/view.action
javax.servlet.ServletException: Could not execute action
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:246)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:198)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDis
patcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiL
anguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilte
r.java:30)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java
:115)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.jasig.cas.client.util.AssertionThreadLocalFilter.doFilter(Asserti
onThreadLocalFilter.java:54)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(Ht
tpServletRequestWrapperFilter.java:75)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilt
er(AbstractTicketValidationFilter.java:197)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.core.sso.cas.filter.OBPMAuthenticationFilter.doFilter(OBPMA
uthenticationFilter.java:84)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignO
utFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java
:27)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:263)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:852)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:584)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
08)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Column 'LASTMODIFIERID' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5548)
        at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResul
tSet.java:225)
        at cn.myapps.core.workflow.storage.runtime.dao.AbstractFlowStateRTDAO.se
tBaseProperties(AbstractFlowStateRTDAO.java:285)
        at cn.myapps.core.workflow.storage.runtime.dao.AbstractFlowStateRTDAO.fi
nd(AbstractFlowStateRTDAO.java:114)
        at cn.myapps.base.ejb.AbstractRunTimeProcessBean.doView(AbstractRunTimeP
rocessBean.java:63)
        at cn.myapps.core.dynaform.document.ejb.Document.getState(Document.java:
1132)
        at cn.myapps.core.dynaform.document.action.DocumentAction.doView(Documen
tAction.java:182)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultAc
tionInvocation.java:365)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(Defau
ltActionInvocation.java:217)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:191)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:113)
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:233)
        ... 44 more

有可能是这个t_flowstatert表里缺少一些字段造成的。是不是在升级的时候没有升级这个表呢？

您好，请问您的升级工具是不是这个链接下载的？http://www.teemlink.com/downloads.jsp
如果是，该升级工具只支持从2.5sp3（7900）版本的数据升级到2.5sp4（9380）版本的数据和2.5sp5版本的数据，以及把2.5sp4（9380）版本的数据升级到2.5sp5版本的数据。如果您需将sp2升级到sp5.那么您需在sp3里找到类似bat文件，将sp2升级到sp3

然后再用升级工具升级到sp5.

嗯。我直接是用升级工具的。我先试试，谢谢了。

您好，请将尝试后的结果在帖子中告知！

报了错
java.lang.Exception: org.hibernate.exception.ConstraintViolationException: Could
not execute JDBC batch update
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:131)
        at cn.myapps.base.ejb.AbstractDesignTimeProcessBean.doCreate(AbstractDes
ignTimeProcessBean.java:39)
        at cn.myapps.core.dynaform.summary.ejb.SummaryCfgProcessBean$$EnhancerBy
CGLIB$$902d62ff.CGLIB$doCreate$11(<generated>)
        at cn.myapps.core.dynaform.summary.ejb.SummaryCfgProcessBean$$EnhancerBy
CGLIB$$902d62ff$$FastClassByCGLIB$$c9a3aba3.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:182)
        at cn.myapps.core.dynaform.summary.ejb.SummaryCfgProcessBean$$EnhancerBy
CGLIB$$902d62ff.doCreate(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.jamonapi.proxy.MonProxy.invoke(MonProxy.java:110)
        at $Proxy2.doCreate(Unknown Source)
        at cn.myapps.version.transfer.SummaryCfgTransfer.transfer4to5(SummaryCfg
Transfer.java:56)
        at cn.myapps.version.transfer.SummaryCfgTransfer.to2_5(SummaryCfgTransfe
r.java:26)
        at cn.myapps.version.transfer.process.TransferProcessImpl.processTransfe
r(TransferProcessImpl.java:29)
        at cn.myapps.version.transfer.process.TransferProcessImpl.processAllTran
sfer(TransferProcessImpl.java:16)
        at cn.myapps.version.transfer.AllTransfer.main(AllTransfer.java:60)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execu
te JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:71)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at cn.myapps.base.dao.HibernateBaseDAO.commitTransaction(HibernateBaseDA
O.java:755)
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:129)
        ... 17 more
Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a fo
reign key constraint fails (`obpm`.`t_summary`, CONSTRAINT `FKEF16469B21F601BE`
FOREIGN KEY (`FORMID`) REFERENCES `t_dynaform_form` (`ID`))
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:2016)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1452)
        at sun.reflect.GeneratedMethodAccessor229.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:
100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.ja
va:57)
        at com.mysql.jdbc.Statement$$EnhancerByProxool$$669e6448.executeBatch(<g
enerated>)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 26 more
java.lang.Exception: org.hibernate.exception.ConstraintViolationException: Could
not execute JDBC batch update
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:131)
        at cn.myapps.base.ejb.AbstractDesignTimeProcessBean.doCreate(AbstractDes
ignTimeProcessBean.java:39)
        at cn.myapps.core.dynaform.summary.ejb.SummaryCfgProcessBean$$EnhancerBy
CGLIB$$902d62ff.CGLIB$doCreate$11(<generated>)
        at cn.myapps.core.dynaform.summary.ejb.SummaryCfgProcessBean$$EnhancerBy
CGLIB$$902d62ff$$FastClassByCGLIB$$c9a3aba3.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:182)
        at cn.myapps.core.dynaform.summary.ejb.SummaryCfgProcessBean$$EnhancerBy
CGLIB$$902d62ff.doCreate(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.jamonapi.proxy.MonProxy.invoke(MonProxy.java:110)
        at $Proxy2.doCreate(Unknown Source)
        at cn.myapps.version.transfer.SummaryCfgTransfer.transfer4to5(SummaryCfg
Transfer.java:56)
        at cn.myapps.version.transfer.SummaryCfgTransfer.to2_5(SummaryCfgTransfe
r.java:26)
        at cn.myapps.version.transfer.process.TransferProcessImpl.processTransfe
r(TransferProcessImpl.java:29)
        at cn.myapps.version.transfer.process.TransferProcessImpl.processAllTran
sfer(TransferProcessImpl.java:16)
        at cn.myapps.version.transfer.AllTransfer.main(AllTransfer.java:60)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execu
te JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:71)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at cn.myapps.base.dao.HibernateBaseDAO.commitTransaction(HibernateBaseDA
O.java:755)
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:129)
        ... 17 more
Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a fo
reign key constraint fails (`obpm`.`t_summary`, CONSTRAINT `FKEF16469B21F601BE`
FOREIGN KEY (`FORMID`) REFERENCES `t_dynaform_form` (`ID`))
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:2016)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1452)
        at sun.reflect.GeneratedMethodAccessor229.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:
100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.ja
va:57)
        at com.mysql.jdbc.Statement$$EnhancerByProxool$$669e6448.executeBatch(<g
enerated>)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 26 more

您好，错误信息提示，数据库不能查询。麻烦用数据库客户端测试您的数据库是否开启，谢谢

爲了您的問題能夠及時跟進與解決，方便的話，清提供您的聯繫方式（QQ或電話）以便我們為您提供更好的服務

数据库当然是开着的。马化腾：99104471

当前软件： 客户关系管理系统模板
Delete Operation: 11de-d978-8a67e104-bbd1-d93f240b281110133
Delete Operation: 11de-d978-8a67e104-bbd1-d93f240b281110113
Create Operation: Modify
当前软件： myApps功能示例
Delete Operation: 11de-ef9e-c010eee1-860c-e1cadb71451010133
Delete Operation: 11de-ef9e-c010eee1-860c-e1cadb71451010113
Create Operation: Modify
当前软件： 软件缺陷管理系统模板
Delete Operation: 11de-ef9f-74f03045-860c-e1cadb71451010133
Delete Operation: 11de-ef9f-74f03045-860c-e1cadb71451010113
Create Operation: Modify
当前软件： 任务分派管理系统模板
Delete Operation: 11de-ef9f-b3e7b9e8-860c-e1cadb71451010133
Delete Operation: 11de-ef9f-b3e7b9e8-860c-e1cadb71451010113
Create Operation: Modify
当前软件： OA办公管理系统模板(精简版)
Delete Operation: 11de-f053-df18d577-aeb6-19a7865cfdb610133
Delete Operation: 11de-f053-df18d577-aeb6-19a7865cfdb610113
Create Operation: Modify
当前软件： OA办公管理系统模板(标准版)
Delete Operation: 11e0-64cb-0102bc66-a16d-737e9c8ca3b810133
Delete Operation: 11e0-64cb-0102bc66-a16d-737e9c8ca3b810113
Create Operation: Modify
当前软件： 计划管理系统模板
Delete Operation: 11e0-64cb-830d2439-a16d-737e9c8ca3b810133
Delete Operation: 11e0-64cb-830d2439-a16d-737e9c8ca3b810113
Create Operation: Modify
当前软件： 企业OA系统应用实例
Delete Operation: 11e0-7791-3a8765b9-adde-cd9b30655eea10133
Delete Operation: 11e0-7791-3a8765b9-adde-cd9b30655eea10113
Create Operation: Modify

您好，请问您使用什么数据库呢？麻烦提供您数据库以及数据库的版本号，谢谢

mysql-noinstall-5.1.37-win32