Home » Developer & Programmer » Forms » Webutil in forms 12c (Forms 12.2.1.3.0)
Webutil in forms 12c [message #677432] Fri, 20 September 2019 02:51 Go to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
Hello,

We are migrating a series of Oracle forms 6i to Oracle Forms 12c and we are having problems with webutil. I want to use the webutil library to make a button with "Save As".
We have configured webutil and it is OK the forms webutil_demo.fmb all options work correctly for us.

The problem is that to apply on a custom screen does not work for us. In this custom screen the webutil.pll library has been attacked and the webutil.olb is subclassed into the object group.

The call we make on the button is as follows:
begin
: b1.drv_file: = client_get_file_name ('C: \ temp', '', '| Word Documents (*. doc) | * .doc |', 'Select output document ...', SAVE_FILE, true);
end;

The error it gives us is:

it fails, and I get the error:
oracle.forms.webutil.file.FileFunctions bean not found.
WEBUTIL_FILE.FILE_SELECTION_DIALOG_INT will not work

Thanks in advance
Re: Webutil in forms 12c [message #677434 is a reply to message #677432] Fri, 20 September 2019 03:46 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Hello. What did you try so far?

Have a look at this: https://communities.bentley.com/products/assetwise/exor/w/wiki/14530/error-oracle-forms-webutil-file-filefunctions-bean-not-found
Re: Webutil in forms 12c [message #677436 is a reply to message #677434] Fri, 20 September 2019 06:21 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I have made the changes but still giving the same error.

oracle.forms.webutil.file.FileFunctions bean not found. WEBUTIL_FILE.FILE_SELECTION_DIALOG_INT wil not work
Re: Webutil in forms 12c [message #677438 is a reply to message #677436] Fri, 20 September 2019 07:01 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Can you please show us the content of the following files:

1. Your webutil.cfg.
2. Your formsweb.cfg.

Also show us:

3. The location of your frmwebutil.jar and jacob.jar.
4. The URL you use to access your application.
5. Your java console showing the jar files loaded and any possible error messages.

And... is the webutil.olb available at compile time?

[Updated on: Fri, 20 September 2019 07:21]

Report message to a moderator

Re: Webutil in forms 12c [message #677481 is a reply to message #677432] Mon, 23 September 2019 06:13 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I have 2 webutil.cfg. Is it correct? Do you need 2 files?

./Oracle_Home/user_projects/domains/base_domain2/config/fmwconfig/components/FORMS/forms1/server/webutil.cfg
./Oracle_Home/user_projects/domains/base_domain2/config/fmwconfig/components/FORMS/instances/forms1/server/webutil.cfg

The formsweb.cf

./Oracle_Home/user_projects/domains/base_domain2/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_12.2.1/config/formsweb.cfg
Re: Webutil in forms 12c [message #677482 is a reply to message #677481] Mon, 23 September 2019 07:04 Go to previous messageGo to next message
cookiemonster
Messages: 13759
Registered: September 2008
Location: Rainy Manchester
Senior Member
Littlefoot_fan asked for the content of those files.
Re: Webutil in forms 12c [message #677483 is a reply to message #677482] Mon, 23 September 2019 08:39 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I upload the files: formsweb.cfg, dachser.env and java_sal20140.txt

The path of jacob and frbwebutil are the following:

[oracle@dascherweblogic Oracle_Home]$ find ./ -name jacob.jar 2>/dev/null
./forms/java/jacob.jar

[oracle@dascherweblogic Oracle_Home]$ find ./ -name frmwebutil.jar 2>/dev/null
./forms/java/frmwebutil.jar


http://172.24.47.111:9001/forms/frmservlet?config=dachser
Re: Webutil in forms 12c [message #677506 is a reply to message #677483] Tue, 24 September 2019 01:03 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
I can only see the file JAVA_SAL20430.txt uploaded.

Can you try uploading formsweb.cfg and dachser.env once again, please?
Re: Webutil in forms 12c [message #677509 is a reply to message #677506] Tue, 24 September 2019 01:46 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I upload the dachser.txt
  • Attachment: dachser.txt
    (Size: 5.23KB, Downloaded 185 times)
Re: Webutil in forms 12c [message #677510 is a reply to message #677509] Tue, 24 September 2019 01:46 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I upload the formsweb.txt
  • Attachment: formsweb.txt
    (Size: 26.19KB, Downloaded 139 times)
Re: Webutil in forms 12c [message #677514 is a reply to message #677510] Tue, 24 September 2019 02:21 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Regarding formsweb.cfg :

I think you need to edit/add these parameters to [dachser] (that is your application (notice that I also add IconosDachserAlm.jar)):
archive=frmall.jar,frmwebutil.jar,jacob.jar,IconosDachserAlm.jar
archive_jini=frmall.jar,frmwebutil.jar,jacob.jar,IconosDachserAlm.jar #Not sure if you need this one too, I dont think so but just in case

In your Java console you have this, that's why I added IconosDachserAlm.jar:
java.io.FileNotFoundException: http://172.24.47.111:9001/opt/oracle/Oracle/Infrastructure/Oracle_Home/forms/java/IconosDachserAlm.jar

Also add these ones to [dachser]:
WebUtilArchive=frmwebutil.jar,jacob.jar
#WebUtilLogging=off
WebUtilLogging=on
WebUtilLoggingDetail=normal
#WebUtilErrorMode=Alert
WebUtilErrorMode=console
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTML=webutilbase.htm
baseHTMLjpi=webutiljpi.htm
baseHTMLjinitiator=webutiljini.htm
lookAndFeel=oracle

Regarding dachser.env everything seems fine.

In summary, your java console is telling you, basically, that it isn't able to find anything. (FileNotFoundException and ClassNotFoundException everywhere)

Please, try this and let us know if you managed to solve it.

[Updated on: Tue, 24 September 2019 02:37]

Report message to a moderator

Re: Webutil in forms 12c [message #677516 is a reply to message #677514] Tue, 24 September 2019 03:35 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
Now I get the "Save As" screen but it doesn't save me any files
Re: Webutil in forms 12c [message #677518 is a reply to message #677516] Tue, 24 September 2019 04:50 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Hm... does it give you any error whatsoever? (FRM-X? or ORA-X?)

Check your Java console again after you tried saving the file and look for errors.

If you do have Java permission problems you might have to edit your java.policy file (stored in your PC and you'll have to google a bit in this one).
Re: Webutil in forms 12c [message #677519 is a reply to message #677518] Tue, 24 September 2019 04:57 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I upload the "Push_button.docx" file.
Re: Webutil in forms 12c [message #677522 is a reply to message #677519] Tue, 24 September 2019 07:41 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Can't see the file uploaded.
Re: Webutil in forms 12c [message #677523 is a reply to message #677522] Tue, 24 September 2019 08:16 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
I upload the "Push_button.doc" file.
Re: Webutil in forms 12c [message #677524 is a reply to message #677523] Tue, 24 September 2019 09:02 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
I have never seen the first four errors before... so I don't know what to do.

But if the form "webutil_demo.fmb" works perfectly fine for you (ALL the options, including this one), then:

1. That form has something that "Listado de Unidad de Envio" (your form) doesn't.
2. You might have a parameter in formsweb.cfg for [dachser] that either is wrong, or you don't need, and it's not specified in [webutil] (and that's why webutil_demo works fine, SUPPOSING that you tested "webutil_demo.fmb" with the following URL: http://172.24.47.111:9001/forms/frmservlet?config=webutil).

Can't give more insight because I've never ran into this problem.

Apologies.

[Updated on: Tue, 24 September 2019 09:04]

Report message to a moderator

Re: Webutil in forms 12c [message #677525 is a reply to message #677524] Tue, 24 September 2019 09:32 Go to previous messageGo to next message
Goldaxe
Messages: 31
Registered: September 2019
Member
The same errors appear both on the webutil_demo screen and in my form (Shipping Unit List)

[Updated on: Tue, 24 September 2019 09:32]

Report message to a moderator

Re: Webutil in forms 12c [message #677526 is a reply to message #677525] Tue, 24 September 2019 09:54 Go to previous message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Hm... then my guess is that, it might be, either a Webutil installation error or somehow a Java error (maybe not using the right version?)

Also, I googled and found this: https://community.oracle.com/thread/4207275 (these guys right here say it is a JRE error and it gets fixed by downloading the JRE 8u202b32 version).

Can't really say.

Good luck with that one!

[Updated on: Tue, 24 September 2019 09:59]

Report message to a moderator

Previous Topic: frm-40733
Next Topic: upload/Copy file using forms 6i.
Goto Forum:
  


Current Time: Sat Dec 14 07:21:48 CST 2019