结束了的流程出错了【bugid：7989】

请问标识流程结束的字段是哪个？  貌似是这个字段引起的
以前的流程不会，升级SP7 改了哪些表结构啊？

后台流程监控，改流程也出错，前台视图按钮也出错。

15:22:26,685  INFO AbstractDocStaticTblDAO:1665 - Oracle :SELECT d.* FROM SYSTEM
.TLK_ASSET_APPLICATION d WHERE d.ID=?
15:22:26,718  INFO AbstractFlowStateRTDAO:106 - Oracle: SELECT * FROM SYSTEM.T_F
LOWSTATERT WHERE ID=?
15:22:27,506  INFO AbstractRelationHISDAO:294 - Oracle: SELECT * FROM SYSTEM.T_R
ELATIONHIS vo WHERE vo.DOCID='11e2-ee94-8b4d105c-a225-3b8dd1d84a28' AND vo.FLOWS
TATERT_ID='11e2-ee94-a0b4a586-a225-3b8dd1d84a28' AND vo.FLOWOPERATION=7 ORDER BY
actiontime DESC
java.sql.SQLException: ORA-01722: invalid number

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
tement.java:952)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1054)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
redStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:3329)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:93)
        at cn.myapps.core.workflow.storage.runtime.dao.AbstractRelationHISDAO.ge
tData(AbstractRelationHISDAO.java:298)
        at cn.myapps.core.workflow.storage.runtime.dao.AbstractRelationHISDAO.fi
ndCompleteRelationHIS(AbstractRelationHISDAO.java:578)
        at cn.myapps.core.workflow.storage.runtime.ejb.RelationHISProcessBean.ge
tCompleteRelationHIS(RelationHISProcessBean.java:155)
        at cn.myapps.core.workflow.storage.runtime.intervention.action.FlowInter
ventionAction.doFlow(FlowInterventionAction.java:68)
        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.DefaultWorkflowInterceptor.doInter
cept(DefaultWorkflowInterceptor.java:137)
        at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(
MethodFilterInterceptor.java:81)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(Va
lidationInterceptor.java:115)
        at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(
MethodFilterInterceptor.java:81)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        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.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(
FileUploadInterceptor.java:171)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        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.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInte
rceptor.java:151)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        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.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        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.interceptor.ExceptionMappingInterceptor.interc
ept(ExceptionMappingInterceptor.java:100)
        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)
        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:43)
        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:33)
        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
:178)
        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
:28)
        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:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:879)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:617)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:17
60)
        at java.lang.Thread.run(Thread.java:619)

SELECT * FROM SYSTEM.T_RELATIONHIS vo WHERE vo.DOCID='11e2-ee94-8b4d105c-a225-3b8dd1d84a28'
AND vo.FLOWSTATERT_ID='11e2-ee94-a0b4a586-a225-3b8dd1d84a28' AND vo.FLOWOPERATION=7 ORDER BY
actiontime DESC


看tomcat的sql 语句。。。。   在sp8 下载的那个数据结构文档里 FLOWOPERATION 是VARCHAR        200。。。  但是这里SQL  =7  报错了

您好，FLOWOPERATION字段的参数可参考帖子：http://www.teemlink.com/bbs/view ... 1%F7%B3%CC%EF%BC%89 同时您将您sql语句放到数据库客户端看是否正常执行。

你看SP8最新的数据结构 文档：



改成了varchar  200
我升级SP7后 数据库里也变成了varchar类型

再看上边 我复制的报错的tomcat信息里的sql！！
还当Int处理  

还有以前的流程跑完 这个字段存的是80
但是现在升级后数据库里存的是：



所以导致一楼的错误！

您好：请问您升级之前流程结束后效果正常吗？还有您是从什么版本升级到sp7的？我这边跟进您的sql语句放在oracle客户端执行是正常的。

您好：该问题已经通过客户的数据重现，已经作为bug提交给研发了

您好：该问题在sp8版本中已修复，麻烦您打到sp8最新的补丁包后，再确认是否还有该问题，sp8最新补丁连接：http://www.teemlink.com/bbs/view ... &extra=page%3D1

该问题已在帖子中告知客户在sp8最新程序已修复，而客户也没有反馈该问题，故对应帖子关闭。如有问题可继续跟进