"This page is not available now. Please choose ano

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

"This page is not available now. Please choose ano

Author

Topic

manidreamz
Starting Member

3 Posts

Posted - 2011-07-20 : 04:36:40

Hi Experts,
I'm getting following error when I login as a particular user to proclarity and open report in proclarity Dashboard. When I login as Administrator I'm able to view the report. In background when I remove Role manager and player role Manager > users, report is working.
"This page is not available now. Please choose another page.

It is based on a member that has changed or is unavailable.

The details of this condition have been recorded for the web site administrator. If you need immediate assistance, contact the web site administrator to help resolve this issue."
Please find the below warning logged in Analytic server event viewer
Event Type: Warning
Event Source: ProClarity Server
Event Category: None
Event ID: 3
Date: 7/20/2011
Time: 2:34:03 PM
User: DOMAIN\TOMLIM
Computer: SERVER022
Description:
Warning when accessing page "Manager View Player Results Overview by Quiz" ({cc82df33-5b06-422f-93f7-f81f184b8a0c})
from book "MRTG" ({E95013DF-405D-46A4-815F-884A0C42D914})
Cache File Name: (unknown)
Call Stack:
Location: line #14818 of file QueryImpl.cpp
- Error-code: (0x24),
Error-number: 0x800f0019
- Member MANAGER ##/##[MRTG Users].[Player Hierarchy].[Player Role].&[MANAGER] not found.
Location: line #14260 of file QueryImpl.cpp
-
Error-code: (0x24),
Error-number: 0x800f0019
Query Connection XML:
<ConnectionInfo><Provider Name="{176941F9-18E8-47D6-860D-006FF2655608}" Caption="MSOLAP"/><Server Name="SERVER022"/><Catalog Name="Pfizer"/><Cube Name="[Cub_MRTG]" Caption="Cub_MRTG"/><Schema Name=""/><LocalServer Name="SERVER022"/></ConnectionInfo>
Query Command XML:
<Command UsingDecoratedNames="Yes" SlicerConversion="No" Active="DSH"><Measures><Measure Name="[Measures].[Correct Answers]" Visible="Yes"/><Measure Name="[Measures].[Wrong Answers]" Visible="Yes"/><Measure Name="[Measures].[Answer Time]" Visible="Yes"/><Measure Name="[Measures].[Total Attempted Questions]" Visible="Yes"/><Measure Name="[Measures].[User Count]" Visible="Yes"/><Measure Name="[Measures].[Total Available Questions]" Visible="Yes"/><Measure Name="[Measures].[Users Count]" Visible="Yes"/><Measure Name="[Measures].[% Correct of Attempted]" Visible="Yes"/><Measure Name="[Measures].[% Wrong Attempted]" Visible="Yes"/><Measure Name="[Measures].[% Correct Of Available]" Visible="Yes"/><Measure Name="[Measures].[Avg Answer Time]" Visible="Yes"/></Measures><CommandSettings/><MDX>WITH MEMBER [MRTG Users].[Player Hierarchy].[All].[ Aggregation] AS ' AGGREGATE( EXISTING { DESCENDANTS( [MRTG Users].[Player Hierarchy].[Player Role].&[MANAGER], [MRTG Users].[Player Hierarchy].[Users] ) }) ', SOLVE_ORDER = 0 SELECT NON EMPTY { [Measures].[Total Attempted Questions], [Measures].[Correct Answers], [Measures].[Wrong Answers], [Measures].[% Correct of Attempted] } ON COLUMNS ,
NON EMPTY { { { [MRTG Users].[MRTG Users].[All].CHILDREN } * { [Edition Quiz Ques].[Product Name].[All].CHILDREN } * { [MRTG Play Count].[MRTG Play Count].[All].CHILDREN } } } ON ROWS
FROM [Cub_MRTG]
WHERE ( [Edition Quiz Ques].[Edition - Quiz].[All], [MRTG Users].[Player Hierarchy].[All].[ Aggregation], [MRTG Users].[Role].&[MANAGER] )
CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL </MDX><DDLObjects UsingDecoratedNames="Yes"/><DSH><Axes><Background><SortTuple Tuple="Yes"/><Dimensions><Dimension Name="[Edition Quiz Ques]" SlicerDimension="Yes" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Edition - Quiz]" MDID="94"/><MemberSet MembersOnly="No"><Member><Member Name="[Edition Quiz Ques].[Edition - Quiz].[All]" MDID="112"/></Member><DescendantsLevel lIndex2="1"><Member Name="[Edition Quiz Ques].[Edition - Quiz].[All]" MDID="112"/></DescendantsLevel></MemberSet></Dimension><Dimension Name="[MRTG Users]" MDID="3"><Hierarchy Name="[MRTG Users].[Player Hierarchy]" MDID="41"/><MemberSet MembersOnly="No"><Descendants><Level Name="[MRTG Users].[Player Hierarchy].[Users]" MDID="115"/><Member Name="[MRTG Users].[Player Hierarchy].[Player Role].&[MANAGER]" MDID="116"/></Descendants></MemberSet></Dimension><Dimension Name="[MRTG Users]" MDID="3"><Hierarchy Name="[MRTG Users].[Role]" MDID="28"/><MemberSet><Member><Member Name="[MRTG Users].[Role].&[MANAGER]" MDID="72"/></Member></MemberSet></Dimension><Dimension Name="[MRTG Users]" MDID="3"><Hierarchy Name="[MRTG Users].[ABM Hierarchy]" MDID="74"/><MemberSet><Member><Member Name="[MRTG Users].[ABM Hierarchy].DEFAULTMEMBER" MDID="87"/></Member></MemberSet></Dimension><Dimension Name="[MRTG Users]" MDID="3"><Hierarchy Name="[MRTG Users].[ABM Name]" MDID="78"/><MemberSet><Member><Member Name="[MRTG Users].[ABM Name].DEFAULTMEMBER" MDID="81"/></Member></MemberSet></Dimension><Dimension Name="[MRTG2 Editions]" MDID="84"><Hierarchy Name="[MRTG2 Editions].[Editions]" MDID="85"/><MemberSet><Member><Member Name="[MRTG2 Editions].[Editions].DEFAULTMEMBER" MDID="113"/></Member></MemberSet></Dimension><Dimension Name="[MRTG Quiz]" MDID="0"><Hierarchy Name="[MRTG Quiz].[Quiz Name]" MDID="43"/><MemberSet><Member><Member Name="[MRTG Quiz].[Quiz Name].DEFAULTMEMBER" MDID="54"/></Member></MemberSet></Dimension><Dimension Name="[MRTG Questions]" MDID="9"><Hierarchy Name="[MRTG Questions].[Hierarchy]" MDID="10"/><MemberSet><Member><Member Name="[MRTG Questions].[Hierarchy].DEFAULTMEMBER" MDID="11"/></Member></MemberSet></Dimension><Dimension Name="[MRTG Questions]" MDID="9"><Hierarchy Name="[MRTG Questions].[Question]" MDID="12"/><MemberSet><Member><Member Name="[MRTG Questions].[Question].DEFAULTMEMBER" MDID="13"/></Member></MemberSet></Dimension><Dimension Name="[Team Sector]" MDID="88"><Hierarchy Name="[Team Sector].[Team Sector Name]" MDID="89"/><MemberSet><Member><Member Name="[Team Sector].[Team Sector Name].DEFAULTMEMBER" MDID="91"/></Member></MemberSet></Dimension><Dimension Name="[MRTG2 Editions]" MDID="84"><Hierarchy Name="[MRTG2 Editions].[Publish Date]" MDID="80"/><MemberSet><Member><Member Name="[MRTG2 Editions].[Publish Date].DEFAULTMEMBER" MDID="77"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Product Id]" MDID="96"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Product Id].DEFAULTMEMBER" MDID="97"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Question Name]" MDID="98"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Question Name].DEFAULTMEMBER" MDID="99"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Quiz - Ques]" MDID="100"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Quiz - Ques].DEFAULTMEMBER" MDID="101"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Quiz Id]" MDID="102"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Quiz Id].DEFAULTMEMBER" MDID="103"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Quiz Name]" MDID="104"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Quiz Name].DEFAULTMEMBER" MDID="105"/></Member></MemberSet></Dimension><Dimension Name="[Wrong Answer Pct]" MDID="82"><Hierarchy Name="[Wrong Answer Pct].[Wrong Answer Pct]" MDID="325"/><MemberSet><Member><Member Name="[Wrong Answer Pct].[Wrong Answer Pct].DEFAULTMEMBER" MDID="106"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Edition Name]" MDID="107"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Edition Name].DEFAULTMEMBER" MDID="108"/></Member></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Quiz - Product]" MDID="92"/><MemberSet><Member><Member Name="[Edition Quiz Ques].[Quiz - Product].DEFAULTMEMBER" MDID="110"/></Member></MemberSet></Dimension><Dimension Name="[Team Sector]" MDID="88"><Hierarchy Name="[Team Sector].[Team Sector Dim]" MDID="95"/><MemberSet><Member><Member Name="[Team Sector].[Team Sector Dim].DEFAULTMEMBER" MDID="117"/></Member></MemberSet></Dimension></Dimensions><HiddenDimensions/></Background><Columns EliminateEmpty="Yes"><SortTuple Tuple="Yes"/><Dimensions><Dimension Name="[Measures]" MDID="34"><Hierarchy Name="[Measures]" MDID="35"/><MemberSet><Member><Member Name="[Measures].[Total Attempted Questions]" MDID="37"/></Member><Member><Member Name="[Measures].[Correct Answers]" MDID="38"/></Member><Member><Member Name="[Measures].[Wrong Answers]" MDID="40"/></Member><Member><Member Name="[Measures].[% Correct of Attempted]" MDID="60"/></Member></MemberSet></Dimension></Dimensions><HiddenDimensions/></Columns><Rows EliminateEmpty="Yes" Filter2Val1="5" Filter2Val2="5"><SortTuple Tuple="Yes"/><Dimensions><Dimension Name="[MRTG Users]" MDID="3"><Hierarchy Name="[MRTG Users].[MRTG Users]" MDID="67"/><MemberSet MembersOnly="No"><Children><Member Name="[MRTG Users].[MRTG Users].[All]" MDID="71"/></Children></MemberSet></Dimension><Dimension Name="[Edition Quiz Ques]" MDID="93"><Hierarchy Name="[Edition Quiz Ques].[Product Name]" MDID="109"/><MemberSet MembersOnly="No"><Children><Member Name="[Edition Quiz Ques].[Product Name].[All]" MDID="114"/></Children></MemberSet></Dimension><Dimension Name="[MRTG Play Count]" MDID="6"><Hierarchy Name="[MRTG Play Count].[MRTG Play Count]" MDID="7"/><MemberSet MembersOnly="No"><Children><Member Name="[MRTG Play Count].[MRTG Play Count].[All]" MDID="52"/></Children></MemberSet></Dimension></Dimensions><HiddenDimensions/></Rows><Pages><SortTuple Tuple="Yes"/><Dimensions/><HiddenDimensions/></Pages><Sections><SortTuple Tuple="Yes"/><Dimensions/><HiddenDimensions/></Sections><Chapters><SortTuple Tuple="Yes"/><Dimensions/><HiddenDimensions/></Chapters></Axes></DSH></Command>
Query Annotation XML:
<Annotation Visible="FALSE" Percent="16" BiDiMode="LTR"/>
Query View XML:
<Views Layout="Single2" Panel2Percent="50"><View Caption="Grid" Description="ProClarity Corporation OLAP data-aware Grid control" ProgID="PGridCtrl.KGrid.5" CommandIndex="0" KPIStatusGraphic="cube_defined" KPITrendGraphic="cube_defined" StorageType="XML"><GridAppearance Font="Name=tahoma,Color=black,Size=9"><ConditionalFormats><Items MDID="60" Name="% Correct of Attempted([Measures].[% Correct of Attempted])" Condition="GreaterThanEqualTo" ConditionValue1="85" BackGroundColor="green" FontColor="white"/><Items MDID="60" Name="% Correct of Attempted([Measures].[% Correct of Attempted])" Condition="LessThan" ConditionValue1="85" BackGroundColor="red" FontColor="white"/></ConditionalFormats></GridAppearance></View></Views>
Please suggest me a solution
Subbu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-20 : 07:56:59

did you check if cube you're trying to browse has been recently changed and unprocessed hence?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources