OraFAQ Forum: Forms » Webutil EXCEL download CLIENT

Home » Developer & Programmer » Forms » Webutil EXCEL download CLIENT_OLE2 stops when create obj (Forms 10G 10.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Webutil EXCEL download CLIENT_OLE2 stops when create obj [message #457226]

Sat, 22 May 2010 02:27

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

When Running forms on local machine I successfully download data to excel. But when I place this to server (unix), the forms stops in this line:

application := Client_OLE2.create_obj('Excel.Application');

I think I have no problem with webutil setup or signing it including the jacob because another form is running on server with webutil functions loading and downloading images (pdf).

The problem is why when it comes to excel I have this issue. When I run the form and the code mentioned above is encountered, the program stops. What I have on java console are:

Loading http://59.0.0.132:7778/forms/java/frmall_jinit.jar from JAR cache

Loading http://59.0.0.132:7778/forms/java/frmwebutil.jar from JAR cache

Loading http://59.0.0.132:7778/forms/java/jacob.jar from JAR cache

proxyHost=null

proxyPort=0

connectMode=HTTP, native.

Forms Applet version is : 10.1.2.0

java.lang.ExceptionInInitializerError: 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.Dispatch.<clinit>(Dispatch.java:537)

	at oracle.forms.webutil.ole.OleFunctions.create_obj(OleFunctions.java:398)

	at oracle.forms.webutil.ole.OleFunctions.getProperty(OleFunctions.java:189)

	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.sendDeferredMessages(Unknown Source)

	at oracle.forms.engine.Runform.onMessage(Unknown Source)

	at oracle.forms.engine.FlushQueue.run(Unknown Source)

	at java.lang.Thread.run(Unknown Source)

I googled the whole day but I can't seem to find the right solution for this one.

[Updated on: Sat, 22 May 2010 02:29]

Report message to a moderator

Re: Webutil EXCEL download CLIENT_OLE2 stops when create obj [message #457313 is a reply to message #457226]

Sun, 23 May 2010 15:20

gregor
Messages: 86
Registered: March 2010
Location: Germany

Member

Hi Wency,

look at the end of:
http://www.orafaq.com/forum/t/146502/2/

G Gregor

Report message to a moderator

Re: Webutil EXCEL download CLIENT_OLE2 stops when create obj [message #457781 is a reply to message #457313]

Wed, 26 May 2010 00:33

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks Gregor, but that's not working on my end. I wonder if excel should be present or installed on linux server to solve this. That's the only thing on my mind because the form is running fine on my laptop with windows XP.

I read somewhere that when I run the program on my server, I need to change client_OLE2 into OLE2 in all my codes. When I did this, it still stops on the same line of code, the difference is that this time, the dialog box prompting me where to save my file is displayed. But after I click OK, the error displyed as FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-305501.

and I can't find any solution googling the web to this point.

[Updated on: Wed, 26 May 2010 07:15]

Report message to a moderator