Forms Call Reports "run_report_object" API Execute Failed and Return "FRM-41213:Unable to connect to the Report server [server_name]"
(Doc ID 2982056.1)
Last updated on OCTOBER 31, 2024
Applies to:
Oracle Forms - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Symptoms
One Forms and Reports 12.2.1.4 with IBM JDK 1.8.0_331 environment setup on AIX 7.2 machine. After configuration completed, Forms and Reports application can be accessed individually.
But Form call Report with "run_report_object" execute failed and still return "FRM-41213 Unable to connect to the Report server [server_name]"
Followed known configuration may affect run_report_object API, but issue persists.
1. configured COMPONENT_CONFIG_PATH on default.env
COMPONENT_CONFIG_PATH=$DOMAIN_HOME/config/fmwconfig/components/ReportsToolsComponent/reptools1
2. update provider order in java.security under "[JDK 1.8.0_331]/jre/lib/security"
from
-------------------------------------------------
security.provider.1=com.ibm.jsse2.IBMJSSEProvider2
security.provider.2=com.ibm.crypto.plus.provider.IBMJCEPlus
security.provider.3=com.ibm.crypto.provider.IBMJCE
--------------------------------------------------
change to
--------------------------------------------------
security.provider.1=com.ibm.jsse2.IBMJSSEProvider2
security.provider.2=com.ibm.crypto.provider.IBMJCE
security.provider.3=com.ibm.crypto.plus.provider.IBMJCEPlus
---------------------------------------------------
3. It is verified that report server can be accessed by rwclient
rwclient server=[server_name] report=test.rdf userid=username/password@[db_connection] desformat=pdf DESTYPE=cache
4. Checking Reports showjobs.
No any job data shown on reports when "run_report_object" return FRM-41213.
http://host:port/reports/rwservlet/showjobs?server=[server_name]
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 |
| Cause |
| Solution |