Apache OpenOffice (AOO) Bugzilla – Issue 28593
Error loading BASIC of document
Last modified: 2013-08-07 14:42:16 UTC
Whenever I save documents I keep getting a dialog saying: "Error loading BASIC of document" I've been seeing this during the many last beta versions Using 680m36
Created attachment 14904 [details] screenshot
Created attachment 14905 [details] screenshot
MRU->SW: BASIC stuff...
SW->JSK: seems to be one for you :-)
I can attach the dialog.* files from the application data folder if you want? When I deleted the "OpenOffice.org" directory from my Application Data I no longer get the error.
Hi gemal, this task is duplicate to some older issue (i don't remember the id though). Please try later builds, this should work now. I set this to worksforme.
Closing. If you still have problems you can reopen the task, we'll have to take another look then.
*** Issue 45020 has been marked as a duplicate of this issue. ***
*** Issue 44508 has been marked as a duplicate of this issue. ***
I reopen the issue since this probklem seems to reemerge frequently. I cannot reproduce it myself (not seen in the latest builds around m80+) but sionce it is reported quite often there must be something to it.
to tbe
cp->jsk: Apparently this bug was never seen on 2.x so 2.0 is the wrong target. Please talk to mba for more details.
.
I posted Issue 44508 and have been working on what I can to give you steps in order to reproduce the error. I was able to reproduce the error on in the following way: %appdata% was equal to: \\<servername>\Profiles$\<username>\Application Data The $ for a hidden share might be throwing this off? 1) Used openofficeorg1979.msi to install. 2) I installed with the following choices: All users Complete Choose all three File Types (Word, Excel, Powerpoint) 3) Once the install is complete open writer and try to save the new document. The errors posted on Issue 44508 had all dropped the $ in the profiles path. This works for me on any computer on our network. All the computers are Windows XP workstations with service pack 2.
jsk->cp: This issue should be fixed for 2.0 since we want to run on Citrix. However, i will do some Windows/Terminalserver/Citrix-Testing next week, so this task remains with me until then. Reopen.
Hi Gemal, etihwddot and others, i've now done some testing on a Windows 2000 domain + Terminalservices, doing all kinds of redirection i could think of and (to my surprise) everything works as expected. I redirected appdata to \\citrix01\appdata\%username% and \\citrix01\appdata$\%username%\Application Data but could not find any problems at all. Can anyone provide a document that raises the described error?
What do you mean by a document? I get this any time I save any new document.
Created attachment 24219 [details] Picture of first dialog
Created attachment 24220 [details] Picture of second dialog
Created attachment 24221 [details] Picture of third dialog
Created attachment 24222 [details] Picture of fourth dialog
Created attachment 24223 [details] saved test document
I ran a few more tests with this test document. When I save it the first time I get the error. If I close the document open it again and save then I do not get the error. if you notice in the errors there should be a $ after profiles but there is not. Any ideas? I'm heading on vacation for two weeks so will not be able to post for a few.
*** Issue 46341 has been marked as a duplicate of this issue. ***
jsk->tbe: back to you again. Please have a look at issue #46341, there is some valuable information in that task that might help debugging.
new target 2.0.1
I entered Issue 46341, I am happy to provide more diagnostic info if anyone can tell me what they might find useful.
i'm back from vacation and can also provide any aditional information needed for debugging.
Not a problem now that I am using OOo 1.9.93, nor did I see it in 1.9.91.
I installed 1.9.93 and still receive the errors.
Created attachment 25172 [details] Error in 1.9.93
Another things I expereicne in all of the 2.0 beta's is a hesitation when I first open up a new document and begin to type or when I click on a menu the first time after opening a new document it take about 10 sec to respond. To me it almost feels like it is looking for some sort of file and finally times out after 10 sec. Not sure if it is related to this issue or not. I have a 3.2ghz processor and 1GB RAM and the CPU usage durring this process never goes above 2%. Finally, when I quit the quickstarter I also receive the "Error loading BASIC of document" error.
I am using Fedora Core 2 Linux, with all upgrades prior to the change to legacy status.
TBE->AB: I cannot reproduce this task, probably you have an idea.
TBE->AB: Probably there's also a correlation with #i45987#, which is fixed in SRC680m95. The problem was, that on Unix/Linux the macros from an OOo 1.1.x installation were not imported correctly. As a consequence, the error message 'Error loading BASIC of document' was shown. But this didn't affect Windows.
I received the mentioned errors on Windows XP workstations with a fresh install of any version of OOo 1.1.x or 1.9.x so far. There is no upgrade involved in any of the processes. I completely uninstall any prior versions and delete any associated files in Application Data or Program Files in order to have as clean of a slate as possible. Please advise if there is any environment information I can provide. I would like to resolve this issue so I can distribute this accross our network using the new MSI install and Active Directory. This would greatly reduce my management time so I will spend whatever time needed to provide you the information needed to expedite this solution.
Hi all, as this issue obviously cannot be reproduced on every system, I want to give some background information that might help us to isolate the problem. First: The error message is misleading as the problem does not really has any- thing to do with the Basic inside a document. In fact the attached screenshots show that this is a problem of the application Basic stored in the user data. Unfortunately the same error message is used both for errors reading the Basic from a real Office document and for errors reading the user Basic's configura- tion files (also adressed as "documents" in the error message). The only reason why this message always occurs when you save a document is that the Basic functionality is initialised before a document is saved. And that's also the reason why it only occurs for the first saving. Afterwards Basic is already initialised, although probably not correctly. You should have the same effect when opening the Tools/Macro/Organise Macros/Basic dia- log. This also forces Basic to initialise. The error itself is not very mysterious. The script.xlc and dialog.xlc files (the *.xli files are only an old fallback mechanism for backward compatibility) are essential for the Basic library system. Obviously these files do not exist or are corrupt. So the problem can be reduced to the question, why these files can not be found or read. Thanks to all who offered help to track down the problem. First you should have a look at the files script.xlc and dialog.xlc in your installion. They should be placed in <user installation>/user/basic. The error message shows you where these files are expected. - Are they missing completely or are they empty or corrupt? - Does everything else look correct in <user installation>/user/? There should be a lot of directories, e.g. config, gallery, registry, ... Maybe Basic uses a completely wrong path for any reason. - The location of the user installation is defined by the variable "UserInstallation" in <Office installation>/program/bootstrap.ini. If you patch this path, you can check if other locations work. I e.g. often use $ORIGIN/../UserInst instead of $SYSUSERCONFIG/... to force the user installation into the Office installation (good for developement when you install a log of versions in parallel). You can also use a file URL there, e.g. file:///c:/OfficeTest/UserInst Hint: Each time you change UserInstallation in bootstrap.ini to a new location, starting the Office afterwards is like starting it the first time. You always get new user installations and can have a look if your problem occurs or not. That should be enough for now. Let's see what we can find out... :-)
The 2 messages I got are "Error loading BASIC of document file:///home/henri/.openoffice.org1.9.91/user/basic/LGCD/script.xlb/: General error General input/output error." and the same message with "dialog.xlb" instead of "script.xlb". Neither of the 2 files are there. LGCD is an empty directory.
I can first mention again that the paths are looking in a different place all together. For whatever reason it is looking in: file://<server>/profiles/<username>/Application Data... instead of: file://<server>/profiles$/<username>/Application Data... When I go to tools -> options -> general -> paths All of the paths have dropped the $ for whatever reason.
Ok, here is what I have found. I have played with a few different configurations in the bootstrap.ini file. I set the UserInstallation to the following: file:///c:/test - Worked great! No errors at all. It even fixed my experience of delay's when clicking on menus. file://<server>/test - Worked good! No errors, but a bit of lag which is expected for network usage. file://<server>/profiles$/<username>/test - Get an error when I open for the first time, cannot even get to the user install screen. "The application cannot be started. An internal error occured." I get the same problem if I put it in a folder on a server with a space. Thanks for getting me more information on where to test. I hope this data helps. I can keep doing more testing if neccessary, just let me know.
Created attachment 25273 [details] Error when configure bootstrap.ini UserInstallation
Note on: file://<server>/profiles$/<username>/test - Get an error when I open for the first time, cannot even get to the user install screen. "The application cannot be started. An internal error occured." I get the same problem if I put it in a folder on a server with a space. If I replace the space with %20 it worked fine.
$ ll `locate script.xlc | grep /home/gavin/.openoffice | sort -u` -rw-rw-r-- 1 gavin gavin 2052 Mar 16 10:59 /home/gavin/.openoffice.org1.9.79/user/basic/script.xlc -rw-rw-r-- 1 gavin gavin 2052 Mar 22 13:56 /home/gavin/.openoffice.org1.9.84/user/basic/script.xlc -rw-rw-r-- 1 gavin gavin 2246 Apr 8 17:45 /home/gavin/.openoffice.org1.9.87/user/basic/script.xlc -rw-rw-r-- 1 gavin gavin 2052 Apr 15 09:47 /home/gavin/.openoffice.org1.9.91/user/basic/script.xlc -rw-rw-r-- 1 gavin gavin 2052 Apr 20 10:31 /home/gavin/.openoffice.org1.9.93/user/basic/script.xlc ======================================================
Created attachment 25284 [details] latest file, no BASIC error
Created attachment 25285 [details] corrupt?? version used when I got the BASIC error
I should have labeled the files better: attachment id=25284 is for .openoffice.org1.9.93 attachment id=25285 is for .openoffice.org1.9.87
ab, Was any of the information I provided last week helpful? Or do I need to go back to the drawing board?
So obviously there's a problem when using a path containing xyz$ or spaces. I could reproduce this. -> etihwddot: Your information is useful. One question: If using such pathes even breaks the user installation, how did you initially manage to get through user installation and having $ directories afterwards? Is the problematic direc- tory directly used as your windows user directory, so that $SYSUSERCONFIG in bootstrap.ini resolves to it? -> nivag: Your files script.xlc files both look ok. Obviously this isn't the problem. And you didn't have any $ in your pathes, right?
-> ab: Yes, $SYSUSERCONFIG must resolve to my path by default. For our windows users their %APPDATA% resolves to \\<server>\Profiles$\<username>\Application Data. When I leave the bootstrap.ini to $SYSUSERCONFIG/OpenOffice.org<VERSION> OOo installs fine giving me no errors. However, when I actually use it I get the Basic Errors. If I look in the \\<server>\Profiles$\<username>\Application Data\OpenOffice.org<VERSION> directory It looks like most of the files are there. However, for whatever reason OOo is looking in \\<server>\Profiles\<username>\Application Data\OpenOffice.org<VERSION>, which means it dropped the $ when OOo saved the path it installed to. This is clear when I go to tools->options->OpenOffice.org->Paths A lot of the paths contain a Program Files path as well as a user data path. However, when installed as mentioned above all the paths that should contain a $ have dropped it. If you have a Windows Domain Setup you can set a group policy that redirects users application data to another location, which is what we do. If you need information on where that is at please let me know.
I have never seen a $ in a path on Linux. I just checked echo $PATH, no sign of a $ in the path. Note that I have not changed any of the paths for OOo, to use $, nor not to use $. If anyone has something specific they would like me to check, please let me know.
FYI: downloaded m100 and still received the same errors.
ab->etihwddot: That does not really surprise me as no fixes concerning this problem have been made for m100... ;-) Ok, here's the latest news: I could isolate the problem concerning the user dir containing a $ and submitted another issue for it (49225). But that still does not explain the problem for Linux users not using any $ in their pathes. ->nivag: Do you still have the problem on current builds? If yes, please have a look at the pathes in tools/options/OpenOffice/Paths. Is the Basic path cor- rect or how does it differ from the path your user installation/basic folder really is located? In general: I think this problem is identified for all cases where $ occurs in the user installation path. Does anyone not using such a $ path still have this problem?
etihwddot -> ab: I receive none of the mentioned errors in any of the versions of OOo if I manually redirect the paths to not contain a $ through the bootstrap.ini file. Thanks for your continued help in this issue.
I no longer get this problem. Note that I only got the error with OOo 1.9.87 on Linux (I have not tried to use OOo on a Microsoft platform). I am now using OOo 1.95.100.
Following up to ab, on Wed Apr 20 02:50:15 -0700 2005: My error message is: Error loading BASIC of document file:///usr/lib/ooo-1.1/share/basic/WebWizard/script.xlb/: General Error. General input/output error. The directory /home/yves/.openoffice.org1.9.100/user/basic exists, but not the subdirectory /WebWizard. [yves@localhost basic]$ pwd /home/yves/.openoffice.org1.9.100/user/basic [yves@localhost basic]$ ls -al * -rw-rw-r-- 1 yves yves 2232 May 16 22:21 dialog.xlc -rw-rw-r-- 1 yves yves 2233 May 16 22:21 script.xlc Standard: total 40 drwxrwxr-x 2 yves yves 4096 May 9 18:28 . drwxrwxr-x 3 yves yves 4096 May 16 22:21 .. -rw-r--r-- 1 yves yves 288 Oct 20 2004 dialog.xlb -rw-r--r-- 1 yves yves 305 Oct 20 2004 Module1.xba -rw-r--r-- 1 yves yves 349 Oct 20 2004 script.xlb I'm using version 1.9.100, Fedora Core 3.
It seems to me that only the $ containing paths remain as a general problem. as nivag wrote that his problem does not occur any more with newer builds. -> umr5174: This seems to be another problem in your case. For any reason the script.xlc / dialog.xlc files seem to point to an invalid library LGCD. So ac- cessing script.xlb of course fails. Can you reproduce the problem every time you install OpenOffice? Maybe your problem is based on a wrong import of an OOo 1.1 Basic library? Please have a look at issue 45987 fixed in m95. Copying libraries from the OOo 1.1 installation failed for Unix systems. This would result in exactly your scenario leaving an empty library folder. To only get rid of the error message you can remove the lines refering to the LGCD library from the script.xlc and dialog.xlc files located in .../user/basic. To get the OOo 1.1 lib imported correctly - if it still exists - try to install a newer OOo version (>= m95). -> yvesb: Your problem also seems to be different. I've installed an OOo 1.9.100 myself and had no problems. The WebWizard library is no part of the installation any more, so of course it's missing. The question is, why it's still referenced from your script.xlc / dialog.xlc files. Was there something special with your installation, e.g. have you imported user data from an OOo 1.1 installation? But even then references to wizard libraries should be removed. In any case I think that your problem isn't related to the original problem. If your problem is reproducable please submit another issue for it. For now I mark this task as duplicate to 49225 covering the $ path problem. *** This issue has been marked as a duplicate of 49225 ***
-> ab: > Was there something special with your installation, e.g. have you imported > user data from an OOo 1.1 installation? I think that I did import user data from OpenOffice 1.x, and I think that many users will do the same! I just tried to remove OpenOffice 1.x as fully as possible, and I installed OpenOffice 1.9.104. During the installation, OpenOffice asked me if I wanted to import the information from version 1 and, when I said Yes, it gave me the error message about loading BASIC. Obviously the installation program still found some trace of version 1 even though I tried to remove it as fully as possible. Query: what directories and files are created by the installation program for version 1?
-> yvesb : Of course many users will import data from 1.x installation, but obviously most users doing so don't have any problems. Usually installations of OOo 1.x are registered in a special version file ~/.sversionrc for Linux/Solaris repspectively "\Documents and Settings\UserName\Application Data\sversion.ini" for Windows. If you did not deinstall 1.x correctly the corresponding entry can still be found in this file and may cause trouble. But as I wrote before I still can't understand your problem with the WebWizard library that is part of the Office installation. As far as you haven't made a copy of this library into your user/basic it shouldn't be imported from 1.x at all. But if it is imported for any reason I don't understand and the corresponding library directory is empty or does not exist any more the import may fail leaving an invalid library entry. As long as this problem cannot be reproduced by anyone but you I still don't see it as a problem related to this task. To get rid of the error message you can remove the reference to it from the Basic/Dialog configuration files /UserInst/basic/script.xlc and dialog xlc. Just search the line containing the Webwizard library and remove it.
I am now having this issue for the first time on Windows XP SP2 with OOo 1.9.118. It dod not occur with previous beta's (1.9.118 and prior). The previous versions were uninstalled using the windows installer (started from "control panel"), after which the new version was installed as a complete, default installation. It concerns a local installation, so this is not related to the $ path problem. It seems thus that this issue was not fundamentally resolved and should be reopened. This happens upon the first save, either when saving a new document or saving an opened document. I can systematically reproduce the problem as following * Exit the quickstarter (or restart the system) * Load Writer * type something, press Ctrl+S, type a file name, click OK: two errors appear consecutively (screenshot of the messages attached). Same goes for leading an existing document and saving it. It is worrying that I did not have this issue in earlier builds. Before filing this report, I uninstalled OOo 1.1.118, rebooted the system, then reinstalled it, but the issue remains.
Created attachment 28260 [details] Two conssecutive error dialogs on first save
ab->ftack: You don't have "this issue", but a completely different one. The message "Error loading BASIC of document" can have many reasons. It just states that a Basic library is registered but cannot be loaded. Your problem is covered by issue 51943. I don't see any reason to keep this issue open as the discription has become much to long and complex anyway. It makes much more sense to submit new tasks if necessary -> CLOSED