天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

 找回密码
 注册成为天翎用户
查看: 822|回复: 2

[已解决] 【R2.5-sp10 19962】打开我的工作报错

 关闭 [复制链接]
海南天语 发表于 2014-4-29 23:27:11 | 显示全部楼层 |阅读模式
本帖最后由 Jarod 于 2014-6-6 19:20 编辑

【R2.5-sp10  19962】打开我的工作报错  
23:24:59,555  INFO AbstractDocStaticTblDAO:2721 - MS SQL Server: SELECT COUNT(*)
  FROM (SELECT DISTINCT * FROM (select pen.docid from (select distinct docid,flo
wid from DBO.T_NODERT,(select nodert_id from DBO.T_ACTORRT where actorid = '11e3
-cac4-d1defee0-835b-87ed365c68ca' and actor.pending = 1) as tba where id=tba.nod
ert_id) fs,DBO.T_FLOW_INTERVENTION pen where fs.docid = pen.docid UNION select p
en.docid from (select distinct docid,flowid from DBO.T_RELATIONHIS,(select nodeh
is_id from DBO.T_ACTORHIS where actorid = '11e3-cac4-d1defee0-835b-87ed365c68ca'
) as tba where id=tba.nodehis_id) fs,DBO.T_FLOW_INTERVENTION pen,DBO.T_DOCUMENT
doc where fs.docid = pen.docid and fs.docid = doc.id) tab ) table_0
java.sql.SQLException: 无法绑定由多个部分组成的标识符 "actor.pending"。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement
.java:477)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrep
aredStatement.java:777)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:93)
david 发表于 2014-4-30 16:49:23 | 显示全部楼层
从日志看,好像找不到actor这个表(或者别名),这个actor是从哪来的?
nice 发表于 2014-6-6 11:43:28 | 显示全部楼层
联系楼主已经解决.

本版积分规则

QQ|手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-13 15:27

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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