| client_ole2 for outlook on windows 10 Problem [message #661999] |
Tue, 11 April 2017 10:26  |
 |
giorkos_s
Messages: 15
Registered: December 2016
|
Junior Member |
|
|
Hi All,
I am experiencing a problem relating to webutil and client_ole2.
Specifically, we have some code to open outlook and send email. It all works fine on windows 7 machines, but a test on windows 10 DOES NOT !
i have placed some alerts in the code to figure out where it stops working and the following line seems to be the culprit
application:=client_ole2.create_obj('Outlook.Application');
i show the snippet of the code here, where i have my parameter declarations and the part of the code that fails.
execution of the code show the first alert "about to create outlook object" and forms just "freeze" . execution of the second alert after the create_obj('Outook.Application') is never reached.
we have checked various things but nothing seems to get us anywhere...
has anyone had a similar issue ??
Thanks,
George
this is part of the code
PROCEDURE send_email IS
v_file varchar2(1000);
v_subject varchar2(80);
v_recipient varchar2(500) := NULL;
v_alert number;
v_file_type TEXT_IO.FILE_TYPE;
v_file_suff varchar2(60);
v_part_date varchar2(11);
default_control_error EXCEPTION;
counter number:=0;
objMail client_ole2.OBJ_TYPE;
equal_sign varchar2(1):='=';
application client_ole2.OBJ_TYPE;
hMailItem client_ole2.OBJ_TYPE;
hRecipients client_ole2.OBJ_TYPE;
recipient client_ole2.OBJ_TYPE;
msg_attachment client_ole2.OBJ_TYPE;
args client_ole2.LIST_TYPE;
session client_ole2.OBJ_TYPE;
v_body varchar2(4000);
lr number:=0;
first_item varchar2(200);
orig_item varchar2(200);
cur_item varchar2(200);
i number:=0;
attachments_list WEBUTIL_FILE.FILE_LIST;
BEGIN
call_alert('about to create outlook object...');
application:=client_ole2.create_obj('Outlook.Application');
call_alert('created outlook object...');
--0 below means mail item, 1 means calendar
args:=client_ole2.create_arglist;
client_ole2.add_arg(args,0);
hMailItem:=client_ole2.invoke_obj(application,'CreateItem',args);
call_alert('Outlook is open now....at least the instance !!!!');
client_ole2.destroy_arglist(args); |
|
|
|
|
|
| Re: client_ole2 for outlook on windows 10 Problem [message #662297 is a reply to message #662009] |
Mon, 24 April 2017 04:01  |
|
giorkos_s
Messages: 15
Registered: December 2016
|
Junior Member |
|
|
Solved !!! 
Once more....little bit of investigation when time permitted, and NOT taking Oracle-Java Messages as a direct cause produced the following :
The error message
2017-Apr-12 11:21:18.222 ERROR>WUC-24 [URLDownload.pullFile()] Error reading URL http://wlserver:7778/forms/webutil/jacob.dll
2017-Apr-12 11:21:19.269 ERROR>WUC-24 [URLDownload.pullFile()] Error reading URL http://wlserver:7778/forms/webutil/JNIsharedstubs.dll
2017-Apr-12 11:21:20.488 ERROR>WUC-24 [URLDownload.pullFile()] Error reading URL http://wlserver:7778/forms/webutil/d2kwut60.dll
Simply means that the above files COULD BE FOUND on the HTTP server, BUT the problem was the writing -downloading them to the \bin folder of the Java installation.
So basically it was Windows PERMISSIONS to 'Blame'
Simply, manually copying the files in the java\bin folder, and Webutil functions work perfectly fine.
as far at the ports , I had a little suspicion that something like Webcache (found in 10G R2) could be going on.
A little more diving into the Weblogic settings, proved that indeed, a load balancing mechanism exists, called Clusters now  ( hey..im still learning) is configured, so yes...accessing the Forms port directly does not work, unless its been redirected from the CLuster listening port=9001...
So all in all....WINDOWS PERMISSIONS !!!
Hope it helps someone else !
George
|
|
|
|
|
|
| Re: client_ole2 for outlook on windows 10 Problem [message #662328 is a reply to message #662326] |
Tue, 25 April 2017 05:43 |
|
giorkos_s
Messages: 15
Registered: December 2016
|
Junior Member |
|
|
Hi Littlefoot,
yeah..it seems that the permissions is the problem.
trying to 'automate' the process for all users, whithout changing permission in 'program files\java\bin\' is throwing another challenge.
our system admins, suggested we try and install java to a different location, where all users have Full access, instead of program files location.
so, installing Java in c:\apps\java where user have full acces to c:\apps and running the webutil form, still does not download the 3 DLLs to the bin location.
Tried specifying the %JAVA_HOME% in case that makes a difference but nothing. I still get the silly message about not finding the HTTP server and file.
Trying to get weblogic server to instruct the client to download the webutil files to a specified location using webutil.cfg and the config line
install.syslib.location.client.0 = c:\apps\java\bin
trying the above, the error messages from JAVA console do not appear any more.
BUT, the 3 DLL files are not copied to the location, and still webutil functions do not work....
trying to figure this one out at the moment....
in the worst case we can try and alter the permissions in program files\java\bin, or even copy the files with group policy in java\bin .
will post back if I work it out (time permitting of course !!! )
Thanks,
George
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
