Error grouping in Pivot table with OLEDB for Analysis Servises 9.0

Question

Hi all.

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?

 

Michael

Answer 1

This an AS issue.

Answer 2

Hello Michael,

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.

Thanks,

Greg Guzik

Answer 3

Hi Greg,

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...

Answer 4

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?

Answer 5

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...

Thanks, Greg

 

 

Answer 6

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.

Answer 7

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...

Any suggestion?

Answer 8

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.

Answer 9

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.

Answer 10

hi,

can i know the final build of sp1. because i have downloaded some with name "SQLServer2005SP1-KB913090-x86-ENU". please help me.

 

thanks

 

Answer 11

You have downloaded the CTP version. The final version of SP1 is not yet known since it has not been released.

Answer 12

what 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 2007

2. Microsoft SQL Server 2005 SP2

3. CubeSlice

 

Thanks