Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Webutil - FRM-40039 error

Peter RauxlohApr 27 2020 — edited Apr 29 2020

Dear All

I hope you are all keeping healthy out there!

I have what I hope is a simple problem: getting a webutil enabled form to run.

My environment is

Forms [64 Bit] Version 12.2.1.3.0 (Production) on Oracle Cloud Compute server Windows Server 2012 R2

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

I have a working, webutil enabled forms development environment, and have successfully built and tested a non-ole webutil form based on the Oracle webutil demo form. It is a simple form that allows a user to download files from the application server to use locally. Note the database itself is common to both so any webutil database objects are present.

I now want to put this form into production, so on my production server I have, modified my formsweb.cfg and webutil.cfg files, and ensured I include the config=webutil in the URL I use to fire up the form in. I made some further alterations to the Upload/Download options of the webutil.cfg file to enable the functionality I need, but do not think this is relevant to my problem. I placed my new form on the production server, plus a new version of the MMX to allow access to it.

Stopped and restarted WLS Forms server and WLS Admin server, and then re-started in reverse order.

Started a forms session on prod server with config=webutil and all is fine , normal forms work as expected, but when I try to open my new webutil enabled form, I get the following:

40039.png

Trawled the web for solutions to this and can report on the following suspects:

  • The C:\Oracle12213\Middleware\Oracle_Home\user_projects\domains\frsdomain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\ default.env file on my production server is the same as on the dev server and
  • Within this the FORMS_PATH is
    • FORMS_PATH=C:\FORMS\PRODUCTION;C:\Oracle12213\Middleware\Oracle_Home\forms;C:\Oracle12213\Middleware\Oracle_Home\user_projects\domains\frsdomain\config\fmwconfig\components\FORMS\instances\forms1
  • When I added the WEBUTIL Attached library in forms builder I kept the path to the library C:\Oracle12213\Middleware\Oracle_Home\forms\wevbutil as the dev and production servers have the same directory structure.
  • The files webutil.PLX, OLB and PLL exist in C:\FORMS\PRODUCTION C:\Oracle12213\Middleware\Oracle_Home\forms; and C:\Oracle12213\Middleware\Oracle_Home\forms\webutil – to try and cover all bases!
  • Alternatively one post suggest that forms can get confused if there are too many copies of all PLX PLL and OLB in the FORMS_PATH directories, so I removed all except those in C:\FORMS\PRODUCTION. That gave the same error message as did just leaving those in C:\Oracle12213\Middleware\Oracle_Home\forms

As it is a production server I have to timetable maintenance so the last two options are questions:

  • Could a change be needed to the registry on the prod server? Do I need a FORMS_PATH entry here in HKEY LOCAL MACHINE > Software > Oracle as well as in the default.env? Currently there is no entry here for FORMS_PATH yet my forms all work. I have added one now but still get 40039 but does the server need to be cycled to pick up that change? (Note I do log out and in from a forms session after each change.
  • Could it be file permission on the prod server? Currently users can read the contents of the C:\FORMS\ area but cannot read down to the level of C:\Oracle12213\Middleware\Oracle_Home\forms; Is that necessary ?
  • In the forms builder should I have deleted the path to the webutil attached library rather than maintaining it?

Finally, and related, can anyone answer categorically when a shutdown and restart of WLS Forms then Admin servers MUST occur for a change to be recognized? I am worried that I may try certain fixes and think they have not worked because they are ones that required the WLS servers to be cycled. For example is it only needed ifI the formsweb or webutil.cfg files are changed??

Thanks

Pete

ps Please don't ignore the obvious - I may well be making a basic mistake!

This post has been answered by Michael Ferrante-Oracle on Apr 27 2020
Jump to Answer
Comments
Post Details
Added on Apr 27 2020
9 comments
815 views