Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: Trying to call a report from FORMS 9i

    Setup: Forms 9i, Reports 9i, 9iDB (No AS)

    I have looked at a lot of documentation and examples to get to this point. None unfortunately have been related to non-AS applications. I do not know if that is what I am fighting or not.

    Here is my execution code:
    DECLARE
    rep_id REPORT_OBJECT;
    rep_result VARCHAR2(80);
    BEGIN

    rep_id := find_report_object('SETUP_VERIFICATION');

    SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_OTHER, 'work_order_arg='||:mdm_control_recipes.work_order );
    rep_result := RUN_REPORT_OBJECT(rep_id);

    END;

    Here are the values I have set in my Forms report object (it appears I needed this)
    Name = SETUP_VERIFICATION
    filename = Setup_Verification.jsp
    execution mode = runtime
    comm mode = Synchronous
    data source = <NULL>
    Rep dest type = Preview
    Rep dest name = jim
    (one thing I saw said that you needed to put something for dest name)

    I am getting a REP-0110 Unable to open file [garbage displayed here]RT=Setup_Verification.jsp USERID='QC/QC@bci92' DESTYPE='preview' DESNAME='jim' wprl_order_arg='9897''.
    REP-1070: Error while opening or saving document.

    My jsp file is located in my Forms directory (I do not want to hard code a path and I think that will work). I do not have a reports server (non-AS). I am guessing that garbage at the front is my problem, but have been unable to find any good info to go on.

    A helping hand would be appreciated. Or perhaps a swift kick (you can lead some people to knowledge, but you can't make them think)

    Oh yeah, the customer demo is Thursday 9AM
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Getting forms to successfully invoke a report is NON-TRIVIAL.
    If you'll send me an email with a functioning email for you,
    I'll try to asist.

    Here are a couple of real GOTCHAs.....
    1) RUN_REPORT_OBJECT can not/will not work with a Reports Server
    which has an underscore character "_" in its name.
    2) Forms by default does NOT use SSO; while Oracle's Reports Sever has SSO enabled by default
    3) does the functional equivalent display "reasonable" results
    http://reports.abc.com:7778/reports/rwservlet/showenv
    where you specify your FQHN or IP#
    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
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Thanks for the assist. I actually have an e-mail address for you from a discourse we had some months ago. To make sure it is correct I will probably ping you with it. If I do not get a response I will use a personal message.

    Thanks to your questions I have been able to put together enough information to start figuring out what is going on. I am not sure were this will lead me but I am going to run with it a while. I will probably be getting back to you soon. :-)
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You should have a couple email responses from me.

    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.

  5. #5
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    No response from a couple of attempts to get a hold of you.

    That whole "thinking" thing is over-rated. Based on your message to me about "showenv" I went looking for it. I did not find in the path you gave me so I thought it must be a difference between Unix andW2K. I did not try just running it as you printed it (the thinking thing got in the way).

    Anyway, break through ...

    Figured out what the report server name should be, now I get the very descriptive error "FRM-41214: Unable to run report". All the doc says is to check that your report server is running. It is set to "in-process" so my assumption is that it will be. I noticed that the SSO is on (as you said it would be). Trying to figure out how to turn that off. Before my next run at it.
    NOTE: Please disregard the label "Senior Member".

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    $ORACLE_HOME/reports/conf/rwservlet.properties
    SINGLESIGNON=NO
    After changing this value the Reports Server needs to be bounced.
    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.

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Also in $ORACLE_HOME/reports/conf should be a file which is named:
    <report_server_name>.conf; which is an XML configuration file.
    To get RW working I've had to comment out two sections within it.
    The two sections are the <security> & <destination> by:
    <!--security
    ...
    </security/-->
    and
    <!--destination
    ....
    </destination/-->
    Of course you'd be wise to save away original copies of these before modifying and file.
    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.

  8. #8
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    I set the SSO to NO and that had no affect. I commented (deleted actually) the security and destination sections and now the process junks for about 2 minutes and then comes back and says "FRM-41213: Unable to connect to the Report server rep_{name}. I had enabled trace and have some wonderful trace files.

    The most disturbing is the rep_{name}.log file. It contains:
    *** 2004/3/24 10:35:16:743 -- Reports Server is starting up
    *** 2004/3/24 10:35:25:336 -- Reports Server started up engine rwURLEng-0
    *** 2004/3/24 10:35:34:852 -- Engine rwEng-0 crashed

    The rwservlet.trc file has some disturbing things in it also. Does this give you any ideas?
    [2004/3/24 10:34:42:133] Debug 50103 (RWClient:RWClientInit): Get ORACLE_HOME from environment variable, oracle home: D:\oracle\ora92DS
    [2004/3/24 10:34:42:274] Exception 50125 (oracle.ias.repository.schema.SchemaException: Schema Configuration Files could not be located
    void oracle.ias.repository.local.IASPropertyCache.loadC ache()
    java.lang.String oracle.ias.repository.local.IASPropertyCache.readV alue(java.lang.String)
    void oracle.ias.repository.IASSchema.init()
    void oracle.ias.repository.IASSchema.<init>(java.lang.S tring)
    void oracle.ias.repository.SchemaManager.<init>(java.la ng.String)
    void oracle.reports.utility.OIDConnection.init(java.lan g.String)
    void oracle.reports.rwclient.RWClient.RWClientInit()
    void oracle.reports.rwclient.RWClient.init(javax.servle t.ServletConfig)
    com.evermind.server.http.ServletInstanceInfo com.evermind.server.http.HttpApplication.loadServl et(com.evermind.util.ByteString)
    com.evermind.server.http.ServletInstanceInfo com.evermind.server.http.HttpApplication.findServl et(com.evermind.util.ByteString)
    void com.evermind.server.http.HttpApplication.initPrelo adServlets()
    void com.evermind.server.http.HttpApplication.initDynam ic(com.evermind.server.http.HttpApplicationConfig)
    void com.evermind.server.http.HttpApplication.<init>(co m.evermind.server.Application, com.evermind.server.http.HttpSite, com.evermind.server.http.HttpApplicationConfig, java.lang.String, java.lang.String, boolean)
    com.evermind.server.http.HttpApplication com.evermind.server.Application.getHttpApplication (java.lang.String, java.lang.String, boolean, long, com.evermind.server.http.HttpSite, boolean)
    com.evermind.server.http.HttpApplication com.evermind.server.http.HttpServer.getHttpApplica tion(com.evermind.server.http.HttpApplicationRefer ence, com.evermind.server.http.HttpSite)
    com.evermind.server.http.HttpApplication com.evermind.server.http.HttpSite.getApplication(c om.evermind.util.ByteString)
    boolean com.evermind.server.http.HttpRequestHandler.proces sRequest(com.evermind.server.ApplicationServerThre ad, com.evermind.server.http.EvermindHttpServletReques t, com.evermind.server.http.EvermindHttpServletRespon se, java.io.InputStream, java.io.OutputStream, boolean)
    void com.evermind.server.http.HttpRequestHandler.run(ja va.lang.Thread)
    void com.evermind.util.ThreadPoolThread.run()
    ): Internal error oracle.ias.repository.schema.SchemaException: Schema Configuration Files could not be located
    [2004/3/24 10:34:42:290] Debug 50103 (OIDConnection:init): Failed to connect to OID server
    [2004/3/24 10:34:42:383] Debug 50103 (KeyMapParser:readKeyMapFile): file: D:\oracle\ora92DS\reports\conf\cgicmd.dat
    [2004/3/24 10:35:16:555] Info 50103 (RWClient:initCORBA): Startup in process server: rep_MPL-BARKUST
    [2004/3/24 10:35:31:836] Debug 50103 (RWClient:doGet): QueryString: null
    [2004/3/24 10:35:31:852] Info 50103 (RWClientrocessRequest): queryString:null
    [2004/3/24 10:35:31:899] Debug 50103 (CommandManager:handleWebCommand): cmdline: null, statusformat: null
    [2004/3/24 10:35:31:899] Debug 50103 (RWClientUtility:isFromPortal): portal: null
    [2004/3/24 10:35:31:899] Debug 50103 (RWClientUtility:isFromPortal): webdbversion: null
    [2004/3/24 10:35:31:899] Debug 50103 (RWClientUtility:getReportsServer): server: rep_MPL-BARKUST
    [2004/3/24 10:35:31:946] Debug 50103 (ReportRunner:connectToServer): New Connection request for userid: RWUser to server: rep_MPL-BARKUST
    [2004/3/24 10:35:32:24] Debug 50103 (ReportRunner:connectToServer): Connection succeeded for user: RWUser to server: rep_MPL-BARKUST
    [2004/3/24 10:35:32:24] Debug 50103 (CommandManager:handleCmdShowjobs): serverName: rep_MPL-BARKUST, statusformat: 2
    [2004/3/24 10:35:32:274] Debug 50103 (CommandManager:handleCmdShowjobsHtml): queueType: null
    [2004/3/24 10:35:32:336] Info 51022 (ReportRunner:Release): Connection object has been released
    [2004/3/24 10:36:5:790] Debug 50103 (RWClient:doGet): QueryString: null
    [2004/3/24 10:36:5:790] Info 50103 (RWClientrocessRequest): queryString:null
    [2004/3/24 10:36:5:790] Debug 50103 (CommandManager:handleWebCommand): cmdline: null, statusformat: null
    [2004/3/24 10:36:5:790] Debug 50103 (RWClientUtility:isFromPortal): portal: null
    [2004/3/24 10:36:5:790] Debug 50103 (RWClientUtility:isFromPortal): webdbversion: null
    [2004/3/24 10:36:5:790] Debug 50103 (RWClientUtility:getReportsServer): server: rep_MPL-BARKUST
    [2004/3/24 10:36:5:790] Debug 50103 (ReportRunner:connectToServer): New Connection request for userid: RWUser to server: rep_MPL-BARKUST
    [2004/3/24 10:36:5:790] Debug 50103 (ReportRunner:connectToServer): Connection succeeded for user: RWUser to server: rep_MPL-BARKUST
    [2004/3/24 10:36:5:821] Debug 50103 (CommandManager:handleCmdShowenv): rowData:

    <tr>
    <td width="15%" align="right" valign="top" class="OraPromptText">
    <span class="OraPromptText">
    %ENV_NAME%
    </span>
    </td>

    <td><img src="/reports/images/space.gif" alt="" width="12"></td>

    <td width="85%" align="left">
    <span class="OraDataText">
    %ENV_VALUE%
    </span>
    </td>
    </tr>


    [2004/3/24 10:36:5:977] Info 51022 (ReportRunner:Release): Connection object has been released
    NOTE: Please disregard the label "Senior Member".

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    See sample code in other thread
    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.

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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
  •