Oracle 12c 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

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"/>