This discussion is archived
8 Replies Latest reply: Jan 30, 2013 11:16 PM by SumanthKatti RSS

Forms 11g Migration, Form freezes when Client_ole2 is called

SumanthKatti Newbie
Currently Being Moderated
Hi All,
We are migrating from forms 10g to 11g.
Forms Version is 11.1.1.3.

A form contains CLIENT_OLE2 functionality, where in a word document is open, change the text and close internally.
When the button is pressed , it freezes. And the java console error is as below:
Exception in thread "AWT-EventQueue-3" java.lang.ExceptionInInitializerError
at oracle.forms.webutil.ole.OleFunctions.create_obj(Unknown Source)
at oracle.forms.webutil.ole.OleFunctions.getProperty(Unknown Source)
at oracle.forms.handler.UICommon.onGet(Unknown Source)
at oracle.forms.engine.Runform.onGetHandler(Unknown Source)
at oracle.forms.engine.Runform.processMessage(Unknown Source)
at oracle.forms.engine.Runform.processSet(Unknown Source)
at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
at oracle.forms.engine.Runform.onMessage(Unknown Source)
at oracle.forms.engine.Runform.processEventEnd(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.security.AccessControlException: access denied (java.lang.RuntimePermission loadLibrary.jacob)
at java.security.AccessControlContext.checkPermission(Unknown Source)
at java.security.AccessController.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkLink(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at com.jacob.com.ComThread.<clinit>(ComThread.java)
... 32 more

Most of the places i found in forums was to sign the jacob.jar and frmwebutil.jar.

I have tried doing that but still. the problem exists.

Is this a compatibility issue of old jars with 11g or
jar signing??
Kindly help me .
  • 1. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    CraigB Guru
    Currently Being Moderated
    Most of the places i found in forums was to sign the jacob.jar and frmwebutil.jar.
    It is not necessary to sign the Oracle provided frmwebutil.jar because it has already been signed by Oracle. However, you do need to sign the jacob.jar but more importantly, what version of the Java Com Bridge did you install? The version you used with Forms 10g is not compatible with Forms 11g. The Java error you are getting suggests to me that you have the wrong jacob.jar version (it should be 1.14 instead of 1.06).

    Hope this helps,
    Craig B-)

    If someone's response is helpful or correct, please mark it accordingly.
  • 2. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    SumanthKatti Newbie
    Currently Being Moderated
    Thanks for the response Craig.

    What should be my primary step now. Placing the jacob.jar (version 1.14) , frmwebutil.jar in the C:\<Oracle_Home>\forms\java\ ,
    placing the dlls in the C:\<Oracle_Home>\forms\webutil\ , and change the details of the size and version in formsweb.cfg.

    is the that right?


    Thanks in advance.
    Sumanth.
  • 3. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    CraigB Guru
    Currently Being Moderated
    Sumanth,
    The instructions are clearly laid out in the Forms Help Configuring WebUtil topic. You should not have to modify any sizes. Don't touch the frmwebutil.jar it is already in the place it is suppose to be in. The jacob.jar simply needs to be placed in a directory that is accessible to your application server (or Forms Builder if you are running forms from the Builder) and then update the FORMS_CLASSPATH so it can be found. Often times, people just put it in the same location as the frmwebutil.jar because you don't have to create any Virtual Mappings for the app server to find it.

    You really need to look at the Configuring WebUtil help topic; it describes everything you need to do.

    Hope this helps,
    Craig B-)

    If someone's response is helpful or correct, please mark it accordingly.
  • 4. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    SumanthKatti Newbie
    Currently Being Moderated
    Hello Craig ,

    I have tried the same. But still it didn't work out..

    I m getting this particular error as below:

    basic: Plugin2ClassLoader.getPermissions CeilingPolicy allPerms
    Exception in thread "AWT-EventQueue-3" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet;
         at oracle.forms.webutil.common.VBeanCommon.init(VBeanCommon.java:281)
         at oracle.forms.handler.UICommon.instantiate(Unknown Source)
         at oracle.forms.handler.UICommon.onCreate(Unknown Source)
         at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)
         at oracle.forms.engine.Runform.onCreateHandler(Unknown Source)
         at oracle.forms.engine.Runform.processMessage(Unknown Source)
         at oracle.forms.engine.Runform.processSet(Unknown Source)
         at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
         at oracle.forms.engine.Runform.onMessage(Unknown Source)
         at oracle.forms.engine.Runform.processEventEnd(Unknown Source)
         at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
         at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
         at java.awt.Component.dispatchEventImpl(Unknown Source)
         at java.awt.Container.dispatchEventImpl(Unknown Source)
         at java.awt.Component.dispatchEvent(Unknown Source)
         at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
         at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
         at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
         at java.awt.Container.dispatchEventImpl(Unknown Source)
         at java.awt.Window.dispatchEventImpl(Unknown Source)
         at java.awt.Component.dispatchEvent(Unknown Source)
         at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
         at java.awt.EventQueue.access$000(Unknown Source)
         at java.awt.EventQueue$1.run(Unknown Source)
         at java.awt.EventQueue$1.run(Unknown Source)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
         at java.awt.EventQueue$2.run(Unknown Source)
         at java.awt.EventQueue$2.run(Unknown Source)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
         at java.awt.EventQueue.dispatchEvent(Unknown Source)
         at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
         at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
         at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
         at java.awt.EventDispatchThread.run(Unknown Source)


    i tried out many ways. But not able to get rid of this error.

    Thanks.
    Sumanthkatti.
  • 5. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    CraigB Guru
    Currently Being Moderated
    Sumanthkatti,
    ...Plugin2ClassLoader.getPermissions ...
    What are the permissions on all of the jacob related files and who is the owner of these files?
    jacob.jar
    jacob-1.14.3-x86.dll
    jacob-1.14.3-x64.dll

    The Oracle user should be the owner, but if Oracle is not the owner, then you need to ensure the Oracle user has at least READ permissions on these files.

    Craig...
  • 6. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    A closer look at the error suggests that one of three possibilites are at play here.
    <blockquote>java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet</blockquote>
    1. Your application is using a custom java bean which was not properly recreated against v11 - see MyOracleSupport note 564522.1 as an example.
    2. Your webutil enabled form was not properly generate. (i.e. Compile All > Save > Generate FMX or compile_all=yes from command line compiler)
    3. Your running application is reading old, cached versions of the jar file and not using the new one.

    My recommendation is to start with the simplest first:

    1. Close ALL open browsers
    2. Open the JRE Control Panel from the Windows Control Panel
    3. On the General tab, click on Settings > Delete Files... > Ok (all check boxes should be checked) > Ok > Ok (to close Control Panel

    This likely will correct the problem. If not, regenerate your application and the webutil.pll from v11. You can do this from the command line, but I will explain how to do it from the Builder.

    1. Open the Builder and connect to the db (File > Connect).
    2. Open webutil.pll. This should be found in the Oracle_Home\forms directory
    3. From the Builder menu select: Program > Compile PL/SQL > ALL
    4. From the Builder menu select: File > Save
    5. From the Builder menu select: Program > Compile Module

    Now perform the same steps with your webutil enabled application.

    Retest.

    If it still fails, then review carefully your configuration and ensure that you are not using any custom java beans. This would include any of the Oracle Forms Demos. Look at the "archive" parameter which is set in formsweb.cfg. I expect to only find frmall.jar listed. "WebUtilArchive" should only include frmwebutil.jar and jacob.jar (at least for the sake of this test).
  • 7. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    SumanthKatti Newbie
    Currently Being Moderated
    Hello All

    Thanks for the help provided by you all.

    Whenever there is problem or an issue, usually we get panic and minds get blocked. Silly problems , will get bounced out of mind and cannot be solved.

    Knowing the solution for this and having tried it many a times it wasn't working.
    Later i came to know that it s some problem with my Java version (JRE) in my machine.
    I tried the same thing as advised by all.

    1. I just signed the proper jacob.jar file (jacob.jar v:1.10.1) and placed it in <oraclehome>\forms\java and <oraclehome>\forms\webutil paths.
    2. Cleared the files frmwebutil.jar, jacob.jar, jnisharedstubs.dll in the path "C:\Program Files\java\jre6\bin".
    3. Deleted the "*webutil.default.properties*" file in "C:\Program Files\java\jre6\"
    4. Cleared the Web cache in JRE.

    restarted the server and started working.

    Thanks all for the support.


    Sumanth Katti
  • 8. Re: Forms 11g Migration, Form freezes when Client_ole2 is called
    SumanthKatti Newbie
    Currently Being Moderated
    Hi All,

    Thanks a lot for support.
    It works with jacob.jar 1.10.1 version, after signing it and restarting the application server.

Legend

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