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

QQ登录

只需一步,快速开始

查看: 2130|回复: 1

[结贴] 在使用Bex5_V3.4的时,点击报表图表中分组报表报错

[复制链接]

104

主题

308

帖子

566

积分

高级会员

Rank: 4

积分
566
QQ
发表于 2016-10-25 13:46:28 | 显示全部楼层 |阅读模式
版本: BeX5V3.4 小版本号:
数据库: Oracle 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 7 浏览器: IE10
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT RORDERID , RSHIPNAME ,(SELECT RCONTACTNAME FROM DEMO_REPORTCUSTOMERS WHERE DEMO_REPORTCUSTOMERS.RCUSTOMERID = DEMO_REPORTORDERS.RCUSTOMERID) AS RCONTACTNAME , (SELECT RLASTNAME || RFIRSTNAME AS RNAME FROM DEMO_REPORTEMPLOYEES WHERE DEMO_REPORTEMPLOYEES.REMPLOYEEID = DEMO_REPORTORDERS.REMPLOYEEID)AS RNAME , TO_CHAR(RORDERDATE, 'yyyy-mm-dd') AS RORDERDATE, TO_CHAR(RREQUIREDDATE, 'yyyy-mm-dd') AS RREQUIREDDATE, TO_CHAR(RSHIPPEDDATE, 'yyyy-mm-dd') AS RSHIPPEDDATE ,RSHIPCOUNTRY ,RSHIPCITY ,RSHIPPOSTALCODE FROM DEMO_REPORTORDERS WHERE RORDERID IN ('10590','10591','10592'), binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at MultiDatasetReportProcedure.masterDetailQuery1(MultiDatasetReportProcedure.java:27)
        ... 27 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        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.executeForDescribe(T4CPreparedStatement.java:796)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 30 more
[ERROR] 2016-10-25 11:34:43,905 com.justep.report.controller.DataController - 报表数据获取失败

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36183
发表于 2016-10-25 15:25:12 | 显示全部楼层
ORA-00942: 表或视图不存在

数据库中找不到表
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-7-2 20:46 , Processed in 0.054467 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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