Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    45

    Unhappy Unanswered: WebForms calling WebReports PBs

    Hello,

    I modified my Forms/Reports 9i application to run my Reports over the Web.
    Under Oracle 9iDS (Develope Suite) installed on Windows XP Pro, I can invoke and run my Reports with Parameter forms from Forms. This works pretty well.

    I modified my code as suggested in the Oracle Documentation and do not use a default migration PLL library as generated by the FMA (Forms Migration Assistant) tool.

    repid := find_report_object('BTPRTINV');
    reportserver:= 'RepSRV';
    runformat := 'htmlcss';

    RUN_REPORT_OBJECT_PROC(repid,'rep_Linux2005','HTML CSS',CACHE,'H:\TEMP\BTREPPRO_test.rdf',
    'PARAMFORM=YES P_ACTIONS=http://terrain2004:8888/reports/rwservlet?' ||
    ' P_PROJECT=' || :variable.project ||
    ' P_SERVER_NAME='||reportserver ||
    ' P_SURVEYOR=' || NVL(to_char(:variable.surveyor),'0') ||
    ' P_USER_CONNECT='||vc_connect,
    '/reports/rwservlet');
    --------------------------
    THe problem is the deployment on my Linux Red Hat Enterprise 3 (ES) server.
    I modified my code to reflect the Linux server environment. Here is a sample call to my function under iAS:

    repid := find_report_object('BTPRTINV');
    reportserver:= 'rep_Linux2005';
    runformat := 'htmlcss';

    RUN_REPORT_OBJECT_PROC(repid,'rep_Linux2005','HTML CSS',CACHE,'/u01/app01/oracle_iAS_10g/forms90/Source_9i/Btreppro.rdf',
    'PARAMFORM=YES P_ACTIONS=http://Linux2005:7780/reports/rwservlet?' ||
    ' P_PROJECT=' || :variable.project ||
    ' P_SERVER_NAME='||reportserver ||
    ' P_SURVEYOR=' || NVL(to_char(:variable.surveyor),'0') ||
    ' P_USER_CONNECT='||vc_connect,
    '/reports/rwservlet');

    When I run my application over the Web, I get an error message like 'Report failed with message: TERMINATED_WITH_ERROR'.
    This is a report status message that comes from the RP2RRO.PLL. THe problem is that I do not make reference to this PLL in my modified Forms/Reports application.

    1) Does anyone have an idea, why I am getting an error like this ?
    2) Is there anyway for me to rename my 'in-process' server called rep_Linux2005 to RepSRV ?
    3) Do I need to lauch a seperate stand-alone server through rwserver server=RepSRV everytime I will run my WebReports from WebForms ?

    PT

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It has been about 6 months since I last worked with 9iAS R2 & I no longer have access to it.


    >1) Does anyone have an idea, why I am getting an error like this ?
    You are doing thing not 100% correctly.

    >2) Is there anyway for me to rename my 'in-process' server called rep_Linux2005 to RepSRV ?
    IIRC, technically no, but there is nothing to stop you from creating you own Reports Server engine/process; which is what I did.

    >3) Do I need to lauch a seperate stand-alone server through rwserver server=RepSRV everytime I will run my WebReports from WebForms ?
    NO, via a scipt in /etc/rc3.d I start my own Reports Server at boot time.

    More general comments & suggestions follow.
    At least two different ways exist to submit a report;
    1) via RUN_REPORT_OBJECT (which does not work when the Report Server name has an UNDERSCORE "_" character in it).
    2) via rwservlet using a properly formated URL string with all necessary keyword=value pairs included
    FWIW - I wrote a small PERL script which built the URL & submitted it so that I could run batch scripts for nightly (unattended) report generation.

    HTH & YMMV

    HAND!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Posts
    45

    Unhappy Run_report_object_proc

    Hello,

    COuld you be a little more specific, when you mention that I am not doing things 100% correctly ?

    Also, in the Oracle documentation frm9isrw9i, it is mentionned that I should call WebReports from WebForms through a generic function called RUN_REPORT_OBJECT_PROC. The sample code for that function is given in the corresponding Oracle document.

    I have also read that, I can call WebReports using the in-process Reports server using the Web.Show_Document built-in.

    2) Should I modify the RUN_REPORT_OBJECT_PROC in some way ?

    Note also, that I have tried to use a tool called the FMA (File Migration Assistant) that automatically generated an attached library called RP2RRO PLL library. This function is supposedly designed to call WebReports from WebForms but I have not seen any coding examples where this PLL is used to call WebReports containing Parameter Forms.

    3) Any suggestions ?

    PT

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://download-west.oracle.com/docs...a92175/toc.htm

    If you have or install PERL DBD/DBI, the following shows how to submit reports from the *nix command line.
    Code:
    #!/home/utils/perl/bin/perl -w
    use LWP::UserAgent;
    use HTTP::Request::Common qw(POST);
    $ua = LWP::UserAgent->new() || die "Unable to create new UserAgent object";
    $url = 'http://reports900.abc.com/reports/rwservlet';
    %form_data = (
    SERVER => 'repcosmora003',
    USERID => 'username/password@dev',
    REPORT => 'sysdate.rdf',
    MODE => 'CHARACTER',
    DESTYPE => 'FILE',
    DESNAME => '/home/printjobs/ljdev/abc-sysdate003.txt',
    STATUSFORMAT => 'xml'
    );
    
    
    $request = POST($url, \%form_data);
    $response = $ua->request($request);
    print $response->content();
    exit;
    HTH & YMMV
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •