Oracle Forms and reports

Problem 1 : Oracle 12c Forms and report on Windows, While starting weblogic service getting below error on windows
oracle.security.jps.JpsException: JPS-02592: Failed to push ldap config data to libOvd for service instance “idstore.ldap” in JPS context “default”, cause: org.xml.sax.SAXException: Error Parsing at line #2: 1.
org.xml.sax.SAXParseException; lineNumber: 2; columnNumber: 1; : XML-20108: (Fatal Error) Start of root element expected.
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:229)
at oracle.security.jps.wls.JpsWlsStartup.start(JpsWlsStartup.java:105)
at oracle.security.jps.JpsStartup.startWithRetry(JpsStartup.java:267)
… 49 more
Stopping Derby server…
Derby server stopped.

CAUSE
adapters.os_xml file got corrupted, Probably the due to abrupt server restart.

SOLUTION

  1. Go to $DOMAIN_HOME/config/fmwconfig/ovd/default/
  2. Rename corrupted adapters.os_xml
  3. Copy adapters.os_xml from $MW_HOME/oracle_common/modules/oracle.ovd/templates/ to $DOMAIN_HOME/config/fmwconfig/ovd/default/
  4. Restart the services

********************

********************

Problem2 : Oracle 12c report on Windows service not starting getting below error on windows
REP-52266: The in-process Reports Server rep_wls_reports_server failed to start.org.omg.CORBA.OBJECT_NOT_EXIST: ———-BEGIN server-side stack trace———- org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: SUN minor code: 1004 completed: No

CAUSE could happen after the recent system changes. temp folder used by default report temp path on registry not accessible

The issue was with windows registry parameter for Report tmp path.

The old path was not visible to Oracle service at report calling time, updated new path on registry for report_tmp

SOLUTION

Edit registry “E:\Oracle\report_temp” instead of default windows tmp path, windows default tmp path changes

If above not works then

might be you are using the default multicast network discovery mechanism with the default 228.5.6.7 channel. This has proven to be unstable and to yield REP-56040 error and/or also showing the reports server to appear multiple times in the rwdiag output.
There are two options to avoid this:
1. Change the channel for multicast from 228.5.6.7 to 224.0.0.5 – Multicast Working Intermittent ( Doc ID 780845.1 ). This is a more stable channel. This needs to be done in the rwnetwork.conf files from the following locations:
C:\oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\BASE_D~1\config\fmwconfig\components\ReportsToolsComponent\RepTools1\rwnetwork.conf
C:\oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\BASE_D~1\config\fmwconfig\components/ReportsServerComponent/<standalone repserver>/\rwnetwork.conf – for the standalone reports server, if you are using one
C:\oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\BASE_D~1\config\fmwconfig\servers/WLS_REPORTS/applications/reports_12.2.1/configuration/rwnetwork.conf – for the in process reports server.

Then you need to restart WLS_REPORTS and the reports server(s).

2. Switch to naming service discovery mechanism – How to Enable Namingservice Discovery Mechanism for all Reports Server in Reports 12c ( Doc ID 2205595.1 )

For the time being you should try option 1.

Problem3 : Oracle 12c report error REP-69: “An internal error occurred, REP-56133: Access is denied to write to the specified location.”

http://192.168.0.101:9002/reports/rwservlet?report=E:\APP\fmxs\test.rdf&destype=cache&desformat=pdf

test.rdf from Oracle works only with destype=cache, not with destype=file.

CAUSE

No folder permission specified on rwserver.conf.

SOLUTION
Amened the configuration file rwserver.conf with below

<folderAccess><read>E:\Demo_App\temp;E:\APP\fmxs</read><write>E:\APP\fmxs\*</write><defaultWriteFolder>E:\Demo_App\temp</defaultWriteFolder></folderAccess>

file amending look like below

   <engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="1" minEngine="1" engLife="50">
      <!--property name="sourceDir" value="your reports source directory"/-->
      <property name="tempDir" value="E:\APP\fmxs"/>
      <!--property name="keepConnection" value="yes"/-->
   </engine>
<folderAccess>
<read>E:\Demo_App\temp;E:\APP\fmxs</read>
<write>E:\APP\fmxs\*</write>
<defaultWriteFolder>E:\Demo_App\temp</defaultWriteFolder>
</folderAccess>
   <engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" maxEngine="1" minEngine="0" engLife="50"/>