This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Jan 16, 2013 12:38 PM by newbi_egy RSS

running a report from within oracle forms builder

newbi_egy Explorer
Currently Being Moderated
db and dev 10g rel2
hi all,
iam trying to run a report from with oracle ?
i searched all links on the internet about running a report and configuring the oas reports services like this link
(http://docs.oracle.com/cd/B14099_19/bi.1012/b14048/pbr_conf.htm)
, but unfortunately i can not deal with such this task , even i do not know what the first step should i do is ?

if you can guide me step by step please ?

first thing i am doing is creating a report object in the forms builder's object navigator named "report6",with a filename called "report6" ,not based on a block (this what i've been asked to specify when the wizard appeared when i clicked on the "report" node in the object navigator of forms builder), but still did not save the report i created and created a button then wrote this code in it :
declare
repid  report_object ; 
v varchar2(100) ;
begin 
          
     repid := find_report_object('report6') ; 
           

     v := run_report_object(repid) ; 

     
end ; 
to see this error when i run the form and click the button :
frm-41211: integration error :ssl failure running another product .
this is the task from scratch ,
so
what should i do to handle this error and run my report ?what is the first step ?
  • 1. Re: running a report from within oracle forms builder
    yoonas Expert
    Currently Being Moderated
    See the link http://halimdba.blogspot.com/2009/04/frm-41211-integration-error-ssl-failure.html
  • 2. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    See the link http://halimdba.blogspot.com/2009/04/frm-41211-integration-error-ssl-failure.html
    i saw it , and that was written :
    You receive the above error when using RUN_PRODUCT or RUN_REPORT_OBJECT in forms:

    This can occur for a number of reasons
    cause no 1 :"Report Server" property of "Reports" object is not set.

    and sure it is not set , because i do not know what to put in it , because i do not know my server's name ?
    how to get it ?

    thanks
  • 3. Re: running a report from within oracle forms builder
    Andreas Weiden Guru
    Currently Being Moderated
    Try
    http://server:port/reports/rwservlet/showjobs
    or
    http://server:port/reports/rwservlet/showenv
    It should show you the name of the reports-server

    Edited by: Andreas Weiden on 12.01.2013 17:16
  • 4. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    Try http://server:port/reports/rwservlet/showjobs
    i've typed it in the "report server" property to see a message when i run the form and press the buuton telling me :
    "unable to connect to the report server http://server:port/reports/rwservlet/showjobs"
    "unable to connect to the report server http://server:port/reports/rwservlet/showenv"

    ??
  • 5. Re: running a report from within oracle forms builder
    Andreas Weiden Guru
    Currently Being Moderated
    This
    http://server:port/reports/rwservlet/showjobs
    is a url, and you type in url's in your web-browser. The resulting page in the browser should contain the name of the reports-server.

    And, of course, you have to replace "server" and "port" in the url by your local values .
  • 6. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    http://server:port/reports/rwservlet/showjobs
    And, of course, you have to replace "server" and "port" in the url by your local values .
    local values which are ?
    i can replace "server" with "localhost" or that is the link appears in the address bar of my browser when i run a form . http://stepdev:8889/forms/frmservlet

    i think these are the local values you mean "stepdev" for "server" , and "8889" for port ?
  • 7. Re: running a report from within oracle forms builder
    yoonas Expert
    Currently Being Moderated
    Try
    >
    http://stepdev:8889/reports/rwservlet/showenv
  • 8. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    i am sorry , the llink i've posted http://stepdev:8889/forms/frmservlet was another pc's


    but i am working on my pc now , and this is in which i interest , when i run a form on my pc , i see this link :
    http://semsem:8889/forms/frmservlet

    so i tried
    http://semsem:8889/reports/rwservlet/showenv

    and it ends to "REP-51002: Bind to Reports Server rep_semsem failed " ??
  • 9. Re: running a report from within oracle forms builder
    Andreas Weiden Guru
    Currently Being Moderated
    And... did you do a search for REP-51002 ?

    At least you have your reports-server-name now.

    open a dos-box and try the following from the directory $ORACLE_HOME/bin, where $ORACLE_HOME is the base-directory of your forms-installation
    rwdiag -findAll
    or
    rwserver -start rep_semsem
    then try the url again.
  • 10. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    rwdiag -findAll
    the output is :
    channel address = 228.5.6.7
    channel port = 14021
    rwserver -start rep_semsem
    the output is a message telling me
    "please consult the installation guides for how to set up and run this program"

    ??
  • 11. Re: running a report from within oracle forms builder
    Andreas Weiden Guru
    Currently Being Moderated
    "please consult the installation guides for how to set up and run this program"
    Do as suggested.
  • 12. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    is this sending me to the configuration of report service ? or what installation guides do it mean ?
  • 13. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    ok , i've to do the job , so let my pc go , let's try it with the stepdev pc ,
    i've posted the link as you said
    http://stepdev:8889/reports/rwservlet/showenv
    and that was the result

    SERVER_NAME           stepdev
    SERVER_PORT           8889
    SCRIPT_NAME           /rwservlet
    SERVER_PROTOCOL           HTTP/1.1
    SERVER_SOFTWARE           undefined
    GATEWAY_INTERFACE           undefined
    SERVER_PORT_SECURE           undefined
    ACCEPT           text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    REQUEST_METHOD           GET
    REMOTE_HOST           stepdev
    REMOTE_ADDR           192.168.1.150
    REMOTE_USER           undefined
    AUTH_TYPE           undefined
    PATH_INFO           showenv
    QUERY_STRING           undefined
    PATH_TRANSLATED           E:\DevSuiteHome_1\reports\j2ee\reports_ids\web\showenv
    CONTENT_LENGTH           undefined
    CONTENT_TYPE           undefined
    AUTHORIZATION           undefined
    USER-AGENT           Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20100101 Firefox/17.0
    REMOTE_IDENT           undefined
    REFERER           undefined
         
    OracleAS Reports Services - Servlet Environment Variables      
    Select to jump to the top of the page           Return to Top
    KeyMapFile           E:\DevSuiteHome_1\reports\conf\cgicmd.dat
    DBAUTH           E:\DevSuiteHome_1\reports\templates\rwdbauth.htm
    SYSAUTH           E:\DevSuiteHome_1\reports\templates\rwsysauth.htm
    server           undefined
    DIAGNOSTIC           yes
    traceopts           undefined
    ERRORTEMPLATE           E:\DevSuiteHome_1\reports\templates\rwerror.htm
    SERVER_IN_PROCESS           yes
    COOKIEEXPIRE           30
    ENCRYPTIONKEY           reports9i
    DIAGHEADTAGS           undefined
    DIAGBODYTAGS           undefined
    HELPURL           undefined
    RELOAD_KEYMAP           NO
    IMAGEURL           http://stepdev:8889/reports/rwservlet
    SINGLESIGNON           yes
         
    OracleAS Reports Services - Server and Engine Environment Variables      
    Select to jump to the top of the page           Return to Top
    PATH           E:\DevSuiteHome_1\jdk\jre\bin\classic;E:\DevSuiteHome_1\jdk\jre\bin;E:\DevSuiteHome_1\jdk\jre\bin\client;E:\DevSuiteHome_1\jlib;E:\DevSuiteHome_1\bin;E:\DevSuiteHome_1\jre\1.4.2\bin\client;E:\DevSuiteHome_1\jre\1.4.2\bin;E:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
    DISPLAY           
    LD_LIBRARY_PATH           
    ORACLE_HOME           E:\DevSuiteHome_1
    TNS_ADMIN           
    NLS_LANG           AMERICAN_AMERICA.AR8MSWIN1256
    USER_NLS_LANG           
    RW           E:\DevSuiteHome_1\reports
    REPORTS_PATH           E:\DevSuiteHome_1\repadm61\srw;E:\DevSuiteHome_1\cgenr61\admin\crretc;E:\DevSuiteHome_1\cgenr61\admin;E:\DevSuiteHome_1\reports\templates;E:\DevSuiteHome_1\reports\samples\demo;E:\DevSuiteHome_1\reports\integ;E:\DevSuiteHome_1\reports\printers;
    REPORTS_TMP           C:\DOCUME~1\STEP\LOCALS~1\Temp
    REPORTS_TAGLIB_URI           /WEB-INF/lib/reports_tld.jar
    java.class.path           E:\DevSuiteHome_1\j2ee\home\lib\ojsp.jar;E:\DevSuiteHome_1\reports\jlib\rwrun.jar;E:\DevSuiteHome_1\jlib\zrclient.jar
    sourceDir           
    tempDir           
    useDataCache           
    ignoreDataParameter           

    what should i do now ?

    2- if you could tell me again what installation guide should i read ?
    thanks again
  • 14. Re: running a report from within oracle forms builder
    newbi_egy Explorer
    Currently Being Moderated
    would not you wish to complete the thread ?
    2- if you could tell me again what installation guide should i read ?
    thanks again
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points