Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REP-69 - REP-56132: Reports 12c Windows Server

myluismFeb 11 2022

Hi All. We have a Forms and Reports 12.2.1.4 installation on a Windows Server.
Getting this error upon trying to execute any reports from Forms (RUN_REPORT_OBJECTor rwservlet).
Installation was running fine. Last modification was to enable folder access (DYSTYPE=FILE).
This is my rwserver.conf (modified from EM Manager MBEAMS):
<?xml version="1.0" encoding="UTF-8"?>
<server xmlns="http://xmlns.oracle.com/reports/server" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/>
</cache>
<engine class="oracle.reports.engine.EngineImpl" engLife="50" id="rwEng" maxEngine="1" minEngine="1"/>
<engine class="oracle.reports.urlengine.URLEngineImpl" engLife="50" id="rwURLEng" maxEngine="1" minEngine="0"/>
<security class="oracle.reports.server.RWJAZNSecurity" id="rwJaznSec"/>
<destination class="oracle.reports.plugin.destination.ftp.DesFTP" destype="ftp"/>
<destination class="oracle.reports.plugin.destination.webdav.DesWebDAV" destype="WebDav"/>
<job engineId="rwEng" jobType="report"/>
<job engineId="rwURLEng" jobType="rwurl"/>
<notification class="oracle.reports.server.MailNotify" id="mailNotify">
<property name="succnotefile" value="succnote.txt"/>
<property name="failnotefile" value="failnote.txt"/>
</notification>
<jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
<property name="dbuser" value="SFIGOAUX"/>
<property name="dbpassword" value="csf:reports:repo"/>
<property name="dbconn" value="192.168.0.1:1521/pdb_wfigo"/>
</jobStatusRepository>
<connection idleTimeOut="15" maxConnect="50"/>
<queue maxQueueSize="1000"/>
<folderAccess>
<read>C:\webFIGO\Temp</read>
<write>C:\webFIGO\Temp</write>
</folderAccess>
<proxyInfo>
<proxyServers>
<proxyServer name="$$Self.proxyHost$$" port="$$Self.proxyPort$$" protocol="all"/>
</proxyServers>
<bypassProxy>
<domain>$$Self.proxyByPass$$</domain>
</bypassProxy>
</proxyInfo>
<pluginParam value="%MAILSERVER_NAME%" name="mailServer"/>
</server>
According to some research done error is caused by absence of the RDF/JSP report's location in the REPORTS_PATH. Since this is windows (no reports.sh) i just added the following path to the REPORTS_PATH via regedit:
C:\webFIGO\Bin\Prod;C:\Oracle\Middleware\FMW\reports\templates;C:\Oracle\Middleware\FMW\reports\printers;C:\Oracle\Middleware\FMW\user_projects\domains\frsdomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\
Restarted In_processs report server but now things got worse, I can run no report at all.
Any idea?
Thanks so much in advance !!!.

This post has been answered by myluism on Feb 18 2022
Jump to Answer
Comments
Post Details
Added on Feb 11 2022
8 comments
858 views