Tags: causes, eparameter, form, hitting, installed, oracle, own, patch, programming, reports, requested, run, submit, system, tools, url, windows

hitting submit on th eparameter form causes the requested url was not found

On Programmer » Development Tools

7,004 words with 9 Comments; publish: Sun, 10 Feb 2008 13:41:00 GMT; (20093.99, « »)

Hi,

I'm using reports 6i patch 10 on a Oracle 8.1.7.4 , all of it is installed on a windows xp system.

When I try to run one of my own reports through the web (still staying on the local machine) this works well for displaying the parameter form.

Hitting the submit button on the parameter form causes

Error: the requested url was not found, or cannot be served at this time

Oracle Reports Server CGI- reports server name is not specified

But the server name is in the command line

When I run the same report with paramform = no and specifying the required parameters in the command line everything runs well.

When running the supplied test report everything runs ok, with and without the parameter form.

Any idea what's going on?

Do I need to give more detailed info?

regards, Piet

All Comments

Leave a comment...

  • 9 Comments
    • Hi Pieter

      Are you sending the user parameters from the Parameter Form to Reports Server correctly.

      Regards

      Sripathy

      #1; Sun, 24 Feb 2008 01:10:00 GMT
    • Well, I have all the user parameters required for the report on the parameter form and that's where I change their values, I don't do anything specific for sending them to the reports server, as far as I know this is handled by the report when you enter values in the user parameters.

      Piet

      #2; Sun, 24 Feb 2008 01:11:00 GMT
    • Are you able to run diagnostic commands on the Reports Server?
      #3; Sun, 24 Feb 2008 01:12:00 GMT
    • Running it the way you specified it works well, also with keymap everything is ok then.

      The environment settings are

      RWCGI Environment

      Oracle Reports Server CGI60 version 6.0, a Win32 executable.

      HTTP Environment Variables (server):SERVER_NAME pdb-laptop

      SERVER_PORT 80

      SERVER_PORT_SECURE undefined

      SERVER_SOFTWARE Oracle WebDb Listener 2.1

      SERVER_PROTOCOL HTTP/1.0

      GATEWAY_INTERFACE CGI/1.1

      SCRIPT_NAME /dev60cgi/rwcgi60.exe/

      HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*

      HTTP Environment Variables (request):HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

      REQUEST_METHOD GET

      QUERY_STRING server=Rep60_PDB-LAPTOP-OraDevHome

      CONTENT_LENGTH undefined

      CONTENT_TYPE undefined

      REMOTE_HOST 127.0.0.1

      REMOTE_ADDR 127.0.0.1

      REMOTE_USER undefined

      REMOTE_IDENT undefined

      HTTP_REFERER undefined

      HTTP_COOKIE databaseid=bd2Ng49PxTNWh9Ks03Ga4AnAhXnC4SwGCtOXkzqe8NSDLcoIaZU=; lastuserid=bd2Ng49PxVwN3dWo3XGH8g==

      AUTH_TYPE undefined

      HTTP_AUTHORIZATION undefined

      PATH_INFO showenv

      PATH_TRANSLATED undefined

      Oracle Reports Server CGI60 Environment Variables:PATH C:\OraDevHome\bin;C:\OraHome\bin;C:\OraHome\Apache\Perl\5.00503\bin\mswin32-x86;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Ulead Systems\MPEG;C:\PROGRA~1\UTILIT~1\ULTRAE~1;"C:\Program Files\Symantec\Norton Ghost 2003\";C:\Program Files\Executive Software\DiskeeperWorkstation\

      ORACLE_HOME C:\OraDevHome

      RW60 C:\OraDevHome\REPORT60

      ORACLE_PATH undefined

      REPORTS60_PATH C:\OraDevHome\REPORT60\ADMIN\TEMPLATE\US;C:\OraDevHome\REPORT60

      REPORTS60_TMP C:\OraDevHome\REPORT60\TMP

      REPORTS60_CGIMAP undefined

      REPORTS60_CGIHELP undefined

      REPORTS60_CGIDIAGBODYTAGS undefined

      REPORTS60_CGIDIAGHEADTAGS undefined

      REPORTS60_CGINODIAG undefined

      USER_NLS_LANG undefined

      NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1

      Stdin is empty.

      CGI Command Line is used

      main.argv[0] C:\OraDevHome\tools\web60\cgi\rwcgi60.exe

      #6; Sun, 24 Feb 2008 01:15:00 GMT
    • Problem solved

      I installed reports 6i and patch 10. I do not know if the problem is caused by (or not yet solved by) patch 10.

      There are 2 templates (conf10.tdf and conf20.tdf) where something is missing.

      If you look at the report properties and then the before form value you should have

      <html>

      <body bgcolor="#ffffff">

      <form method=post action="_action_">

      <input name="hidden_run_parameters" type=hidden value="_hidden_">

      ...

      but in my templates

      action="_action_">

      <input name="hidden_run_parameters" type=hidden value="_hidden_">

      was missing, so the complete command line will never be generated when the parameter form is shown first.

      regards, Piet

      #7; Sun, 24 Feb 2008 01:16:00 GMT
    • I am on Patch 8 and experienced the same problem. Thanks for the update on how to fix it.
      #8; Sun, 24 Feb 2008 01:17:00 GMT