error on reports server 11g.
IngenioJun 19 2012 — edited Sep 17 2012I have been trying to find info about this problem but I cant find how, the mesage codes (Message -473022448 not found) are always different.
I receive this error ramdomly, sometimes after 30,300, or 800 reports have been generated, and it fixes itself after a while.
I need to fix it.
Please help.
*************************************
at the showjobs page, I can see this error:
Error
El informe ha terminado con error:
REP-1425: Se ha producido un error al ejecutar el paquete DO_SQL en la unidad de programa beforereport: Se ha producido un error al analizar la sentencia SQL: ORA--473022448: Message -473022448 not found; product=RDBMS; facility. .
*************************************
*************************************
at the log rwEng-0_diagnostic I found the following:
[2012-06-19T11:33:13.887-04:00] [reports] [ERROR] [] [oracle.reports.engine] [pid: 9972] [tid: 10] [ecid: 0000JW4qxnc7Q9WFLzjO8A1Fs7bI000000,0:45:100000001] [EngineName: rwEng-0] C Engine Job ID = 1977 ERR REP-1425: Se ha producido un error al ejecutar el paquete DO_SQL en la unidad de programa beforereport: Se ha producido un error al analizar la sentencia SQL: ORA--473022448: Message -473022448 not found; product=RDBMS; facility.
[2012-06-19T11:33:13.903-04:00] [reports] [ERROR] [] [oracle.reports.engine] [pid: 9972] [tid: 10] [ecid: 0000JW4qxnc7Q9WFLzjO8A1Fs7bI000000,0:45:100000001] [EngineName: rwEng-0] rwfdt:rwfdtprint Job ID = 1977 ERR Error occurred sending Job output to cache
[2012-06-19T11:33:13.903-04:00] [reports] [INCIDENT_ERROR] [REP-1425] [oracle.reports.engine] [pid: 9972] [tid: 10] [ecid: 0000JW4qxnc7Q9WFLzjO8A1Fs7bI000000,0:45:100000001] [EngineName: rwEng-0] REP-1425 : Se ha producido un error al ejecutar el paquete DO_SQL en la unidad de programa beforereport: Se ha producido un error al analizar la sentencia SQL: ORA--473022448: Message -473022448 not found; product=RDBMS; facility. [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:553)
at oracle.reports.engine.EngineClassPOA._invoke(EngineClassPOA.java:104)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:451)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1213)
at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:471)
at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:500)
]]
[2012-06-19T11:33:13.903-04:00] [reports] [NOTIFICATION] [] [oracle.reports.engine] [pid: 9972] [tid: 10] [ecid: 0000JW4qxnc7Q9WFLzjO8A1Fs7bI000000,0:45:100000001] [EngineName: rwEng-0] EngineImpl:run oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
*************************************
*************************************
one of the reports's beforereport trigger iis:
function BeforeReport return boolean is
begin
:USER := USER;
SRW.DO_SQL('alter session set NLS_DATE_FORMAT=''YYYY/MM/DD HH24:MI:SS''');
return(TRUE);
end;
*************************************
some of the reports are generated about 100 times at day, and 1-4 times gets the error.
any sugestions?