This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Feb 10, 2013 11:06 PM by 723209 RSS

frm-92101: There was a failure in the forms server during startup.

723209 Newbie
Currently Being Moderated
I have installed developer 10G suite on windows xp sp3. Everything is working fine related to the forms. When I call report from form builder, I am facing below mentioned error.

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to Invalid Configuration
Please look in to the web-server log-file for details.

Details..
Java Exception:
oracle.forms.net.ConnectionException: Forms session <1> aborted: unable to communicate with runtime process.

at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)

at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown Source)
at oracle.forms.net.StreamMessageWriter.run(Unknown Source)

I have written below mentioned pl/sql code within menu item. my report file is complist.rdf which is location in d:\reports folder.

declare
     repid report_object;
     v_rep varchar2(100);
     rep_status varchar2(20);
begin
     repid := find_report_object('complist');
     v_rep := run_Report_object(repid);
end;

I have tried to find any solution but could not succeed yet. Can some one please help me.

Thanks
  • 1. Re: frm-92101: There was a failure in the forms server during startup.
    731020 Journeyer
    Currently Being Moderated
    If you have access to metalink then check
    document id 553840.1

    How To Troubleshoot Frm-92101 When Using Run_Report_Object to Call Reports [ID 553840.1]
  • 2. Re: frm-92101: There was a failure in the forms server during startup.
    731020 Journeyer
    Currently Being Moderated
    TROUBLESHOOTING


    The following steps will help identify the cause of the problem:

    1. Make sure you test with both the in-process reports server and a stand alone reports server to see if the problem occurs with both.

    2. Test by calling the report directly with a browser using the following syntax:

    http://machine.domain:port/reports/rwservlet?report=myreport&amp;server=rep_server_name&amp;userid=un/pw@dbconnect&amp;desformat=pdf&amp;destype=cache
    3. Test on the Application Server (AS) machine by determining if rwclient works:

    a. Set the ORACLE_HOME environment
    b. ORACLE_HOME\bin\rwclient(.sh) server=report_server_name report=report_name desformat=RTF userid=un/pw@dbconnect destype=file desname=<directory>/report.rtf

    and note if report.rtf is created.

    4. Immediately after the problem occurs with RRO, note if the job was submitted to the reports server:

    http://machine.domain:port/reports/rwservlet/showjobs?server=rep_server_name

    5. Note the contents of the Forms application.log at the time the error occurred. It is located at:

    ORACLE_HOME \j2ee\OC4J_BI_Forms\application-deployments\formsapp\OC4J_BI_Forms_default_island_1\application.log

    6. Check if the problem could be relating to pathing. In the form, reference the called report by the absolute path.

    7. Check if the problem could be related to formatting. Try different formats for the report such as htmlcss, rtf, pdf, etc.

    8. If firewalls, proxies, virtual hosting is involved, try calling the initial form using IP address as opposed to machine name.
  • 3. Re: frm-92101: There was a failure in the forms server during startup.
    CraigB Guru
    Currently Being Moderated
    Try creating a new form with a canvas and a button - no code and no base table blocks and then run this form. If this form works, then you know it is something to do with your other form. I've encountered this same error but in my situation it was related to using a demo PJC in my form. Once I eliminated the demo PJC my form worked fine.

    If you get the same error with this basic form troubleshoot will be a bit more difficult. Have you made any changes to the following files?
    \DEV_SUITE_HOME\forms\server\default.env
    \DEV_SUITE_HOME\forms\server\formsweb.cfg

    If you have - double check your changes to ensure they are valid.

    Does the error occur only when you try to run a report? If so, have you followed the steps to setup a Reports Server instance on your local machine (see [Oracle Reports Documentation|http://www.oracle.com/technology/documentation/reports.html])?

    Hope this helps.
    Craig...

    If a response is helpful or correct, please mark it accordingly
  • 4. Re: frm-92101: There was a failure in the forms server during startup.
    733358 Newbie
    Currently Being Moderated
    Hi

    There are some changes needed to be done in Form 10g regarding to printing. They do not support
    RUN_REPORT_OBJECT(repid);

    There is a good documentation for your situation: Oracle Application Server Reports Server Publishing Reports to the Web 10G Relase 2 (B14048-02).

    Good luck.

    Candice
  • 5. Re: frm-92101: There was a failure in the forms server during startup.
    ADFBeginer Newbie
    Currently Being Moderated
    Check the working directory path in formsweb.cfg.
    check application.log in AS server, it gives you exact error message.
  • 6. Re: frm-92101: There was a failure in the forms server during startup.
    723209 Newbie
    Currently Being Moderated
    I am using developer 10G suite on windows xp sp3 using single PC. I dont have any seperate application server. I have developed forms and mentioned forms_path in default.env file. My forms are executing fine and there is no problem in forms while interacting with database. I have noted the contents of erros from application.log and mentioned above.
    Is there any other solution available???
  • 7. Re: frm-92101: There was a failure in the forms server during startup.
    723209 Newbie
    Currently Being Moderated
    I have tried this, all my forms are working fine and communicating with the database. This problem has been faced by many people but there is no proper solution available on all the forums. I have tried all the given solutions but my problem still exists.
  • 8. Re: frm-92101: There was a failure in the forms server during startup.
    Sarah Guru
    Currently Being Moderated
    hi

    what is u r IE version? if its IE-8 then please uninstall/Remove and check and if there is any third party toolbars such as script blocker.


    sarah

    Edited by: S@R@h on Dec 2, 2009 2:24 AM
  • 9. Re: frm-92101: There was a failure in the forms server during startup.
    ADFBeginer Newbie
    Currently Being Moderated
    remove forms path from default.env and give Working directory path to formsweb.cfg
  • 10. Re: frm-92101: There was a failure in the forms server during startup.
    723209 Newbie
    Currently Being Moderated
    I am using IE version 7. I have re-installed it but the problem still exists. Also there is no third party toolbar installed.
  • 11. Re: frm-92101: There was a failure in the forms server during startup.
    Sarah Guru
    Currently Being Moderated
    hi

    please create bat file and run it if there is any problem i hope it will help u.
    @echo off
    echo     welcome to Sameh Bakkar program for initializing oracle service
    echo     ---------------------------------------------------
    echo
    echo     please make sure you have enough memory and try to stop 
    echo     all unnecessary programs or any programs conflicts with orcl
    echo     ---------------------------------------------------
    echo     now intializing "OracleDBConsoleorcl" service
    sc start OracleDBConsole orcl
    echo     ---------------------------------------------------
    echo     now intializing "OracleJobSchedulerORCL" service
    sc start OracleJobSchedulerORCL
    echo     ---------------------------------------------------
    echo     now intializing "OracleOraDb10g_home1iSQL*Plus" service
    sc start OracleOraDb10g_home1iSQL*Plus
    echo     ---------------------------------------------------
    echo     now intializing "OracleOraDb10g_home1TNSListener" service
    sc start OracleOraDb10g_home1TNSListener
    echo     ---------------------------------------------------
    echo     now intializing "OracleServiceORCL" service
    sc start OracleServiceORCL
    echo     ---------------------------------------------------
    sarah
  • 12. Re: frm-92101: There was a failure in the forms server during startup.
    723209 Newbie
    Currently Being Moderated
    If i will remove forms_path from default.env, I will not be able to run my forms in developer 10G. I have tried it. Can you tell me which variable in formsweb.cfg needs to be modified?
  • 13. Re: frm-92101: There was a failure in the forms server during startup.
    723209 Newbie
    Currently Being Moderated
    I have created and executed batch file. Everything is fine. There is no problem.
  • 14. Re: frm-92101: There was a failure in the forms server during startup.
    723209 Newbie
    Currently Being Moderated
    But this does not resolve the problem.
    Have you tried calling report from developer 10G installed on windows xp using single PC. There is no other computer available in the environment.
1 2 Previous Next

Legend

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