This discussion is archived
5 Replies Latest reply: Mar 8, 2013 6:55 AM by Scott_Symonds RSS

Webutil demo not working ?

yash_08031983 Newbie
Currently Being Moderated
Hello experts,

recently i install and configure according to steps:
1. Run create_webutil_db.sql
a. CREATE USER webutil IDENTIFIED BY webutil
b. Grant connect, resource to webutil
c. Connect webutil/webutil
d. @[ORACLE_HOME]/forms/create_webutil_db.sql
e. Create public synonym webutil_db for webutil.webutil_db;
f. Connect sys as sysdba
g. Grant execute on webutil_db to public;
2. Copy and download Jacob from
http://sourceforge.net/projects/jacob-project/files/jacob-project/1.14.3/jacob-1.14.3.zip/download
a. Unzip the jacob download and place jacob.jar in the
ORACLE_HOME/forms/java directory
b. backup sign_webuitl.bat script in [ORACLE_INSTANCE]/bin/sign_webutil.sh
c. search for <Your KEYSTORE password> and replace it with welcome1 (or
something like this)
d. search for <Your private key password> and replace it with welcome1 (or
something like this)
e. Save the script and use it to sign jacob.jar as below
f. [ORACLE_INSTANCE]/bin/sign_webutil.sh
[ORACLE_HOME]/forms/java/jacob.jar
3. Place jacob.dll in the ORACLE_HOME/forms/webutil/ directory
4. Jacob.dll in r2 – file names must be verified against webutil.cfg file
a. Place jacob-1.14.3-x86.dll in the ORACLE_HOME/forms/webutil/win32
directory.
b. Place jacob-1.14.3-x64.dll in the ORACLE_HOME/forms/webutil/win64
directory
5. Using weblogic EM console, Add ORACLE_HOME/forms/java/frmall.jar to the
CLASSPATH in the default.env
6. Update formsweb.cfg webutil section with the following if not already
done:
a. Add frmwebutil.jar and jacob.jar to the WebutilArchive parameter in the
[webutil] configuration section. For some versions of 11g, this is already
added.
b. Specify webutil_demo as the form to be run in the [webutil]
configuration section
7. Download webutil demo from link below, extract and put the contents in
a folder
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/196249.zip
8. Copy ffisamp.dll to the <ORACLE_HOME>\forms\webutil directory.
9. Open your webutil.cfg file and add the following line
install.syslib.0.user.1=ffisamp.dll|40960|1.0|true
10. If not already done do the following in webutil.cfg
a. transfer.appsrv.workAreaRoot=c:\temp
b. transfer.appsrv.accessControl=TRUE
c. transfer.database.enabled=TRUE
d. transfer.appsrv.enabled=TRUE
11. Add the folder in FORMS_PATH in enterprise manager
12. Replace db and run the following command:
a. frmcmp.sh module=webutil_demo.fmb module_type=form
userid=webutil/webutil@<db> compile_all=yes
b. FORMS_PATH variable and make sure webutil.pll folder is available in the
path or run the above command from command shell in the folder where webutil.pll
is available
13. Restart opmnctl and wls_forms weblogic instance
14. Run the webutil
running the url:
http://server:port/forms/frmservlet?form=webutil_demo&config=webutil

logon window appear, after login following mess comes:
frm-40735: when-custom-item-event trigger raised
unhendled exception ora: 06502




thanks
yash

Edited by: yash_08031983 on Mar 8, 2013 12:12 AM
  • 1. Re: Webutil demo not working ?
    mdra801108 Journeyer
    Currently Being Moderated
    Did you compile webutil.pll ?

    Regards
  • 2. Re: Webutil demo not working ?
    yash_08031983 Newbie
    Currently Being Moderated
    yes.. i did compile....
    reattach it...
  • 3. Re: Webutil demo not working ?
    mdra801108 Journeyer
    Currently Being Moderated
    What about form wu_test_106.fmb?
    I always test webutil with this form to see that is everything ok.
    Which webutil.pll are you using?

    Regards

    Edited by: mdra801108 on Mar 8, 2013 2:14 AM
  • 4. Re: Webutil demo not working ?
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    There are a few things you did not mention or were unclear about.

    1. Exactly which Forms version are you using? In order to do what you described, you should be using 11.1.2.x. Forms 11.1.1 or older will not work using the instructions you referred to.

    2. I assume you just copied and pasted the instructions in your post because you included steps like this: "+ 3. Place jacob.dll in the ORACLE_HOME/forms/webutil/ directory+ ". If you downloaded the correct Jacob, you won't have a jacob.dll file.

    3. You said, " +b. FORMS_PATH variable and make sure webutil.pll folder is available + ". At runtime, FORMS_PATH will need access to webutil.plx and webutil_demo.fmx. The pll and fmb are for design time only. In the past, we permitted the use of ungenerated libraries (pll) at runtime, but this is no longer the case. You should always use the "X" file.

    4. You did not mention any of the client information. OS, browser and version, JRE and version, etc. If the client OS is 64bit and you are running Forms 11.1.2, you have the option of using either the 32bit or 64bit Internet Explorer versions. However, you must have a matching JRE. In other words, if you are using 32bit IE, you must also use the 32bit JRE. For 64bit IE you must use the 64bit JRE.

    5. If you are attempting to use Java 7 on the client, you must be running Forms 11.1.2.1.

    6. Someone asked if you compiled webutil.plx. Did you do this before or after you generated the form (webutil_demo.fmx)? If you generated the form before the library, I would recommend regenerating the form. Again, be sure to include the compile_all=yes option.
  • 5. Re: Webutil demo not working ?
    Scott_Symonds Explorer
    Currently Being Moderated
    There can be a few reasons why the FRM-40735 can be appearing in this scenario. I would definitely check the following in your Forms environment:

    1. Are webutil.olb, webutil.pll, webutil.plx, webutil_demo.fmb, and webutil_demo.fmx located in the FORMS_PATH? Most likely, this should be $ORACLE_HOME/forms unless the FORMS_PATH was modified in an environment file (.env).
    2. Check the file permissions on the modules mentioned above. We have found that if the source and compiled modules do not have read or execute privileges, this error (or even FRM-40010: Cannot read form) can come up.

    If both conditions above are satisfied and you still experience the error, there has been a known issue with Oracle Forms 11g (11gR1 and 11gR2) where the webutil.pll library might need to be reattached to the form in order to move it to the top of the "Attached Libraries" in Forms Builder. After saving and compiling the form after making this edit, the form should load without a problem. For more information, feel free to review the article http://pitss.com/us/2012/10/08/frm-40735-webutil-errors-in-64-bit-server-environment. Although the article references Forms 11.1.1.4, this will apply to all Oracle 11g Forms versions.

    Thanks,
    Scott (PITSS)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points