'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, 2023

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:

[Middleware_Home]\asinst_1\diagnostics\logs\ReportsServerComponent\<reports_server>\rwEng-0_diagnostic.log:

[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

[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

]]

[Middleware_Home]\asinst_1\diagnostics\logs\ReportsServerComponent\<reports_server>\zrclient_diagnostic.log:

[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

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

'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)

Applies to:

Symptoms

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!