Configuration of 10DGS Report Server

PURPOSE
-------
This note tells how to convert run_product to run_report_object while migratingfroms 6i to 10g because Run_product is not supported for web.
1) Create the table rw_server in your database.You can find the script in the
ORACLE_HOME\REPORT\ADMIN\SQL\rw_server.
2) Make sure that rp2rro.pll /plx is in the forms (registry) and you are able to generate the modified plx.
3) Use Migration assistant for conversion.
Run_product built in will be replaced to rp2rro.rp2rro_run_product and will creates parameters for the DESFORMAT,DESNAME,DESTYPE,SERVERNAME etc.
4). You need to give your correct reports server name in the SERVERNAME parameter
(RP2RROREPORTSERVER).
5) Make sure that the reports server is running or you can start it by using
rwserver server=Repserver from command prompt.
6) If you are running report on Web and if the output needs to be shown in the browser
window, then the reports DESTYPE should be set to CACHE or FILE and not SCREEN or
PREVIEW.
Note: If you are not using Migration assistance then you will have to manually change the name
of function “Run_Product” to “rp2rro.rp2rro_run_product”. Also you have to create the
fallowing parameters
In the calling form.
1) RP2RRODESFORMAT ( Set initial value =HTMLCSS)
2) RP2RRODESNAME
3) RP2RRODESTYPE ( Set initial value =CACHE)
4) RP2RROREPORTSERVER ( Set initial value =Your report server name)
5) RP2RROVIRTUALDIR ( Set initial value =/reports/)
6) RP2RROREPORTSINTERFACE ( Set initial value =rwservlet)

How to install WebUtil on 10.1.2.x OAS on Windows ?

Applies to:
Oracle Forms - Version: 10.1.2MS WindowsMicrosoft Windows
Goal
How to install WebUtil on 10.1.2.x OAS on Windows ?
Solution
1)- Download Webutil files from the following link: - Webutil version 1.0.6
( With Oracle developersuite 10.1.2.2 or higher , webutil 10.1.2.2.x will be automatically installed !)
It is not recommented to use with Forms 10.1.2.2 or higher webutil version 1.0.6 !
- WebUtil Demo from OTN
- The JACOB libraries version 1.8
2)- Copy the following files into %ORACLE_HOME%\forms\webutil :
(a) jacob.dll ---> included in jacob_18.zip
(b) ffisamp.dll ---> included in Webutil_demo.zip
(c) d2kwut60.dll ---> included in webutil_106.zip, under webutil subfolder
(d) JNIsharedstubs.dll ---> included in webutil_106.zip, under webutil subfolder
(e) sign_webutil.bat ---> included in webutil_106.zip, under webutil subfolder
Note: If files already exist then do not replace
3)- Copy the following files to %ORACLE_HOME%\forms\java :
a) webutil_106\java \forms_base_ie.js
b) webutil_106\java \forms_ie.js
c) webutil_106\java \frmwebutil.jar
d) jacob_18\jacob.jar
Note: If files already exist then do not replace
4)-Sign the "jacob.jar & frmwebutil.jar
- start the command prompt - cd %ORACLE_HOME%\forms\java
- set JDK_HOME=%ORACLE_HOME%\JDK - set PATH=%ORACLE_HOME%\jdk\bin;%PATH%
- set JINIT_HOME= C:\Program Files\Oracle\JInitiator 1.3.1.22 - %ORACLE_HOME% \forms\webutil\sign_webutil.bat %ORACLE_HOME%\forms\java\jacob.jar (For Jacob.jar)
- %ORACLE_HOME%\forms\webutil\sign_webutil.bat %ORACLE_HOME%\forms\java\frmwebutil.jar) (For frmwebutil.jar)


For Example:
E:> cd 10ghome\forms\java
E:\ 10ghome\forms\java> set JDK_HOME=E:\10GHOME\JDK
E:\ 10ghome\forms\java> set path=E:\10GHOME\jdk\bin;%PATH%
E:\ 10ghome\forms\java> set JINIT_HOME = C:\Program Files\Oracle\JInitiator 1.3.1.22
E:\ 10ghome\forms\java>E:\10GHOME\forms\webutil\sign_webutil.bat E:\10GHOME\forms\java\jacob.jar (For Jacob.jar)
E:\ 10ghome\forms\java>E:\10GHOME\forms\webutil\sign_webutil.batE:\10GHOME\forms\java\frmwebutil.jar
(For frmwebutil.jar)

Here make sure you have given the complete path for jarsigner tool and also JDK_HOME is set accordingly.
5)-Copy the following files from webutil_106\server to %ORACLE_HOME%\forms\server
- webutil.cfg
- webutilbase.htm
- webutiljini.htm
-webutiljpi.htm
Note: If files already exist then do not replace
6)- The following variable must be defined in %ORACLE_HOME%\forms\server\default.env:
WEBUTIL_CONFIG=\forms\server\webutil.cfg
7). The following jars must be included in the CLASSPATH in forms/server/default.env:
%ORACLE_HOME%\forms\java\frmall.jar;%ORACLE_HOME%\forms\java\frmwebutil.jar;%ORACLE_HOME%\forms\java\jacob.jar;%ORACLE_HOME%\jdk\jre\lib\rt.jar

8)- The configuration file formsweb.cfg should have the following section :
[webutil
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar
lookAndFeel=oracle


(Note that in default section we have to change the fallowing parameter
archive_jini=frmall_jinit.jar to archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar)

09)- The following virtual path must be defined in the %ORACLE_HOME%\forms\server\forms.conf file:
AliasMatch ^/forms/webutil/(..*) "%ORACLE_HOME%/forms/webutil/$1"
10)- Open webutil.cfg file and add the following line
Add the following line : install.syslib.0.user.1=ffisamp.dll409601.0true below these lines : install.syslib.0.7.1=jacob.dll942081.0true
install.syslib.0.9.1=JNIsharedstubs.dll655821.0true
install.syslib.0.9.2=d2kwut60.dll1925121.0true
12)- In the webutil.cfg file ensure you have the lines
transfer.appsrv.workAreaRoot=d:\temp transfer.appsrv.accessControl=FALSE (Default is TRUE)transfer.database.enabled=TRUE (Default is FALSE)transfer.appsrv.enabled=TRUE (Default is FALSE)13)- Run the script "create_webutil_db.sql" (included in webutil_106.zip file or in %ORACLE_HOME\forms ).
14)- Open forms builder and connect.Compile ALL" (shift-Control-K) form and webutil.pll ,then generate the fmx and plx using (Control-T).
(location of webutil.pll is %ORACLE_HOME\forms)

15) Attach the webutil.pll with form
16) Attach the webutil.olb with form (Open the object library drag the Webutil object into
objects groups)
17) Now replace Get_File_Name, Host and Text_IO with Client_Get_File_Name, Client_Host and Client_Text_IO.
18) Save and Compile the form.
Webutil Documentation 18)-You may also run the diagnostic test form described in the following note for furthur checking on the Webutil configuration : Note 553849.1Webutil Diagnostic Test Form For Checking Webutil Configuration

If Error Message After the configuration (oracle.forms.webutil.file.FileFunctions bean not foundWEBUTIL_FILE.FILE_SELECTION_DIALOG_INT will not work)

The problem I found was that for some reason, in the formsweb.cfg file, the webutil section parameters are not all recognized. So if the parameter is in the default section of the file and then it is subsequently redefined within the webutil section, the duplicate parameters in the webutil section are igrnored. Therefore, I have to update archive_jini to archive_jini=frmall_jini.jar,frmwebutil.jar,jacob.jar (In default Section) and things came up working for me.