Apache OpenOffice (AOO) Bugzilla – Issue 4954
Cannot access OP Contacts
Last modified: 2006-05-31 14:29:06 UTC
Attempting to use datasource MS OUTLOOK...OP Contacts After an approximate 30 sec pause, a time-out error is reported. Repeated attempts usually result in a total failure of the application. Changing the datasource timeout value int Tools...Options did not change the lenght of the pause nor the error.
Jim, do you have Mozilla installed on your system? If so, can you please try accessing your contacts with Mozilla? In addition, it would be interesting in which mode Outlook is running on your system. We have some problems with the Outlook corporate Local mode (OCL), and I suspect that this here is one of these problems. You may want to have a look at abzilla.mozdev.org, and the know problems listed there, to see if you find your problem in this list. For the technical background (and why I'm referring to mozilla here): OOo ships with mozilla components for accessing all these address books. The code for this has been added to Mozilla within the abzilla project, with one major goal beeing the integration into OOo. Frank
Jim, sorry I missed this the first time around, can you confirm if this is still a bug with OOo 1.0.1.
Yes, this is still a problem in v1.0.1
Thanks for the response Jim. At the moment, I am keen to understand a bit more about why it fails. I would be grateful if you could answer the following: 1. What version of Outlook are you using? I have tested here against Outlook 2000 SR-1. 2. Is Outlook configured as the default mail client? Check in IE : Tools ->Internet Options -> Programs -> E-mail If not can you set it to Outlook and try OOo again. Please stop and re-start OOo. 3. Is Outlook configured in default mode i.e. Internet only. Check in Outlook to see if "Internet Only" or "Corporate or Workgroup" is active Tools ->Options -> Mail Services-> Reconfigure Mail Support 4. Does Outlook Express work in OOo? 5. have you any Contact data set up in Outlook? Thanks.
1. Outlook 2000 SR-1 (9.0.0.4527) 2. Yes 3. "Corporate or Workgroup" 4. I created on test contact in Outlook Express. That contact was visible in OOo. 5. There are 700 contacts in Outlook. The datastore (.pst) is 202 Mb.
One final question: is the Outlook Data stored locally on your PC or is this located elsewhere? i.e. are the contacts your personal contacts or are these located centrally on an exchange server? If so, Do you also have a local Outlook.pst as well? Thanks. I believe that we should be capable of accessing Outlook configured in "Corporate or Workgroup" mode provided that the data is stored locally on your own PC. This we define as OCL (Outlook Corporate Local) as opposed to OCG (Outlook Corporate Global).
File is stored locally.
I am unable to re-create this. I do notice that we are unable to access data which is stored in Folders located in the Contacts Folder. But this simply returns no data in the query. The fact that you are also seeing the total failure of the entire application is very bad behaviour. That timeout value in the: Tools->Options->Data Sources->Connections refers to the time taken to free up an existing connection i.e. if pooled is enabled, they are not deleted but are kept free and if a new connection is needed, the free one is used. I may need to ask on the users mail list if anyone else is seeing this behaviour to help determine what in your Outlook Setup which may be causing this. The only encouragement is that you appear to have no trouble accessing Outlook Express.
Finally, I reckon I have got a handle on this. I can certainly re-create the timeout i.e. OOo returns "The Data content could not be loaded . Timeout waiting for result." I am unable to cause the application to hang on repeated attempts to execute this. But that is not to say that it does not happen. After I got enough data into the outlook.pst, i was able to re-create the timeout. It appears that we are are using a hard-coded internal timeout for the query of 20 seconds. The size and number of the entries in the Outlook Contacts data causes OOo to timeout when running a query. Thanks for your help on this Jim.
cc'ing Sean to attract his attention
I believe we have a solution to this. The problem lies in mozilla code as we use mozilla code to access all our address book datasources. Mozilla only informs us after it has accumulated all of the records. As Frank eloquently described the situation to me offline ... "So in my opinion, as long as the Mozilla address book does not notify it's client (here: OOo) that it is accumulating data, then the client does not have any chance to distinguish this "accumulating" from an unsuccessfull run. The basic situation is that we have an instance making progress, and another instance waiting for the result. As long as the former uses an "notify-all-or-nothing" strategy, the latter will always have to have a timeout limit, with the potential of false negatives. " We need mozilla to notify us on a per record basis and when this accumulation is complete. So, I have tested a solution based on a original idea by Cyrille, that will do this. I will post the solution here which involves no changes to OOo. We will need to raise a bug in mozilla for this but we have the option to patch mozilla in the meantime. I certainly feel that this bug warrants it.
Created attachment 3525 [details] patch to fix this in mozilla. need to raise a bug against this in mozilla
Created attachment 3526 [details] one line update to previous patch.
Sean, assigning this to you as you took care of it recently.
*** Issue 12555 has been marked as a duplicate of this issue. ***
FS->MSC: pleaseverify in CWS dba03 ...
fixed in CWS dba03
verified
Hi this issue is fixed in OOo 1.1 Beta2 which is available at http://www.openoffice.org/dev_docs/source/1.1beta2/. I close this bug now. Bye Marc
change subcomponent to 'none'