Forum Stats

  • 3,871,980 Users
  • 2,266,360 Discussions
  • 7,911,018 Comments

Discussions

"Run Form" button doesn't work when clicked in Oracle Form Builder.

Moslem
Moslem Member Posts: 39 Green Ribbon

I am trying to run forms after choosing the Standalone runtime option in Oracle Form Builder.

However, nothing happens when clicking on the "Run Form" button.

When running the command-line below in the command prompt :

java -jar frmsal.jar -url "localhost:9001/forms/[email protected]=MODULE1.fmx

I get this error message:

FRM-93136: no base TXT file specified for Oracle Forms Standalone Application

Contact your system administrator.


I checked the Java version installed on my machine, and this is what I got:

Here, I have two points to mention:

  1. I ran the jdk-8u221-windows-x64.exe file when installing Oracle Forms.
  2. It works fine when running forms on the Internet Explorer browser as you can see in the screenshot below:

Any idea how to fix that?

Thanks in advance.

«1

Comments

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,477 Employee
    edited Mar 17, 2022 9:31PM

    If "java -version" fails to do the right thing then you can't expect FSAL to work correctly. For the DOS shell case, you must set PATH to include the ...\jdk\bin directory.

    To deal with the Builder problem, first start by verifying that you can run anything from the Builder assuming that isn't what you already did. Start by unchecking the boxes you shared above. Then on the General tab, set a valid value that points to Internet Explorer (exe) in the Web Browser field.

    Try to run your form. Does it work?

    By the way, you should uninstall the JRE that is installed with the JDK and install the 32bit JRE if you plan to use IE or Edge.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • ben_g
    ben_g Member Posts: 35 Blue Ribbon

    The query string in your command line URL has "@" separating the parameters but it should be an ampersand "&"

    Ben

  • Moslem
    Moslem Member Posts: 39 Green Ribbon

    @ben_g : You're right! I didn't pay attention to that 😅 . Fixing that, I've been able to run the form (with the standalone runtime option) via the command prompt :

    Still, I really need to run it by clicking on the "Run application Forms" button.

    @Michael Ferrante-Oracle : I've unchecked the two options as you asked me to do :

    and I've set Internet Explorer as Web Browser :

    However, when running the form, the browser page opens and gets stuck as shown in the screenshot below :

    By the way, I'm actually trying to run it with the stanalone runtime option not via web browser. As an attempt to fix that, I've added the directory path below to the "Path" environment variable :

    C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin

    Afterwards, I restarted my computer.

    But, nothing happens when clicking on the run button. So, it seems that it wasn't the correct path. Right?

    I've actually spotted two different paths when looking up for the "jdk" folder :

    However, the path that I mentioned above seemed to me the probable one. You see what I mean?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,477 Employee

    @ben_g Good catch. Not sure how I missed that.

    @Moslem Let's verify that Java is being correctly found by the Builder. Can you open the Builder Help? If not then the Builder is not correctly finding Java and this would explain why FSAL isn't working.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • Moslem
    Moslem Member Posts: 39 Green Ribbon

    Yes, I can open the Builder Help. But, which submenu would you like to check out?

    Here are some screenshots that show each one of the Help submenus :

    (Help content)


    (Documentation library)


    (User Forums)


    (Oracle Technology Network)


    (About Form Builder)


    As you can notice, it tells me that the page can't be shown for the submenus below :

    1. Documentation library
    2. User Forums
    3. Oracle Technology Network
  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,477 Employee

    The fact that the Builder Help Navigator opens suggests that the Builder is correctly finding Java. However, the fact that you are unable to open any of the web pages suggests your machine is either not connected to the internet or does not have access to the internet or there are needed proxy settings missing from your machine.

    This may be a clue as to why the Builder cannot launch FSAL. I would recommend removing the "localhost" reference in Application Server URL and using the actual hostname or IP address. The easiest way to get there is to simply press the Reset to Default button.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • Moslem
    Moslem Member Posts: 39 Green Ribbon

    I see...

    I've pressed the Reset to Default button, and I've also checked the Standalone runtime option :

    Still, nothing happens when clicking the "Run application Forms" button! It is a Java issue, isn't it?

    Actually, there is something that I really doubt about. It is whenever I run the following command-line: java -version ,

    it tells me that the Java SE Runtime Environment can't be found.

    That might be another clue. Right?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,477 Employee

    The java -version failure might be related to the problem but unlikely if the Help opens, which you said it did.

    In the System PATH remove ALL references to Java. There may be more than one. Then only add back this one:

    C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin

    Also be sure you have not improperly altered the Forms runtime environment configuration (e.g. default.env). Similarly, ensure that it references the correct jdk\bin

    Exit the Builder if it is open then retest.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • Moslem
    Moslem Member Posts: 39 Green Ribbon

    've changed the "PATH" environment variable value from this one:

    C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Users\Abbassi\Downloads\WINDOWS.X64_193000_db_home\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\HashiCorp\Vagrant\bin;C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin

    to this one:

    C:\Users\Abbassi\Downloads\WINDOWS.X64_193000_db_home\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\HashiCorp\Vagrant\bin;C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin

    So, as you can see, I've removed all the references to Java except that very path that I had already added.

    Concerning the Forms runtime environment configuration, I haven't made any changes in it. However, when looking up the default.env file, I found four ones :

    Here is the PATH variable value in each one of them :

    • PATH=C:\Oracle\Middleware\Oracle_Home\bin;C:\Program Files\Java\jdk1.8.0_221\jre\bin\client;C:\Program Files\Java\jdk1.8.0_221\bin
    • PATH=C:\Oracle\Middleware\Oracle_Home\bin;C:\Program Files\Java\jdk1.8.0_221\jre\bin\client;C:\Program Files\Java\jdk1.8.0_221\bin
    • PATH=%ORACLE_HOME%\bin;%JAVA_HOME%\jre\bin\client;%JAVA_HOME%\bin
    • PATH=%ORACLE_HOME%\bin;%JAVA_HOME%\jre\bin\client;%JAVA_HOME%\bin

    After exiting Builder, I reopened it and retested. But, it keeps giving me the same result, and nothing has changed. Nothing happens.

    Is there anything wrong in my Forms runtime environment configuration?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,477 Employee

    Yes, there is probably something wrong, but I am not convinced its Forms. The fact that your shell (DOS) is not correctly displaying the installed Java version apparently due to a messed up Registry entry is concerning. This is why I recommended you uninstall all the Java versions and only reinstall the JDK 8 (64bit) that was used to perform the product installation. The reinstall process may correct the Registry issue. Note that I do not recommend installing the JRE that is packaged with the JDK.

    However, if you are new to the FMW product(s) and relatively new to Java installations on Windows, I don't recommend blindly uninstalling then reinstalling because you could end up breaking your Forms environment worse.

    Likely the root issue can be identified and fixed, but sometimes it's just faster to uninstall, cleanup, and start over. For as much time as you've spent chasing this already, I could have reinstalled dozens of times.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM