Reports Serveur et cgicmd.dat

[solean45]

salut

j'ai un souci lorque je lance un forms en mode web et qu'a travers c'ette forms je lace en état ça me ratourne le message suivant

Erreur : L'URL demandée est introuvable ou ne peut pas être prise en charge maintenant.
Oracle Reports Server CGI - Clé "Section1" non reconnue. Causes poss. : syntaxe URL incorr. ; URL introuv. dans fichier corresp. de clés.

en effet dans mon fichier cgicmd.dat j'ai définit une section avec les info confidentiel que l'utilisateur ne doit pas voir mais apparament le server Reports ne fait pas le mapping avec ce fichier .

donc si vous avez des réponses je suis tout ouïe

[SheikYerbouti]

Et l'appel du report, on peut voir ?

[solean45]

voici l'appel du report :

Code :

1
2
3
 
LC$Cmd := LC$Rep60_Test || '?Section1&report=note_serie_mere_chauss2.rdf' || '&P_NOM='|| name_in('GLOBAL.NOM_UTIL')||'&PARAMFORM=no'||'&DESNAME=prt04_letter'||'&PRINTJOB=no';
Web.show_document(LC$Cmd, '_blank');

mais est ce qu'on doit pas définir quelque part pour le server Forms qu'il doit utiliser le fichier de mapping cgicmd.dat?

[SheikYerbouti]

