I'm struggling to execute forms locally from Forms Builder and have failed so far. This is my current status on this subject:
- I have configured FORMS_PATH under Registery, in Windows Environment Variables (as user variable) and in \%DEV_SUITE_HOME%\forms\server\DEFAULT.env file. All those 3 places have the same content under FORMS_PATH
- I also configured TNS_ADMIN in Registery and in Windows Environment Variables to point to \%DEV_SUITE_HOME%\NETWORK\ADMIN
- then in FORMSWEB.cfg I have switched baseHTMLjinitiator=basejini.htm (as when being on JINI nothing worked ) to baseHTMLjinitiator=basejpi.htm
And now executing forms locally partly works, newly created 'simple' forms execute and work fine, but our production ones that I have tried do not execute at all.
I even tried to add like all the production pll libraries to this newly created simple module one by one, but at the end, this module still runs locally fine.
All I get is an error "FRM-92101 there was a failure in the forms server during startup.This could happen due to invalid config please look into the web-server log file for details"
Now, if I understand correctly this document:
https://docs.oracle.com/cd/B14099_19/core.1012/b14126/log.htm
the web-server log file to check is default-web-access.log. Here is what shows after my last try to execute one of production fmb's:
127.0.0.1 - - [26/Mar/2020:08:36:53 +0000] "POST /forms/frmservlet HTTP/1.1" 200 4188
127.0.0.1 - - [26/Mar/2020:08:36:55 +0000] "HEAD /forms/java/frmall.jar HTTP/1.1" 200 0
127.0.0.1 - - [26/Mar/2020:08:36:58 +0000] "GET /forms/java/oracle/forms/registry/Registry.dat HTTP/1.1" 200 4216
127.0.0.1 - - [26/Mar/2020:08:36:58 +0000] "GET /forms/java/oracle/forms/registry/default.dat HTTP/1.1" 404 168
127.0.0.1 - - [26/Mar/2020:08:36:59 +0000] "GET /forms/lservlet;jsessionid=0a6f023b22b95a7e55c99d2d4eee9059bc278a227aac?ifcmd=getinfo HTTP/1.1" 200 25
127.0.0.1 - - [26/Mar/2020:08:37:00 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b95a7e55c99d2d4eee9059bc278a227aac HTTP/1.1" 200 8
127.0.0.1 - - [26/Mar/2020:08:37:00 +0000] "GET /forms/java/oracle/forms/engine/RunformBundle_pl_PL.class HTTP/1.1" 404 180
127.0.0.1 - - [26/Mar/2020:08:37:00 +0000] "GET /forms/java/oracle/forms/engine/RunformBundle_pl_PL.properties HTTP/1.1" 404 185
127.0.0.1 - - [26/Mar/2020:08:37:00 +0000] "GET /forms/java/oracle/forms/engine/RunformBundle_pl_PL.properties HTTP/1.1" 404 185
127.0.0.1 - - [26/Mar/2020:08:37:00 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b95a7e55c99d2d4eee9059bc278a227aac HTTP/1.1" 200 100
127.0.0.1 - - [26/Mar/2020:08:37:02 +0000] "GET /forms/java/oracle/ewt/alert/resource/AlertBundle_pl_PL.class HTTP/1.1" 404 184
127.0.0.1 - - [26/Mar/2020:08:37:02 +0000] "GET /forms/java/oracle/ewt/alert/resource/AlertBundle_pl_PL.properties HTTP/1.1" 404 189
127.0.0.1 - - [26/Mar/2020:08:37:02 +0000] "GET /forms/java/oracle/ewt/alert/resource/AlertBundle_pl_PL.properties HTTP/1.1" 404 189
and right after, I run that newly created simple module which runs fine and here is its output:
127.0.0.1 - - [26/Mar/2020:08:42:29 +0000] "POST /forms/frmservlet HTTP/1.1" 200 4190
127.0.0.1 - - [26/Mar/2020:08:42:32 +0000] "HEAD /forms/java/frmall.jar HTTP/1.1" 200 0
127.0.0.1 - - [26/Mar/2020:08:42:35 +0000] "GET /forms/java/oracle/forms/registry/Registry.dat HTTP/1.1" 200 4216
127.0.0.1 - - [26/Mar/2020:08:42:35 +0000] "GET /forms/java/oracle/forms/registry/default.dat HTTP/1.1" 404 168
127.0.0.1 - - [26/Mar/2020:08:42:36 +0000] "GET /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273?ifcmd=getinfo HTTP/1.1" 200 25
127.0.0.1 - - [26/Mar/2020:08:42:37 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 8
127.0.0.1 - - [26/Mar/2020:08:42:37 +0000] "GET /forms/java/oracle/forms/engine/RunformBundle_pl_PL.class HTTP/1.1" 404 180
127.0.0.1 - - [26/Mar/2020:08:42:37 +0000] "GET /forms/java/oracle/forms/engine/RunformBundle_pl_PL.properties HTTP/1.1" 404 185
127.0.0.1 - - [26/Mar/2020:08:42:37 +0000] "GET /forms/java/oracle/forms/engine/RunformBundle_pl_PL.properties HTTP/1.1" 404 185
127.0.0.1 - - [26/Mar/2020:08:42:38 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 5717
127.0.0.1 - - [26/Mar/2020:08:42:38 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 2
127.0.0.1 - - [26/Mar/2020:08:42:38 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 10
127.0.0.1 - - [26/Mar/2020:08:42:38 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 2
127.0.0.1 - - [26/Mar/2020:08:42:38 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 2
127.0.0.1 - - [26/Mar/2020:08:42:41 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 178
127.0.0.1 - - [26/Mar/2020:08:42:42 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 115
127.0.0.1 - - [26/Mar/2020:08:42:43 +0000] "POST /forms/lservlet;jsessionid=0a6f023b22b96304c7f7cbeb4c96bef4a8b1d5bfb273 HTTP/1.1" 200 0
I do not much understand from this, but our DB admin says that there is nothing to worry about after looking at those logs.
Any clues on what could be wrong?
( I'm on Forms 10g, Windows 7 64-bit )