“Internal error: An unexpected exception occurred.” when filtering simple dimension that has ragged parent-child hierarchy in SSAS multidim.
Dear SSAS Team,
We have a really strange problem with one of the MDX queries generated by Reporting Services parameters fetching engine.
I was able to simplify the case and prepare an example that can be reproduced in SSAS Multidimensional.
Due to the fact, that this issue requires a good description with screens and notes, I suggest reading it on my stack overflow post here:
or my blogpost here (screens and more details):
In short, we have found that setting parent-child hierarchy on a simple dimension table is making our MDX query failing, when it comes to filter the dimension by one attribute and getting CURRENTMEMBER.MEMBER_CAPTION of another. The hierarchy is ragged and does not loop. In some cases (of different filtered attribute members) query works, otherwise it returns "Internal error: An unexpected exception occurred" and memory dumps are created. This can be reproduced by you using my examples (see last few points of the post on my blog).
We tested it on SSAS versions: 2016 RTM, 2016 SP2, 2016 SP2 CU7, 2017 RTM, 2017 CU15 and all of them generate internal errors.
We consulted it with many analysis services architects and developers and everyone agreed with the statement that this seems to be a bug and it should be reported, so I'm doing right now :)
We'll be grateful for help. For now the workarounds are implemented, but this should be definitely fixed as it affects MDX queries especially triggered by Reporting Services reports.
Hi Michal, thanks for reporting the issue. I've filed a bug to investigate it.
If you need this fixed more urgently, I would recommend opening a support case.