Forum Stats

  • 3,770,740 Users
  • 2,253,161 Discussions
  • 7,875,572 Comments

Discussions

Not able to fetch rdf report file from newly created applications

sai4u4ever
sai4u4ever Member Posts: 2 Green Ribbon

Hi Team,

I am using Oracle fusion middleware version 12.2.1.3 , I already have working application named "APP1" , I am accessing it through IE "https://serverName:9403/forms/frmservlet?config=APP1"

Now I have created new DEV application "APP1_DEV" on same server on same port like, with below changes

1) In /WebBase/user_projects/domains/$domain/config/fmwconfig/servers/WLS_FORMS_APP1/applications/formsapp_12.2.1/config/formsweb.cfg

placed new block for APP1_DEV with same details of APP1 with below updated changes.

[APP1_DEV]

envFile=forms-APP1_DEV.env


2) In forms-APP1_DEV.env file updated below entry

FORMS_PATH=/WebBase/data/APP1_DEV/fmx

3) In

/WebBase/user_projects/domains/$domain/config/fmwconfig/components/FORMS/mbeans/mbeans.xml file update below block

<jmx-config-mbean class="oracle.forms.config.mbeans.GenericPropertyValueConfig" management-interface="oracle.forms.config.mbeans.GenericPropertyValueConfigMXBean" objectname="oracle.forms:name=forms-APP1_DEV.env,type=Type_default.env,wls_server=WLS_FORMS_APP1,appName=formsapp">

<config-file path="/WebBase/user_projects/domains/$domain/config/fmwconfig/servers/WLS_FORMS_APP1/applications/formsapp_12.2.1/config/forms-APP1_DEV.env"/>

<persistence-manager class="oracle.forms.config.mbeans.FormsPropertyPersistenceManager">

<property key="PropValueSeparator" value="="/> </persistence-manager> </jmx-config-mbean>

4) In

/WebBase/user_projects/domains/$domain/config/fmwconfig/components/ReportsServerComponent/repserver1_WL12BT01/rwserver.conf file added below part.

<environment id="default">

<envVariable name="REPORTS_PATH" value="/WebBase/data/APP1/rdf:/WebBase/data/APP1_DEV/rdf"/>

</environment>

--------------------------

Now I am accessing the new APP1_DEV using

https://serverName:9403/forms/frmservlet?config=APP1_DEV --> It is working fine.

But, when I am accessing https://serverName:9402/reports/rwservlet/showjobs=?server=repserver1_WL12BP01B and fetching reports for APP1_DEV the rdf file is coming from WebBase/data/APP1/rdf folder.

I am expecting it from WebBase/data/APP1_DEV/rdf folder.

Please help me to sort out this issue. Did I need to change any other configurations?

Answers

  • Suresh-Sangaran-Oracle
    Suresh-Sangaran-Oracle Member Posts: 205 Employee
    edited Sep 15, 2021 2:44AM

    Hello,

    Directory Paths defined in REPORTS_PATH takes precedence in reports source(RDF) search. During runtime, the search is performed in the order of directories defined in REPORTS_PATH. If you have the same RDF in both locations and if the Reports server finds the RDF in the first directory (in your case /WebBase/data/APP1/rdf) that source is used to execute reports.

    Use different envVariable for each path.

    <environment id="APP1">

    <envVariable name="REPORTS_PATH" value="/WebBase/data/APP1/rdf"/>

    </environment>

    <environment id="APP1_DEV">

    <envVariable name="REPORTS_PATH" value="/WebBase/data/APP1_DEV/rdf"/>

    </environment>


    Ref: 7.2.2 Dynamic Environment Switching

    https://docs.oracle.com/middleware/12213/formsandreports/use-reports/pbr_conf002.htm#RSPUB23301

    Regards,

    Suresh