Tuesday, March 21, 2006 10:05 PM
I moved my OLAP DB to SQL Server 2005, installed Microsoft OLE DB Provider for Analysis Services 9.0 on the client and keep creating Pivot Tables in Excel until...
Grouping - when I try to group couple of members (or even 1 for that matter) I'm getting :
"Intrnal error: An unexpected error occurred (file"mdinfo.cpp", line 3335 function "MDInfo::Init")."
The only reference to mdinfo error I found in OLAP newsgroup where a guy was getting it trying to process the cube. My cube is processed (obviuosly). So, anybody knows what has changed with respect to grouping in PTS?
Saturday, March 25, 2006 2:26 AMThis an AS issue.
Wednesday, March 29, 2006 12:31 AM
Could you, please, give detailed repro steps (with Adventure Works would be best) so I can investigate this problem? I have tried grouping members in a pivot table in my project and it worked fine.
Monday, April 03, 2006 9:52 PM
Thanks for the reply. I'm not sure that I specified I'm working with Excel pivot table...
I can't get EXACTLY the same error with AW, but can't make it to work anyway. Here is the simplest Pivot table to play with:
Extended Amount Category Total Accessories 1278745.912 Bikes 95115166.84 Clothing 2138577.942 Components 11804291.4 Grand Total 110336782.1
I'm not sure it's gonna be visible. So, it's Extended Amount by Product Categories.
If I select Components and Accessories, right click and choose "Group and Show Details":"Group..." I get the "Internal error: An unexpected exception occured" . Worked fine with version 8.0...
Tuesday, April 04, 2006 9:45 PM
Yes, I tried that with Excel Pivot Table but I haven't been able to repro the error. After following your steps (pivot of Extended Amount and Product Categories, then group Components and Accessories), I am getting expected grouping (this is on RTM build):
Extended Amount Product Categories1 Category Total Group1 Accessories 1278745.913 Components 11804291.4 Group1 Total 13083037.31 Other Bikes 95115166.84 Clothing 2138577.943 Other Total 97253744.78 Grand Total 110336782.1
Since you experience that with more than one database it cannot be data integrity problem. Perhaps you might check the version of msolap90.dll in C:\Program Files\Common Files\System\Ole DB? You can also try to re-register it executing this in a command line: regsvr32 msolap90.dll .
Also, what happens after you see the error? Does the grouping work as in my example or nothing happens with the pivot table?
Wednesday, April 05, 2006 3:45 PM
After the error pop up no changes happen. My msolap90.dll version is 9.0.1399.0. Re-registering didn't help, loading Office updates neither...
Why were you talking about data integrity? How can it affect grouping? I'd look into it in my DB if I knew what to look for...
Wednesday, April 05, 2006 9:38 PM
I could finally repro the problem with internal error when grouping on build 1399. The good news is that it is already fixed in SP1. Currently, only SP1 CTP is available for download but the final SP1 will be available very soon.
Broken data integrity can affect various server actions but apparently this is not a concern in your case, which is good.
In fact, I was surprised that you saw such detailed error message including file name, line number and function name, as you described in your first post. It looked like a debug version rather than release.
Thursday, April 06, 2006 4:22 PM
Thank you Greg,
A question remains whether I could find the msolap90.dll somewhere without installing CTP version, and if that's gonna be enough... I'm falling late on this project, and do not have extra installation to take risk with CTP now...
Thursday, April 06, 2006 7:21 PM
I understand your difficult position. Unfortunately, a newer version of msolap90.dll alone wouldn't help you. I was able to repro the grouping problem only when I replaced the server files as well. Therefore, you would need newer version of the engine binaries to avoing the grouping problem.
I will try to find out if there is any work-around for the RTM version and if yes, I will post it here today.
Thursday, April 06, 2006 9:25 PM
It appears there is no workaroud in RTM for that. SP1 CTP should fix this particular problem but installing final SP1 seems to be a better solution if you can afford to wait. There are some more fixes related to grouping in the final version.
Friday, April 07, 2006 9:41 AM
can i know the final build of sp1. because i have downloaded some with name "SQLServer2005SP1-KB913090-x86-ENU". please help me.
Friday, April 07, 2006 10:43 PMYou have downloaded the CTP version. The final version of SP1 is not yet known since it has not been released.
Friday, May 30, 2008 2:56 AMwhat is the resolutions for this problem.We are facing the same problem. "Internal Error: An unexpected exception occured."We are using this setting and drivers:1. OLEDB for Analysis Servises 9.0 for excel 2003 and 20072. Microsoft SQL Server 2005 SP23. CubeSliceThanks