et LC$Rep60_Test contient quoi ?
avez-vous essayé de lancer à la main ? (coller l'url dans le navigateur)

[solean45]

Code :

LC$Rep60_Test Varchar2(128) := 'http://test:80/cgi-bin/rwcgi60.exe';

j'ai essayé de le lancer à la main tous fonctionne correctement bien sur si je remplace section1 par les paramêtres de connection , vraiment c'est un souci qui se concentre au niveau de mon fichier cgicmd.dat je sais pas ou je doit renseigner le fait qu'il fait que le serveur utilise le fichier cgicmd.dat

[SheikYerbouti]

Hum. j'utilise rwservlet qui fonctionne parfaitement. Avec le cgi je ne sais pas. Il faudrait consulter la base de connaissance sur Metalink, ou poser la question sur le forum Reports d' OTN.

[solean45]

ok et comment puis je faire pour utiliser rwservlet car moi je suis p&as sous 9i ou 10g je suis sous 6i est ce que 6i le propose

[SheikYerbouti]

Peut-être vous faut-il ajouter le paramètre &KEYMAP

PURPOSE
-------
This Notes explains a working solution to use the CGICMD.DAT keys
with Oracle Reports integrated with Portal Security.
Currently with Portal 3.0.9.x and Reports 6.0.8.x, there is no way
to use CGICMD.DAT keys due to Bug 1657683 fixed in Reports 9.

SCOPE & APPLICATION
-------------------
This Note is intended for any Portal/Reports developer who needs
to use CGICMD.DAT keys with Oracle Reports Security. Without this
solution, available options for Database Authentication before a
Portal User can run an integrated Reports is:
1- Provide database authentication information username/password@
connect_string in the DB Authentication page, the first time
the report is run.
2- Create a USERID Portal Parameter for the Report, set its value
to username/password@connect_string and mark this parameter as
Not Visible to User. The advantage of this option is that the
user will not be prompted to do database authentication and the
Report will run using the database connect information provided
for the USERID parameter. The disadvantage is that the USERID
Parameter and its value will be visible to the user in the URL.
The login information may be hidden if the user published the
Report in a Content Area as a "Link That Displays Item In
Folder Area ".
This Note will explore a 3rd option to use a CGICMD.DAT key that
will hold the login information.
How to Setup Reports in Portal to Use CGICMD.DAT File
-----------------------------------------------------

Typically, the URL that runs a Report in a Report Server takes the
following format:
http://<machine.domain>/<cgi_virtual...ue&Param=Value&...
If a CGICMD.DAT key to be used the URL will look like:
http://<machine.domain>/<cgi_virtual...ue&Param=Value&...
During the setup of Reports Servers in the Portal Admin Tab ->
Oracle Reports Security Settings -> Report Server Access, the
"Oracle Reports Web Gateway URL" value must be provided for each
Report Server. This usually takes the following format:
http://<machine.domain>/<cgi_virtual...ports_cgi_prog>
For Example:
http://<machine.domain>/dev60cgi/rwcgi60.exe
Oracle Portal will append to the above URL all Required Parameters
to run the Reports plus all Optional Parameters defined by the
user before submitting the URL, so a URL with parameters may look
like:
http://<machine.domain>/dev60cgi/rwc...desformat=HTML&...
The idea behind the solution is:
1- Create an Optional Parameter for each Report called KEYMAP. This
can be defined in the Optional Parameters Page of a Report
Definition Access File in Portal.
2- Set the value of this parameter to the name of a Key section in
CGICMD.DAT (located under <Developer_Home\REPORT60\SERVER). This can
by clicking on the Customize link of a Report Definition Access File.
For example, if we set the value of the KEYMAP Parameter to "Conn",
then the resultant URL may look like:
http://<machine.domain>/dev60cgi/rwc.....&KEYMAP=Conn&...
To instruct the Report Server to consider "Conn" as key to lookup in
the CGICMD.DAT file the URL need to be changed to:
http://<machine.domain>/dev60cgi/rwc...desformat=HTML&...
3- To be able to do the above translation, a Perl Script can be
used to parse the original URL (with KEYMAP=Conn) and generate
the new URL (with rwcgi60.exe?Conn&). Perl interpreter is
installed with Oracle 9i Application Server.
Copy the following code in a file called prwcgi60.pl and save the
file to the same directory where rwcgi60.exe exists. On NT, this
directory is <Developer_Home>\TOOLS\web60\cgi. For other operating
system, you may need to locate the directory of this file.
--------------- Code Starts Here ---------------
#!D:\oracle\iSuites\Apache\perl\5.00503\bin\MSWin32-x86\perl.exe
##
## prwcgi60 -- CGI program to parse Oracle Reports URL
##
$QueryString = $ENV{'QUERY_STRING'};
$CGIDirectory = "/dev60cgi/";
$CGIName = "rwcgi60.exe";
-@NameValuePairs = split (/&/, $QueryString);
foreach $NameValue (@NameValuePairs)
{
($Name, $Value) = split (/=/, $NameValue);

if (uc $Name eq "KEYMAP")
{
$KeyMap = $Value;
}
if (uc $Name ne "KEYMAP")
{
if ($RevisedQueryString ne "")
{
$RevisedQueryString = $RevisedQueryString . "&";
}
$RevisedQueryString = $RevisedQueryString . $Name . "=" . $Value;
}
}
if ($KeyMap ne "")
{
$KeyMap = $KeyMap . "&"
}
$RevisedQueryString = $KeyMap . $RevisedQueryString ;
$URL = $CGIName . "?" . $RevisedQueryString ;
print("location:$URL\n\n");
---------------- Code Ends Here ----------------
NOTE: Due to metalink having a filter to drop lines starting with '@', the
10th line of this file must be
if not, the perl script will not run.
The dash preceeding the @ sign above is there only so that the rest of the line
is visible in MetaLink.
In the above script, the following lines need to be changed based
on your setup:
#!D:\9iAS/Apache/perl/5.00503/bin/MSWin32-x86/perl.exe
Change the above line to reflect the location of Perl interpreter.

$CGIDirectory = "/dev60cgi/";
Change the above line to reflect your web server virtual directory
that contains the Reports CGI file (rwcgi60.exe)

$CGIName = "rwcgi60.exe";
Change the above line to reflect the name of the Reports CGI file.
For Windows platform, this is the default. For other operating
systems, you may use rwcgi60 only.

4- Change the value of "Oracle Reports Web Gateway URL" accessible
from Portal Admin Tab -> Oracle Reports Security Settings ->
Report Server Access to have this new value:
http://<machine.domain>/<cgi_virtual...y>/prwcgi60.pl
5- Make sure you have a key in your CGICMD.DAT file with the same
name as the value of the KEYMAP Parameter. For example:
Conn: userid=scott/tiger@orcl %*
6- Now run your Report after logging to Portal. You will not get
the DB Authentication Page, not the username/password appears
in the URL.

[SheikYerbouti]

PURPOSE
-------
For the Reports Web CGI 6.0, if map file configuration is used
then REPORTS60_CGIMAP specifies the path to RWCGI60 map file
(cgicmd.dat file for key mapping and DBAUTH).

REPORTS60_CGIMAP is mandatory for Reports Web CGI 6.0,
if map file configuration is used.
------------------------------------------------------
To check where Reports looks for cgicmd.dat file, type the following
in URL :
http://your_webserver:port/your_virt...60.exe/showmap
For Reports Web CGI 6.0 the default location of the cgicmd.dat file is
in <ORACLE_HOME>\REPORT60\SERVER.
Without setting REPORTS60_CGIMAP environment variable, rwcgi60.exe
looks for cgicmd.dat in <ORACLE_HOME>\REPORT60.
Therefore :
- Either you should change the default location of file cgicmd.dat
to be <ORACLE_HOME>\REPORT60
- Or you should define REPORTS60_CGIMAP=<ORACLE_HOME>\REPORT60\cgicmd.dat

<ORACLE_HOME> refers to the physical directory where Developer6i is installed.
It corresponds to the value of environnement variable ORACLE_HOME.