HELP! ORA-00600 error while excuting report

By: Zhiqing Li - lizhiqing
HELP! ORA-00600 error while excuting report
2004-01-12 09:57
hi,

I'm using jasperreports to generate a report, the report sql is a little bit long, and it is doing well in SQL*PLUS, I can get the result in less then 10 seconds. But, when it is working in jasperreports, I get the following error:
-------------------------------------------------
java.sql.SQLException: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at weblogic.jdbc.pool.PreparedStatement.executeQuery(PreparedStatement.java:53)
at weblogic.jdbc.rmi.internal.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:58)
at weblogic.jdbc.rmi.SerialPreparedStatement.executeQuery(SerialPreparedStatement.java:43)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142)
at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395)
at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:115)
at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)
at com.erry.juice.report.JuiceReportServer.getOutputStream(JuiceReportServer.java:100)
at com.erry.juice.report.JuiceReportServlet.service(JuiceReportServlet.java:63)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:306)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5412)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:744)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3086)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)

NESTED BY :
java.sql.SQLException: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at weblogic.jdbc.pool.PreparedStatement.executeQuery(PreparedStatement.java:53)
at weblogic.jdbc.rmi.internal.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:58)
at weblogic.jdbc.rmi.SerialPreparedStatement.executeQuery(SerialPreparedStatement.java:43)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142)
at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395)
at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:115)
at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)
at com.erry.juice.report.JuiceReportServer.getOutputStream(JuiceReportServer.java:100)
at com.erry.juice.report.JuiceReportServlet.service(JuiceReportServlet.java:63)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:306)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5412)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:744)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3086)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)

NESTED BY :
dori.jasper.engine.JRException: Error executing report query :

select t_inv.*,nvl(t_sales.sales_q,0) as sales_q,nvl(t_sales.sales_a,0) as sales_a
from
( select
item.code as itemcode,
item.name as itemname,
item.description as itemdesc,
item.baseunitname,
item.pricelsc,
sum(begin_inv) as from_inv,
sum(p_in) as p_in,
sum(end_inv) as to_inv,
sum(end_inv*item.pricelsc) as to_inv_a
from
(
select
inv.itemcode as itemCode,
sum(quantity) as begin_inv,
0 as p_in,
sum(quantity) as end_inv
from
inventory inv ,
warehouse wh
where
inv.warehouseCode=wh.code
and wh.entityCode = ?
and inv.vendorcode=?
group by
inv.warehouseCode,
inv.itemcode
having sum(quantity)<>0
union
select
log.itemcode as itemCode,
sum((case log.action when '1' then -1 when '2' then 1 else 0 end)*log.quantity) as begin_inv,
0 as p_in,
0 as end_inv
from
warehouseiolog log,
warehouse wh,
item
where
log.warehouseCode=wh.code
and item.code=log.itemcode
and item.vendorcode=?
and wh.entityCode = ?
and ioDate>= ?
group by
log.itemcode
union
select
log.itemcode as itemCode,
0 as begin_inv,
0 as p_in,
sum((case log.action when '1' then -1 when '2' then 1 else 0 end)*log.quantity) as end_inv
from
warehouseiolog log,
warehouse wh,
item
where
log.warehouseCode=wh.code
and item.code=log.itemcode
and item.vendorcode=?
and wh.entityCode = ?
and ioDate>= ?
group by
log.itemcode
union
select
log.itemcode as itemcode,
0 as begin_inv,
sum(log.quantity) as p_in,
0 as end_inv
from
warehouseiolog log,
warehouse wh,
item
where
log.warehouseCode=wh.code
and item.code=log.itemcode
and item.vendorcode=?
and wh.entityCode = ?
and ioDate>= ?
and ioDate< ?
and action=1
and ioreason=101
group by log.itemcode
) t_begin_end,item
where itemcode=item.code
group by
item.code,
item.name,
item.description,
item.baseunitname,
item.pricelsc
) t_inv
full join
(
select
log.itemcode as itemcode,
sum(log.quantity) as sales_q,
sum(log.quantity*(
case so.ordertype
when '0' then item.baseretailprice
when '1' then item.pricess
else item.pricesc end)
) as sales_a
from
warehouseiolog log,salesorder so,warehouse wh,item
where
log.billno=so.code and
log.warehousecode=wh.code and
item.code=log.itemcode and
item.vendorcode=? and
wh.entitycode=? and
action='2' and
ioreason='201' and
log.iodate>=? and
log.iodate<?
group by log.itemcode
) t_sales
on t_inv.itemcode=t_sales.itemcode
where from_inv<>0 or p_in<>0 or to_inv<>0 or sales_q<>0
order by t_inv.itemcode


at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:379)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142)
at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395)
at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:115)
at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)
at com.erry.juice.report.JuiceReportServer.getOutputStream(JuiceReportServer.java:100)
at com.erry.juice.report.JuiceReportServlet.service(JuiceReportServlet.java:63)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:306)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5412)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:744)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3086)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at weblogic.jdbc.pool.PreparedStatement.executeQuery(PreparedStatement.java:53)
at weblogic.jdbc.rmi.internal.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:58)
at weblogic.jdbc.rmi.SerialPreparedStatement.executeQuery(SerialPreparedStatement.java:43)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375)
... 15 more

You can find my sql in the error stack trace. I know that ORA-00600 is an internal error of oracle, but what can I do?

The version of my oracle is 9i, and the server running the report is Sun Fire V880 with solaris 8.

Thanks in advance.