树形视图，选择数据源sql，不能显示

客户用的是oracle数据库，在选择树形视图时，其数据源采用sql（多表联合）方式，
在应用平台呈现时报错，经过在tomcat日志查询，发现sql语句错行，见下图，把sql语句拷贝到plsql中，执行报错。


at java.lang.Thread.run(Thread.java:662)
21:33:57,679  WARN SecurityFilter:187 - /obpm/core/dynaform/view/save.action
21:37:18,670  INFO WarpProcessFactory:279 - ##CLEAN-CACHE-->>cn.myapps.core.dynaform.view.ejb.ViewProcessBean.doUpdate(cn.myapps.base.dao.ValueObject)
21:37:18,670  INFO WarpProcessFactory:279 - ##CLEAN-CACHE-->>cn.myapps.core.dynaform.view.ejb.ViewProcessBean.doCreateOrUpdate(cn.myapps.base.dao.ValueObject)
21:37:52,694  INFO PrintJsUtil:27 - JsUtil:sqlceshi==============
21:37:52,694  INFO PrintJsUtil:27 - JsUtil:打印sql=========select  t1.domainid,t1.id,t1.item_代码,t1.item_名称,t1.item_父结点id from tlk_eps表单 t1
21:37:52,694  INFO AbstractDocStaticTblDAO:1362 - Oracle : SELECT * FROM (SELECT * FROM (select  t1.domainid,t1.id,t1.item_代码,t1.item_名称,t1.item_父结点id from tlk_eps表单 t1) ordtb ORDER BY ordtb.
ID) table_0 WHERE table_0.DOMAINID ='11e3-b435-aaa56801-a6d4-c5644e80cc2f'
21:37:52,709  INFO AbstractDocStaticTblDAO:1155 - Oracle :SELECT COUNT(*)  FROM ( SELECT * FROM (SELECT * FROM (select  t1.domainid,t1.id,t1.item_代码,t1.item_名称,t1.item_父结点id from tlk_eps表单 t1
) ordtb ORDER BY ordtb.ID) table_0 WHERE table_0.DOMAINID ='11e3-b435-aaa56801-a6d4-c5644e80cc2f') doc WHERE doc.DOMAINID ='11e3-b435-aaa56801-a6d4-c5644e80cc2f'
21:39:38,696  INFO WarpProcessFactory:279 - ##CLEAN-CACHE-->>cn.myapps.core.dynaform.view.ejb.ViewProcessBean.doUpdate(cn.myapps.base.dao.ValueObject)
21:39:38,696  INFO WarpProcessFactory:279 - ##CLEAN-CACHE-->>cn.myapps.core.dynaform.view.ejb.ViewProcessBean.doCreateOrUpdate(cn.myapps.base.dao.ValueObject)
21:40:14,763  INFO WarpProcessFactory:279 - ##CLEAN-CACHE-->>cn.myapps.core.dynaform.view.ejb.ViewProcessBean.doUpdate(cn.myapps.base.dao.ValueObject)
21:40:14,779  INFO WarpProcessFactory:279 - ##CLEAN-CACHE-->>cn.myapps.core.dynaform.view.ejb.ViewProcessBean.doCreateOrUpdate(cn.myapps.base.dao.ValueObject)
21:40:31,892  INFO PrintJsUtil:27 - JsUtil:sqlceshi==============
21:40:31,892  INFO PrintJsUtil:27 - JsUtil:打印sql=========select  t1.domainid,t1.id,t1.item_代码,t1.item_名称,t1.item_父结点id,t1.formid    from tlk_eps表单 t1
21:40:31,908  INFO AbstractDocStaticTblDAO:1362 - Oracle : SELECT * FROM (SELECT * FROM (select  t1.domainid,t1.id,t1.item_代码,t1.item_名称,t1.item_父结点id,t1.formid    from tlk_eps表单 t1) ordtb OR
DER BY ordtb.ID) table_0 WHERE table_0.DOMAINID ='11e3-b435-aaa56801-a6d4-c5644e80cc2f'
21:40:32,001  INFO AbstractDocStaticTblDAO:1155 - Oracle :SELECT COUNT(*)  FROM ( SELECT * FROM (SELECT * FROM (select  t1.domainid,t1.id,t1.item_代码,t1.item_名称,t1.item_父结点id,t1.formid    from t
lk_eps表单 t1) ordtb ORDER BY ordtb.ID) table_0 WHERE table_0.DOMAINID ='11e3-b435-aaa56801-a6d4-c5644e80cc2f') doc WHERE doc.DOMAINID ='11e3-b435-aaa56801-a6d4-c5644e80cc2f'

楼主贴图没看见，建议楼主在贴图的时候选择高级模式编辑帖子。
在数据库客户端执行报什么错？

本问题已经自行解决。

好的。感谢您的反馈。