Thursday, 16 February 2017

UNABLE TO LAUNCH REPORTS BUILDER

UNABLE TO LAUNCH REPORTS BUILDER
After installing and configuring Oracle Forms and Reports 12c, if you try to launch either Reports Builder (rwbuilder.bat) or Reports Converter (rwconverter.bat), both located in %ORACLE_HOME%\bin, you will most likely encounter the following error:
“Windows cannot find ‘\bin\rwbuilder.exe'” or “Windows cannot find ‘\bin\rwconverter.exe'”



The reason for the error is because the values for the DOMAIN_HOME and COMPONENT_NAME need to be filled out in both batch files. You may fix the error by completing these steps:
1.     Go to %ORACLE_HOME%\bin and make backups of both rwbuilder.bat and rwconverter.bat.
2.     Open up rwbuilder.bat in a text editor (Notepad, Wordpad, etc.)
3.     Look for $$domain_home$$ and $$component_name$$. Replace $$domain_home$$ with the full path to your domain home (Example: C:\Oracle\Middleware\user_projects\domains\FormsDomain) and $$component_name$$ with the name of your ReportsToolsComponent (Example: reptools1).

4.     Immediately before the line with “set DOMAIN_HOME=…”, insert the line: set ORACLE_HOME=<PATH_TO_ORACLE_HOME> where <PATH_TO_ORACLE_HOME> is the fully-written path to your Forms 12c Oracle home.
5.     Save and close the file.
6.     Repeat steps 2-5 for rwconverter.bat.
This is how the file looks before the changes are made:







This is how the file should look after the changes are made:





After making the changes above, Reports Builder and Reports Converter should open up normally.
at

12 comments:

  1. Rubin Edwards13 February 2019 at 19:42

    Hu Hammad,

    Thank your expertise I've been working on this REP-50125 error for 2 days Googling everyone's out take on how to get this accomplished. DUHH!! I'm Sr. Oracle RAC DBA, and I'm new to Oracle 12c Forms and Reports. Again, thank you for your expertise. If you ever need any Oracle database help please reach out to me oracle2066@gmail.com

    Best Regards, Rubin
    Rubin

    ReplyDelete
  2. Brayan Lopez29 March 2019 at 09:30

    I have a different problem, Reports 12c (rwbuilder.exe or rwbuilder.bat) not work... And i get this error https://support.oracle.com/knowledge/Middleware/2493861_1.html

    And I not have an account with access to the solution.

    Can you help me please?

    sorry for the inconvenience

    ReplyDelete
  3. Tom14 July 2020 at 16:34

    This comment has been removed by the author.

    ReplyDelete
  4. Mary Gpe29 July 2020 at 07:03

    Hola!! realice los pasos mencionados, cambie las rutas, ahora ya no me muestra el mensaje de que no se encuentra, si no que al ejecutar el archivo rwbuilder.bat no realiza nada.

    ReplyDelete
    Replies
    1. Polo5 April 2021 at 16:08

      Hola como lograste solucionarlo, a mi me pasa lo mismo y ya reinstale de cero 2 veces... :( Help me please

      Delete
  5. Unknown23 June 2021 at 18:14

    Alguna actualizacion, lograron resolver el problema? me sucede lo mismo y veo el archivo reports.log con este mensaje REP-0001: Unable to find the Report Builder message file. Please verify your installation.

    Agradezco su ayuda

    ReplyDelete
  6. Manuel25 August 2021 at 19:28

    This comment has been removed by the author.

    ReplyDelete
  7. Manuel25 August 2021 at 19:30

    i use a sh file with all possibles variables needed and start bot: F&R at once.

    #!/bin/sh

    #

    # Copyright (c) STI. 25082021. All rights reserved.

    #

    export ORACLE_BASE=/u01/app/oracle
    export MW_HOME=$ORACLE_BASE/product/12.2.1
    export ORACLE_HOME=$MW_HOME
    export WLS_HOME=$MW_HOME/wlserver
    export WL_HOME=$WLS_HOME
    export FR_HOME=$ORACLE_HOME
    export ORACLE_INSTANCE=/u01/app/oracle/product/12.2.1/user_projects/domains/frdomain/config/fmwconfig/components/FORMS/instances/forms1
    export FR_INST=$ORACLE_INSTANCE
    export DOMAIN_HOME=$ORACLE_BASE/config/domains/frdomain
    export JAVA_HOME=$ORACLE_BASE/jdk1.8.0_211
    export OHS_INST=$DOMAIN_HOME/config/fmwconfig/components/OHS/instances/ohs1
    export PATH=.:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH
    export LD_LIBRARY_PATH=$FR_HOME/oracle_common/jdk/jre/lib/amd64:$FR_HOME/lib:$FR_HOME/oracle_common/lib:$FR_HOME/oracle_common/jdk/jre/lib/amd64/server
    export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/

    export FORMS_PATH=/home/oracle/sti
    export REPORTS_PATH=/home/oracle/sti

    export TERM=vt220
    export ORACLE_TERM=$TERM
    export TNS_ADMIN=/u01/app/oracle/product/12.2.1/user_projects/domains/frdomain/config/fmwconfig


    cd /u01/app/oracle/product/12.2.1/bin
    nohup rwbuilder.sh &
    nohup frmbld &

    ReplyDelete
  8. Richard7 April 2022 at 21:40

    Ya abre, pero se cierra inmediatamente.
    ¿Alguna idea?

    ReplyDelete
  9. Richard17 April 2022 at 08:12

    Finally I was able to fix it.

    ReplyDelete
  10. Richard17 April 2022 at 08:13

    We have to correct reports.bat and nwbuilder.bat.
    In the second one I removed this line:
    ::set PATH=%ORACLE_HOME%\oracle_common\jdk\bin;%ORACLE_HOME%\oracle_common\jdk\jre\bin\classic;%ORACLE_HOME%\oracle_common\jdk\jre\bin;%ORACLE_HOME%\bin;%PATH%

    ReplyDelete

Subscribe to: Post Comments (Atom)