The error occurs when the user tries to open any document on his machine or from the repository. He can create new documents and open them subsequently, but any other document gives this error even if it is as small as a 100 kb. I did a de-install, cleaned up the registry, re-installed 5.1.5 but to no avail.
It gives a list of whole bunch of dlls (may not necessarily be the same every time the error occurs, but they are around 10-12 in all), and tracking each one of them down will be a pain. Is there a quick fix like just copying those dll’s from another machine onto this machine and registering them?
Delete the offending universe from the universe\universe folder
add the correct mfc42.dll file (4.21.7303) to the Program Files\Business Objects\Business Objects 5.0 folder
Rewrite the query
Backup the mfc42.dll file in the winnt\system folder and replace it with the correct one (4.21.7303) (Note: this could potentially have adverse affects on other products (particullarly norton))
For Designers that can’t get in (i.e., Win2000 users) … Uninstall the product, Purge the Registry for all Business Objects Entries, Reinstall
My twist - this problem yesterday was for one report only. The Designer/Reporter was 5.1.2. He published to SP 4 in Webi. ZABO user in 5.1.3 was getting connection error DA0004 and the report never ran. She uninstalled 5.1.3 and downloaded 5.1.4. Problem went away. YES
Meanwhile the designer modified this report and published as test version. He and I can run the report in full client. Us or anyone in ZABO gets the Unhandled Exception or a connection error DA0004 or even sometimes it hurts so bad that BO just quits, FLASH with no message. I upgraded the designer to 5.1.4 but by now the report was so corrupted that I sadly suggested he start over on a previous working version. AND - I had upgraded to SP6 during all this and the corrupted report was OK on my PC thru ZABO but SP 6 has that other problem I posted this morning.
Somewhere in here is the key to all the errors
But I think the report got corrupted for any number of reason: difference in version, complex filters (KX res 10849) and lots of variables and reports tabs and overall large size.
Another (apparent) cause/solution that I have found to the Evil Unhandled Exception Error is corrupted universe objects, as opposed to the entire universe being corrupted. And another symptom of them I have encountered is that the universe imports, but the object formatting or results don’t display in Reporter as they are set in Designer. (Du du du du, du du du du: “You have now entered…the Twilight Zone”.)
I have encountered this problem a couple of times, and both times the only changes I had been making to the up-til-then functioning universe was editing or creating just a few universe objects. As I analyzed what I had been doing just before the problem occurred, the only thing that stood out was that I had been making rapid and/or multiple changes to objects; for example, both changing an object’s format style and at the same time deleting an existing style from the list displayed. A memory pointer problem, perhaps??
When I deleted these recently-edited objects, saved the universe, and then recreated the objects from scratch, VOILA!, no more problem.
So now I make it a habit to make object changes more slowly and save them often, hoping this will help pre-empt the problem.
HTH,
JP Brooks
Kemet Electronics Corp.
P.S. Cutting and pasting the SQL from old to new objects gave no problems, but copying an already corrupted object as a new, renamed object resulted in an already-corrupted new object.
Hi there,
Thanks for all your comments about the annoying UNHANDLED EXCEPTION ERROR. We also have experienced this situation in both Business Objects 5.1.2 and 5.1.3, and in most cases deleting the universes from c:\ or letting the client machine using more swap memory fixed the problem.
But now things are getting worser, since we faced an upgrade to SP6 (Business Objects 5.1.6, Web Intelligence 2.7.2). When our users try to edit the existing reports (made with the 5.1.2 and 5.1.3 versions) using ZABO clients through a new BO SP6 server they always get the UNHANDLED EXCEPTION ERROR in cube50.dll. If we try to edit / refresh documents with the full client in both SP3 and SP6 versions everything works fine, so I asume the problem may be related to the Zabo SP6 server.
We opened a case with Official Business Objects Support and the only answer that we got is that there may be some kind of incompatibility between SP3 and SP6, and suggested to open and save the reports with other name (didn’t work) or get them all redone in the newer version (really madness, since we have lots of legacy reports).
Is anyone experiencing the same problem? Any advice would be really appreciated, i’m afraid we will have to abort the upgrade and stay in BO SP3.
Our Server: Windows 2000 Server SP2
Our DataBase: Oracle 8.1.7 (repository and data)
Our Clients: Windows 2000 Professional SP2
We are at 5.1.4 and I stopped installing 5.1.6 for the reasons I stated below. There was also the issue of the change in the way corporate documents are read (between 5.1.4 and 5.1.5) and I felt if I was going to have to make that concerted and long effort to get EVERYONE moved to the new version, it would be better to wait until sometime in version 6.
We had a 5.1.6 report with 6 queries and a VBA macro. If we tried to run the macro it gave the UEE straight away. If we tried to refresh the report it gave the UEE straight away. If we tried to run a single query, the query would run for a few minutes, and indicate it was bringing back data…tehn give the UEE straight away.
I should mention that the report had been written by someone else, then copied to a network drive, from where we picked it up. We tried a number of things, but when we got the user to send the report to a supervisor in the repository and then retrieved the report - hey presto it was fixed. I’ve been assured that it was the exact same report.
I was reading in some of the posts that machine configuration could be a contributor to the “UEE” rearing its ugly head when attempting to open/run larger reports. I have a “latest and greatest” machine (i.e., 1.7 CPU and 523 mem), but have noticed some of our users have older machines and have encountered the UEE beast intermittently when attempting to open reports in ZABO. Is there a recommended minimum configuration for WebI/ZABO/FC users?
Another thing to check for when getting UEE is the connection type - make sure that it is set to disconnect after every transaction. I understand that this “feature” is particularly prevalent when working with an Oracle database.
We have the Connection Properties set to “Disconnect after each transaction.” We switched to this setting based on the advice of a BO technical rep. after having problems with our connection being repeatedly dropped when using the “Keep the connection active during the whole session” (which resulted in us having to restart Designer and/or BO to reestablish a connection).
We had a problem where one set of users could open BusinessObjects reports fine, and another set could not (BO always crashed when they opened reports - the old c0000005 Unhandled Exception error ).
Eventually we found that all users needed to have a default printer defined . (Those that didn’t have a default printer received the unhandled exception!)
The Event Log showed a Warning that some HP drivers had been installed. Presumably BO or XP was trying to setup a printer in order to render the reports.
Today, I got a ‘c000001d’ EXCEPTION_ILLEGAL_INSTRUCTION message. This occured on 5.1.6 with a slow running report whilst trying to open Designer. Reporter crashed out with multiple Blue Bug screens, but I could re-start from where I was thrown out and nothing seemed to be broken.
Here is another one which I can recreate on 5.1.x and 6.1.a. When adding a new simple query to an existing report I got the unhandled exception error. Looking at the SQL generated there was nothing untoward. I could create other new queries just not this one. So by a process of elimination I discovered that one object was at fault. There was nothing strange about its sql a simple table.column_name in the select clause. I noticed that although the dimension was a character field, it had been set up as date in the Type field. Then I looked at the properties tab where I noticed that the list of values were all of the format ‘00/01/1900 00:00:00’. I restored the default, but this made no difference…I created a new object with the correct type and hey presto - no more problems…hope this helps someone 8)
I’ve found lately that with 6.1a, removing periods from report names resolved a recurring unhandled exception we were getting when choosing the ‘Refresh on open’ tickbox.
I dont know if this is the right place to post my problem but instead of starting a new thread i am posting it here.
I read through all the steps by Nick. My situation is that one user gets UEE on complex reports. We are on 6.1a. Today I logged onto her machine and ran the same report using my profile without any errors. When I ran the same report using her profile, BO Reporter hangs. If I keep on messing with it 3-4 times, I get the UEE. To me this was the Registry problem, so I deleted the registry folder specified (Username User Pref Folder). This didnt resolve the issue.
Could it be the dll or the universe? To me these two cant be the problem coz I logged in on the machine using the same dlls and the same universe.
Can someone please guide me on the other steps I should take now? Thanks in advance for any help.
(BOB member since 2002-08-15)
(BOB member since 2002-06-18)
with no message. I upgraded the designer to 5.1.4 but by now the report was so corrupted that I sadly suggested he start over on a previous working version. AND - I had upgraded to SP6 during all this and the corrupted report was OK on my PC thru ZABO but SP 6 has that other problem I posted this morning.
A memory pointer problem, perhaps??
If we try to edit / refresh documents with the full client in both SP3 and SP6 versions everything works fine, so I asume the problem may be related to the Zabo SP6 server.
(really madness, since we have lots of legacy reports).
).
(BOB member since 2004-06-02)