My Oracle Support Banner

'321300: Submit failed' / 'FRM-41213 - Unable to connect to the Report server' Errors When Trying To Run Reports (SCENARIO: Reports Server is down and not possible to start). (Doc ID 2753189.1)

Last updated on FEBRUARY 17, 2021

Applies to:

Oracle Clinical - Version 5.1.0 and later
Information in this document applies to any platform.

Symptoms

1)
OC 5.1.0 env: Reports fail with the 'RS_SUBMITFAILED' status.



2)
Following errors are also seen in the Oracle Clinical application when trying to submit the report:

321300: Submit failed

FRM-41213 - Unable to connect to the Report server <reports server name>

 

3)
Application Server: unable to start the Reports Server process using OPMN > following error appears:

C:\oracle\Middleware\asinst_1\bin>opmnctl startproc ias-component=<report_server>
opmnctl startproc: starting opmn managed processes...
================================================================================
opmn id=xxxxx:6701
Response: 0 of 1 processes started.

ias-instance id=asinst_1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
  <report_server>/ReportsServerComponent/<report_server>/

Error
--> Process (index=1,uid=xxx,pid=xxxx)
 time out while waiting for a managed process to start
 Log:
 C:\Oracle\Middleware\asinst_1\diagnostics\logs\ReportsServerComponent\<report_server>\console~<report_server>~1.log

 

4)
Reports Server used to work previously and earlier entries in the '[Middleware_Home]\asinst_1\diagnostics\logs\ReportsServerComponent\<reports_server>\rwserver_diagnostic.log' show disk space had run out when starting processes):

[2020-11-22T02:06:07.039-05:00] [reports] [ERROR] [] [oracle.reports.server] [tid: 12] [ecid: xxx,0] EngineManager:spawnEngine  Error writing IOR java.io.FileNotFoundException: C:\Users\opapps\AppData\Local\Temp\<reports_server>_2124036674_1606028767039 (There is not enough space on the disk)
[2020-11-22T02:06:07.039-05:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.server] [tid: 12] [ecid: xxxx,0] REP-50125 : java.io.IOException: Cannot run program "E:\Oracle\Middleware\Oracle_FRHome1\jdk\jre\bin\javaw": CreateProcess error=1450, Insufficient system resources exist to complete the requested service  [[
java.io.IOException: Cannot run program "E:\Oracle\Middleware\Oracle_FRHome1\jdk\jre\bin\javaw": CreateProcess error=1450, Insufficient system resources exist to complete the requested service
at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:328)

 

5)
Now when trying to start the Reports Server via OPMN then the following errors are observed in the reports server log files:

[2021-02-11T03:37:58.163-08:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.engine] [tid: 10] [ecid: xxx,0] [EngineName: rwEng-0] REP-50125 : org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 201  completed: No  [[
org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 201  completed: No
    at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectFailure(ORBUtilSystemException.java:2200)
    at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectFailure(ORBUtilSystemException.java:2221)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.<init>(SocketOrChannelConnectionImpl.java:205)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.<init>(SocketOrChannelConnectionImpl.java:218)
    at com.sun.corba.se.impl.transport.SocketOrChannelContactInfoImpl.createConnection(SocketOrChannelContactInfoImpl.java:101)
    at com.sun.corba.se.impl.protocol.CorbaClientRequestDispatcherImpl.beginRequest(CorbaClientRequestDispatcherImpl.java:171)
    at com.sun.corba.se.impl.protocol.CorbaClientDelegateImpl.request(CorbaClientDelegateImpl.java:118)
    at org.omg.CORBA.portable.ObjectImpl._request(ObjectImpl.java:431)
    at oracle.reports.server._EngineCommStub.registerEngine(_EngineCommStub.java:22)
    at oracle.reports.engine.RWEngine.init(RWEngine.java:335)
    at oracle.reports.engine.RWEngine.main(RWEngine.java:59)
Caused by: java.net.ConnectException: Connection refused: connect
    at sun.nio.ch.Net.connect(Native Method)
    at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:532)
    at java.nio.channels.SocketChannel.open(SocketChannel.java:146)
    at com.sun.corba.se.impl.transport.DefaultSocketFactoryImpl.createSocket(DefaultSocketFactoryImpl.java:60)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.<init>(SocketOrChannelConnectionImpl.java:188)
    ... 8 more

OR

[2021-02-10T13:24:09.547-05:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.engine] [tid: 10] [ecid: xxx,0] [EngineName: rwEng-0] REP-50125 : org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe  [[
org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe
    at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectionAbort(ORBUtilSystemException.java:2400)
    at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectionAbort(ORBUtilSystemException.java:2418)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.readBits(SocketOrChannelConnectionImpl.java:354)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.handleEvent(SocketOrChannelConnectionImpl.java:1124)
    at com.sun.corba.se.impl.transport.SelectorImpl.run(SelectorImpl.java:289)
Caused by: org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 211  completed: No
    at com.sun.corba.se.impl.logging.ORBUtilSystemException.ioexceptionWhenReadingConnection(ORBUtilSystemException.java:2484)
    at com.sun.corba.se.impl.logging.ORBUtilSystemException.ioexceptionWhenReadingConnection(ORBUtilSystemException.java:2502)
    at com.sun.corba.se.impl.protocol.giopmsgheaders.MessageBase.readGIOPHeader(MessageBase.java:116)
    at com.sun.corba.se.impl.transport.CorbaContactInfoBase.createMessageMediator(CorbaContactInfoBase.java:150)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.readBits(SocketOrChannelConnectionImpl.java:314)
    ... 2 more
Caused by: java.io.IOException: An existing connection was forcibly closed by the remote host
    at sun.nio.ch.SocketDispatcher.read0(Native Method)
    at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:25)
    at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:198)
    at sun.nio.ch.IOUtil.read(IOUtil.java:166)
    at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:245)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.readFully(SocketOrChannelConnectionImpl.java:599)
    at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.read(SocketOrChannelConnectionImpl.java:521)
    at com.sun.corba.se.impl.protocol.giopmsgheaders.MessageBase.readGIOPHeader(MessageBase.java:112)
    ... 4 more

]]

 

[2021-02-10T13:24:08.016-05:00] [reports] [INCIDENT_ERROR] [REP-51002] [oracle.reports.zrclient] [tid: 10] [ecid: xxx,0] REP-51002 : Bind to Reports Server <report_server> failed.  [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
    at oracle.reports.utility.Utility.newRWException(Utility.java:1053)
    at oracle.reports.client.ServerManager.getServer(ServerManager.java:284)
    at oracle.reports.zrcclient.ZRCClient.zrcco_Connect(ZRCClient.java:175)

]]

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.