sql nulls slow: install

Showing posts with label install. Show all posts

Sunday, March 25, 2012

asp.net

When I attempt to install sql reporting services enterprise, i receive the
following:
"System Check results--asp.net is not installed or is not registered with
your web server".
I review services and iisadmin is there and running as is also asp.net state
services which I had started to run automatically. Microsoft .net framework
1.1 is confirmed installed in the add/remove programs.
Anyone come across this before?
thanksDid you by any chance remove the default website? RS needs the default
website to be able to install.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:3ABC1970-87A4-47D2-8CFC-11A613861F72@.microsoft.com...
> When I attempt to install sql reporting services enterprise, i receive the
> following:
> "System Check results--asp.net is not installed or is not registered with
> your web server".
> I review services and iisadmin is there and running as is also asp.net
state
> services which I had started to run automatically. Microsoft .net
framework
> 1.1 is confirmed installed in the add/remove programs.
> Anyone come across this before?
> thanks
>|||Run this from a command prompt:
%SYSTEMROOT%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
This will install ASP.NET.
On a side note, you may want to turn off the ASP.NET State Service as this
is used for servers that act as session state servers for ASP.NET
applications that are configured to maintain session state out of process.
So this service is probably just using resources for nothing.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ui3TDyx$EHA.2880@.TK2MSFTNGP14.phx.gbl...
> Did you by any chance remove the default website? RS needs the default
> website to be able to install.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
> news:3ABC1970-87A4-47D2-8CFC-11A613861F72@.microsoft.com...
> > When I attempt to install sql reporting services enterprise, i receive
the
> > following:
> > "System Check results--asp.net is not installed or is not registered
with
> > your web server".
> >
> > I review services and iisadmin is there and running as is also asp.net
> state
> > services which I had started to run automatically. Microsoft .net
> framework
> > 1.1 is confirmed installed in the add/remove programs.
> >
> > Anyone come across this before?
> >
> > thanks
> >
> >
>|||Your error happens when, for example, ASP.NET is installed and IIS isn't on
the machine or IIS is installed later. The aspnet_regiis.exe utility with
the -i parameter installs the correct IIS script maps so IIS associates
asp.net requests with the desired version of the framework. (Each framework
version has it's own aspnet_regiis.exe utility).
You should also be able to MSDN search that message and you will get more
information on the aspnet_regiis tool.
Adrian M.
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:3ABC1970-87A4-47D2-8CFC-11A613861F72@.microsoft.com...
> When I attempt to install sql reporting services enterprise, i receive the
> following:
> "System Check results--asp.net is not installed or is not registered with
> your web server".
> I review services and iisadmin is there and running as is also asp.net
> state
> services which I had started to run automatically. Microsoft .net
> framework
> 1.1 is confirmed installed in the add/remove programs.
> Anyone come across this before?
> thanks
>

Tuesday, March 20, 2012

Asking for Strong SA password while installing!

Hi,
When I tried to install MSDE2000A in my WindowXP home edition,its asking for Strong SA passowrd and exiting from the setup?can anyone pls help me in this!!!!
Read the documentation files that came with MSDE 2000 - especially the part
about the command line parameters and their meaning. While you're at it
download the SQL Server Book Online from
http://www.microsoft.com/sql/techinf...2000/books.asp
Jim
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:1E6CDC02-CADD-4221-AD5B-2592643954EF@.microsoft.com...
> Hi,
> When I tried to install MSDE2000A in my WindowXP home edition,its asking
for Strong SA passowrd and exiting from the setup?can anyone pls help me
in this!!!!
>
|||install from the command line
c:\msderila
setup SAPWD=yourstrongpassword <enter>
sql

Sunday, March 11, 2012

AS2005 without Sql Server 2005

Is it possible to install and utilize AS2005 without SS2005 anywhere in the picture?

We'd like to use our current Sql Server 2000 setup with AS2005 (preferable on the same machine).

Any insights or links are appreciated.

Thanks,
JGPAS2005 can hook back into SqlServer 2000. Not sure that I'd run Beta on production just yet, when the release comes out it would probably be doable. The over head of both SqlServer 2000 and Analysis server 2005 should be considered, but technically it should be doable.

Mark E. Johnson

Monday, February 13, 2012

ARe: Problems after the install of the Hotfix

After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx?id=918222

We now get the following error when trying to work with date parameters in Report Builder:

Query (6, 117) The '[VBA].[DateSerial]' function does not exist.
-
Semantic query execution failed.
-
Query execution failed for data set 'dataSet'.
-
An error has occurred during report processing.

Is this a known problem or is there some sort of something that I can reinstall?

Thanks!

Hi Louis, can you paste in RDL that fails?

thanks!

|||

Sure thing. The problem comes with the prompted Transaction Date MDY. Without this parameter, it runs fine.

Thanks for the help :)

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Language>en-US</Language>
<BottomMargin>1.27cm</BottomMargin>
<RightMargin>1.27cm</RightMargin>
<rd:GridSpacing>0.318cm</rd:GridSpacing>
<DataSets>
<DataSet Name="dataSet">
<Query>
<DataSourceName>dataSource1</DataSourceName>
<CommandText><SemanticQuery xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder" xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign">
<Hierarchies>
<Hierarchy>
<BaseEntity>

<EntityID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_MeasureGroup_All_Petra_Donations</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Donation Payment Method">
<Expression Name="Donation Payment Method">
<Path>
<RolePathItem>

<RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Donation_Payment_Method_Entity_Dimension_All_Petra_Donation_Payment_Method</RoleID>
</RolePathItem>
</Path>
<EntityRef>

<EntityID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_Donation_Payment_Method</EntityID>
</EntityRef>
</Expression>
<Details>
<Expression Name="Donation Payment Method1">
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Donation_Payment_Method.Donation_Payment_Method</AttributeID>
</AttributeRef>
</Expression>
</Details>
</Grouping>
<Grouping Name="Core Cause Entity">
<Expression Name="Core Cause Entity">
<Path>
<RolePathItem>

<RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Partner_Account_Entity_Dimension_All_Petra_Partner_Account</RoleID>
</RolePathItem>
</Path>
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Partner_Account.Core_Cause_Entity</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
<Grouping Name="Distribution Name">
<Expression Name="Distribution Name">
<Path>
<RolePathItem>

<RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Fund_Distribution_Entity_Dimension_All_Petra_Fund_Distribution</RoleID>
</RolePathItem>
</Path>
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Fund_Distribution.Distribution_Name</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
</Groupings>
<Filter>
<Expression Name="expr2">
<Function>
<FunctionName>GreaterThan</FunctionName>
<Arguments>
<Expression>
<Path>
<RolePathItem>

<RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Date_Entity_Dimension_All_Petra_Transaction_Date</RoleID>
</RolePathItem>
</Path>
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Time_Attribute_Hierarchy_Date.`_Date</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<ParameterRef>
<ParameterName>Transaction Date MDY Date (Date)</ParameterName>
</ParameterRef>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:FilterCondition" />
<CustomProperty Name="qd:Filter" />
<CustomProperty Name="qd:ContextEntityID">
<Value xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</CustomProperty>
<CustomProperty Name="qd:AutoChangeBaseEntity" />
<CustomProperty Name="qd:Design">
<Value xsi:type="xsd:string">expr3</Value>
</CustomProperty>
</CustomProperties>
</Expression>
</Filter>
</Hierarchy>
</Hierarchies>
<MeasureGroups>
<MeasureGroup>
<BaseEntity>

<EntityID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_MeasureGroup_All_Petra_Donations</EntityID>
</BaseEntity>
<Measures>
<Expression Name="Transaction Amount">
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Measure_All_Petra_Transaction_Amount</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Transaction Count">
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Measure_All_Petra_Transaction_Count</AttributeID>
</AttributeRef>
</Expression>
</Measures>
<SubtotalSets>
<SubtotalSet>
<SubtotalMeasures>
<MeasureName>Transaction Amount</MeasureName>
<MeasureName>Transaction Count</MeasureName>
</SubtotalMeasures>
</SubtotalSet>
<SubtotalSet>
<SubtotalGroupings>
<GroupingName>Donation Payment Method</GroupingName>
</SubtotalGroupings>
<SubtotalMeasures>
<MeasureName>Transaction Amount</MeasureName>
<MeasureName>Transaction Count</MeasureName>
</SubtotalMeasures>
</SubtotalSet>
<SubtotalSet>
<SubtotalGroupings>
<GroupingName>Donation Payment Method</GroupingName>
<GroupingName>Core Cause Entity</GroupingName>
</SubtotalGroupings>
<SubtotalMeasures>
<MeasureName>Transaction Amount</MeasureName>
<MeasureName>Transaction Count</MeasureName>
</SubtotalMeasures>
</SubtotalSet>
</SubtotalSets>
</MeasureGroup>
</MeasureGroups>
<CalculatedAttributes>
<Expression Name="expr3">
<Function>
<FunctionName>And</FunctionName>
<Arguments>
<Expression>
<Function>
<FunctionName>GreaterThan</FunctionName>
<Arguments>
<Expression>
<Path>
<RolePathItem>

<RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Date_Entity_Dimension_All_Petra_Transaction_Date</RoleID>
</RolePathItem>
</Path>
<AttributeRef>

<AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Time_Attribute_Hierarchy_Date.MDY_Date</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<ParameterRef>
<ParameterName>Transaction Date MDY Date (Date)</ParameterName>
</ParameterRef>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:FilterCondition" />
</CustomProperties>
</Expression>
<Expression>
<Null />
<CustomProperties>
<CustomProperty Name="qd:Unspecified" />
</CustomProperties>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:Filter" />
<CustomProperty Name="qd:ContextEntityID">
<Value xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</CustomProperty>
<CustomProperty Name="qd:AutoChangeBaseEntity" />
</CustomProperties>
</Expression>
</CalculatedAttributes>
<Parameters>
<Parameter Name="Transaction Date MDY Date (Date)">
<DataType>DateTime</DataType>
</Parameter>
</Parameters>
<CustomProperties>
<CustomProperty Name="qd:PerspectiveID">
<Value xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_Donations</Value>
</CustomProperty>
</CustomProperties>
</SemanticQuery></CommandText>
<QueryParameters>
<QueryParameter Name="Transaction Date MDY Date (Date)">
<Value>=Parameters!TransactionDateMDYDateDate.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
<Fields>
<Field Name="DonationPaymentMethod">
<DataField>Donation Payment Method</DataField>
</Field>
<Field Name="DonationPaymentMethod1">
<DataField>Donation Payment Method1</DataField>
</Field>
<Field Name="CoreCauseEntity">
<DataField>Core Cause Entity</DataField>
</Field>
<Field Name="DistributionName">
<DataField>Distribution Name</DataField>
</Field>
<Field Name="TransactionAmount">
<DataField>Transaction Amount</DataField>
</Field>
<Field Name="TransactionCount">
<DataField>Transaction Count</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>/Models/UDM Model</DataSourceReference>
<rd:DataSourceID>8c35ebf2-199b-4a18-8ead-c64e8b722e47</rd:DataSourceID>
</DataSource>
</DataSources>
<PageHeight>21.59cm</PageHeight>
<LeftMargin>1.27cm</LeftMargin>
<ReportParameters>
<ReportParameter Name="TransactionDateMDYDateDate">
<DataType>DateTime</DataType>
<Prompt>Transaction Date MDY Date (Date)</Prompt>
</ReportParameter>
</ReportParameters>
<TopMargin>1.27cm</TopMargin>
<Width>25.4cm</Width>
<Body>
<Height>0cm</Height>
<ReportItems>
<Textbox Name="Title">
<Left>1.27cm</Left>
<Top>1.27cm</Top>
<CanGrow>true</CanGrow>
<Width>18.446cm</Width>
<Value>Giving by Date Range</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>18pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:Watermark</Name>
<Value>Click to add title</Value>
</CustomProperty>
</CustomProperties>
<Height>0.9525cm</Height>
</Textbox>
<Table Name="table">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>3</ColSpan>
<ReportItems>
<Textbox Name="DonationPaymentMethod_SubtotalHeader">
<CanGrow>true</CanGrow>
<Value>Total</Value>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>#c7d9f9</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionAmount_Total_3_3_3_3_3">
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=AGGREGATE(Fields!TransactionAmount.Value)</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>C</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionCount_Total_3_3_3_3_3">
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=AGGREGATE(Fields!TransactionCount.Value)</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>#,#</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.635cm</Height>
</TableRow>
</TableRows>
</Footer>
<Top>3.18cm</Top>
<TableGroups>
<TableGroup>
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="blank">
<CanGrow>true</CanGrow>
<Value />
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
<Bottom>Solid</Bottom>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="textbox2">
<CanGrow>true</CanGrow>
<Value>Total</Value>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>#c7d9f9</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionAmount_Total_3_3_3_3_1">
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=AGGREGATE(Fields!TransactionAmount.Value)</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>C</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionCount_Total_3_3_3_3_1">
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=AGGREGATE(Fields!TransactionCount.Value)</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>#,#</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.635cm</Height>
</TableRow>
</TableRows>
</Footer>
<Sorting>
<SortBy>
<SortExpression>=AGGREGATE(Fields!TransactionAmount.Value)</SortExpression>
<Direction>Descending</Direction>
</SortBy>
</Sorting>
<Grouping Name="table_DonationPaymentMethod">
<PageBreakAtEnd>true</PageBreakAtEnd>
<GroupExpressions>
<GroupExpression>=Fields!DonationPaymentMethod.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
<TableGroup>
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="blank2">
<CanGrow>true</CanGrow>
<Value />
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="blank3">
<CanGrow>true</CanGrow>
<Value />
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
<Bottom>Solid</Bottom>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="DistributionName_SubtotalHeader">
<CanGrow>true</CanGrow>
<Value>Total</Value>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>#c7d9f9</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionAmount_Total_3_3_3_3_2">
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=AGGREGATE(Fields!TransactionAmount.Value)</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>C</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionCount_Total_3_3_3_3_2">
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=AGGREGATE(Fields!TransactionCount.Value)</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>#,#</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.635cm</Height>
</TableRow>
</TableRows>
</Footer>
<Grouping Name="table_CoreCauseEntity">
<GroupExpressions>
<GroupExpression>=Fields!CoreCauseEntity.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="DonationPaymentMethod_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<HideDuplicates>table_DonationPaymentMethod</HideDuplicates>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_Dimension_Donation_Payment_Method</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>Detail</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=Fields!DonationPaymentMethod1.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CoreCauseEntity_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<HideDuplicates>table_CoreCauseEntity</HideDuplicates>
<Value>=Fields!CoreCauseEntity.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="DistributionName_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_Dimension_Fund_Distribution</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>Detail</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=Fields!DistributionName.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionAmount_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=Fields!TransactionAmount.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>C</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:Group</Name>
<Value>table_DistributionName</Value>
</CustomProperty>
</CustomProperties>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionCount_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>List</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=Fields!TransactionCount.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>#,#</Format>
<BackgroundColor>#ffff99</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:Group</Name>
<Value>table_DistributionName</Value>
</CustomProperty>
</CustomProperties>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.635cm</Height>
</TableRow>
</TableRows>
<Grouping Name="table_DistributionName">
<GroupExpressions>
<GroupExpression>=Fields!DistributionName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!TransactionAmount.Value</SortExpression>
<Direction>Descending</Direction>
</SortBy>
</Sorting>
</Details>
<Style />
<Width>0cm</Width>
<Height>0cm</Height>
<DataSetName>dataSet</DataSetName>
<TableColumns>
<TableColumn>
<Width>3.40026cm</Width>
<Visibility>
<Hidden>=Fields!DonationPaymentMethod1.IsMissing</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>3.40026cm</Width>
<Visibility>
<Hidden>=Fields!CoreCauseEntity.IsMissing</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>3.81447cm</Width>
<Visibility>
<Hidden>=Fields!DistributionName.IsMissing</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>4.09435cm</Width>
<Visibility>
<Hidden>=Fields!TransactionAmount.IsMissing</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>3.81213cm</Width>
<Visibility>
<Hidden>=Fields!TransactionCount.IsMissing</Hidden>
</Visibility>
</TableColumn>
</TableColumns>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="DonationPaymentMethod_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DonationPaymentMethod1.Value</SortExpression>
<SortExpressionScope>table_DonationPaymentMethod</SortExpressionScope>
</UserSort>
<Value>Donation Payment Method</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CoreCauseEntity_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!CoreCauseEntity.Value</SortExpression>
<SortExpressionScope>table_CoreCauseEntity</SortExpressionScope>
</UserSort>
<Value>Core Cause Entity</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="DistributionName_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DistributionName.Value</SortExpression>
<SortExpressionScope>table_DistributionName</SortExpressionScope>
</UserSort>
<Value>Distribution Name</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionAmount_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!TransactionAmount.Value</SortExpression>
<SortExpressionScope>table_DistributionName</SortExpressionScope>
</UserSort>
<Value>Transaction Amount</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TransactionCount_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!TransactionCount.Value</SortExpression>
<SortExpressionScope>table_DistributionName</SortExpressionScope>
</UserSort>
<Value>Transaction Count</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>1.19834cm</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
<FixedHeader>true</FixedHeader>
</Header>
<Left>1.272cm</Left>
</Table>
<Textbox Name="TotalRows">
<Left>1.27cm</Left>
<Top>7.62cm</Top>
<CanGrow>true</CanGrow>
<Width>16.51cm</Width>
<Value>=String.Format("Total rows" & Chr(58) & " {0}", COUNTROWS("dataSet"))</Value>
<Style>
<PaddingLeft>3pt</PaddingLeft>
<PaddingBottom>3pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<PaddingRight>3pt</PaddingRight>
<PaddingTop>3pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:SpecialContent</Name>
<Value>TotalRows</Value>
</CustomProperty>
</CustomProperties>
<Height>0.635cm</Height>
</Textbox>
<Textbox Name="FilterDescription">
<Left>1.27cm</Left>
<Top>8.89cm</Top>
<CanGrow>true</CanGrow>
<Width>16.51cm</Width>
<Value>Filter: Donations with: Transaction Date MDY Date (Date) after (prompted)</Value>
<Style>
<PaddingLeft>3pt</PaddingLeft>
<PaddingBottom>3pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<PaddingRight>3pt</PaddingRight>
<PaddingTop>3pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:SpecialContent</Name>
<Value>FilterDescription</Value>
</CustomProperty>
</CustomProperties>
<Height>1.27cm</Height>
</Textbox>
</ReportItems>
<Style />
</Body>
<PageWidth>27.94cm</PageWidth>
</Report>

|||

Any ideas? We are going to have to rebuild the server to avoid these issues really soon now (and I hate to be defeated :)

Louis

|||

Sorry for delay, I am looking into this.

We've never seen this error message before. Do you have any other servers where this report runs? Did it run on pre-SP1 bits?

<Edit>

Ok, I can't figure what exactly happens, and can't repro it.
Could you please modify ReportServer Web.Config:
<add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:4,SemanticModelGenerator:2" />

and rerun the report (repro the problem). Then take the latest ReportServer__timestamp.log and see if there are any interesting stack traces at the end of the file?

Thanks! :)

|||

I am not rushing you because I didn't think you were checking into it. I thought you might not have any ideas and it was time to punt. If we do I will try adding the hotfix again after we reinstall sql server with SP1 just to see if it was the hotfix.

Yes, it did. They had a training class and there are quite a few of these reports from that class. So after I added the hotfix, we were testing things to see if they worked, and this was one of the few things that didn't. We are really pushing Report Builder to our clients to give them an ad hoc tool (for a great price :) but then we got this error.

I changed the setting, and it does show issues. I bolded what I thought were interesting. I should also note that our server is on the G: drive and not in C: (I didn't install it, and that person is gone now)

Basically we are taking a date dimension, then choosing the MDY Date format, choosing greater than, or something like that, right clicking the criteria and choosing Prompt. Then I run the report, click the date pick object, choose any date, and click run report. It starts to run then does this. To make sure it wasn't just upgraded reports, Tonight I took a dimension, chose two measures, and filtered like this on a date, same error.

Here is all of the trace stuff after it sets up the query, if you need more, feel free to ask. If you want to email me for quicker feedback, it is drsql@.hotmail.com, and I will be happy to talke by phone but I am not posting that here :)

Thanks for the help!

Query parameter: Transaction Date MDY Date (Date) = 6/5/2006 12:00:00 AM
Query has been compiled successfully.
w3wp!semanticqueryengine!5!6/14/2006-22:54:07:: i INFO: Semantic Query Command ID: 1. Target command type = ASSemanticQueryCommand
SELECT
{ [Measures].[Transaction Amount], [Measures].[Transaction Count] } on 0,
{ EXISTS( { { [Donation Payment Method].[Donation Payment Method].[All Donation Payment Method] } * { [Partner Account].[Core Cause Entity].[All Partner Account] } * { [Fund Distribution].[Distribution Name].[All Fund Distribution] } }, , "Donations" ), EXISTS( { [Donation Payment Method].[Donation Payment Method].Levels(1).Members * { [Partner Account].[Core Cause Entity].[All Partner Account] } * { [Fund Distribution].[Distribution Name].[All Fund Distribution] } }, , "Donations" ), EXISTS( { [Donation Payment Method].[Donation Payment Method].Levels(1).Members * [Partner Account].[Core Cause Entity].Levels(1).Members * { [Fund Distribution].[Distribution Name].[All Fund Distribution] } }, , "Donations" ), EXISTS( { [Donation Payment Method].[Donation Payment Method].Levels(1).Members * [Partner Account].[Core Cause Entity].Levels(1).Members * [Fund Distribution].[Distribution Name].Levels(1).Members }, , "Donations" ) } DIMENSION PROPERTIES MEMBER_TYPE, MEMBER_UNIQUE_NAME, MEMBER_NAME, MEMBER_VALUE on 1
FROM
(SELECT
{ ( Extract( filter( { [Transaction Date].[MDY Date].Levels(1).Members * { [Transaction Date].[Date].[All Periods] } }, ( [Transaction Date].[MDY Date].CurrentMember.membervalue > VBA!DateSerial( 2006, 6, 5 ) ) ), [Transaction Date].[MDY Date] ) , * ) } on 0
FROM
[Donations]
)

w3wp!semanticqueryengine!5!6/14/2006-22:54:07:: e ERROR: Throwing Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. , ;
Info: Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (6, 181) The '[VBA].[DateSerial]' function does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
End of inner exception stack trace
w3wp!processing!5!6/14/2006-22:54:10:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'. > Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (6, 181) The '[VBA].[DateSerial]' function does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
End of inner exception stack trace
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
End of inner exception stack trace
w3wp!processing!5!6/14/2006-22:54:10:: e ERROR: An exception has occurred in data source 'dataSet'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'. > Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (6, 181) The '[VBA].[DateSerial]' function does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
End of inner exception stack trace
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!5!6/14/2006-22:54:10:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!5!6/14/2006-22:54:10:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'. > Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (6, 181) The '[VBA].[DateSerial]' function does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
End of inner exception stack trace
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
End of inner exception stack trace
w3wp!processing!5!6/14/2006-22:54:10:: w WARN: Data source 'dataSource1': Report processing has been aborted.
w3wp!processing!5!6/14/2006-22:54:10:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'. > Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (6, 181) The '[VBA].[DateSerial]' function does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
End of inner exception stack trace
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
End of inner exception stack trace
w3wp!webserver!5!06/14/2006-22:54:10:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'. > Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (6, 181) The '[VBA].[DateSerial]' function does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
End of inner exception stack trace
at Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.AbortHelper.ThrowAbortException(Int32 reportUniqueName)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.CheckAndThrowIfAborted()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext& context)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
End of inner exception stack trace
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

|||

This looks like a problem in AS server which is being called by semantic query engine to execute the final (MDX) query. I will forward this to AS ppl for further analysis.
Thanks!

|||

Totally thanks for your help. I figured this was something wierd.

Do you think it will take long to get something started on correcting it? I can probably only leave the server in this state another day or two before the hounds attack and we reinstall :)

Louis

|||We looked at it and it seems like an installation glitch...|||

So is it repairable, or will we need to to a reinstall? And do I reinstall the hotfix? Or SP1? Or start over with RTM?

|||

If you insalled SQL server on disk C then there should be a folder like: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin, which contains the binaries for the AS server. That folder should contain msmdvbanet.dll.

The data folder (like C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data) should contain folders like VBAMDX.0.asm and VBAMDXINTERNAL.0.asm. It should also contan files like VBAMDX.0.asm.xml and VBAMDXINTERNAL.0.asm.xml.

If something of the above is missing please let us know.

|||

I should mention that we are running on an instance named BI.

We didn't install it on C: (even though our norm is to install program files on c: and data on other drives ).

In c:\program files\microsoft sql server we only have: 80, 90

on G:\MSSQL\MSSQL.1\OLAP\bin

there is an msmdvbanet.dll

on H:\MSSQL$BI\AnalysisData\MSSQL.2\OLAP\Data

there is a VBAMDX.0.asm.xml file, and in it is a listing for:

G:\MSSQL$BI\MSSQL.2\OLAP\bin\msmdvbanet.dll

There is a G:\MSSQL$BI\MSSQL.3\Reporting Services, but no MSSQL.2, or any other number (I understand the numbering well enough)

It appears that we had a quite non-standard setup and the hotfix didn't take that into consideration. Let me know if you want me to send you the contents of any files. I think we are going to rebuild soon.

|||

So you have 2 instances, which you can run - default and BI, right? Or just one (BI)?

When you run the named BI instance, is it configured to run from G:\MSSQL$BI\MSSQL.2\OLAP\bin ?

|||

Just one instance. And it was the only one installed (I am trying to force everyone to get used to working with instances).

Actually the service (Named MSOLAP$BI, SQL Server Analysis Services (BI)) is running:

G:\MSSQL\MSSQL.1\OLAP\bin\msmdsrv.exe -s "G:\MSSQL\MSSQL.1\OLAP\Config"

Or did you want something else?

|||

Please open msmdsrv.ini from G:\MSSQL\MSSQL.1\OLAP\Config

Does it contain the following line?

Sunday, February 12, 2012

ARe: Problems after the install of the Hotfix

After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx?id=918222

We now get the following error when trying to work with date parameters in Report Builder:

Query (6, 117) The '[VBA].[DateSerial]' function does not exist.
-
Semantic query execution failed.
-
Query execution failed for data set 'dataSet'.
-
An error has occurred during report processing.

Is this a known problem or is there some sort of something that I can reinstall?

Thanks!

Hi Louis, can you paste in RDL that fails?

thanks!

|||

Sure thing. The problem comes with the prompted Transaction Date MDY. Without this parameter, it runs fine.

Thanks for the help :)

|||

Any ideas? We are going to have to rebuild the server to avoid these issues really soon now (and I hate to be defeated :)

Louis

|||

Sorry for delay, I am looking into this.

We've never seen this error message before. Do you have any other servers where this report runs? Did it run on pre-SP1 bits?

<Edit>

and rerun the report (repro the problem). Then take the latest ReportServer__timestamp.log and see if there are any interesting stack traces at the end of the file?

Thanks! :)

|||

Thanks for the help!

|||

This looks like a problem in AS server which is being called by semantic query engine to execute the final (MDX) query. I will forward this to AS ppl for further analysis.
Thanks!

|||

Totally thanks for your help. I figured this was something wierd.

Do you think it will take long to get something started on correcting it? I can probably only leave the server in this state another day or two before the hounds attack and we reinstall :)

Louis

|||We looked at it and it seems like an installation glitch...|||

So is it repairable, or will we need to to a reinstall? And do I reinstall the hotfix? Or SP1? Or start over with RTM?

|||

If something of the above is missing please let us know.

|||

I should mention that we are running on an instance named BI.

We didn't install it on C: (even though our norm is to install program files on c: and data on other drives ).

In c:\program files\microsoft sql server we only have: 80, 90

on G:\MSSQL\MSSQL.1\OLAP\bin

there is an msmdvbanet.dll

on H:\MSSQL$BI\AnalysisData\MSSQL.2\OLAP\Data

there is a VBAMDX.0.asm.xml file, and in it is a listing for:

G:\MSSQL$BI\MSSQL.2\OLAP\bin\msmdvbanet.dll

There is a G:\MSSQL$BI\MSSQL.3\Reporting Services, but no MSSQL.2, or any other number (I understand the numbering well enough)

|||

So you have 2 instances, which you can run - default and BI, right? Or just one (BI)?

When you run the named BI instance, is it configured to run from G:\MSSQL$BI\MSSQL.2\OLAP\bin ?

|||

Just one instance. And it was the only one installed (I am trying to force everyone to get used to working with instances).

Actually the service (Named MSOLAP$BI, SQL Server Analysis Services (BI)) is running:

G:\MSSQL\MSSQL.1\OLAP\bin\msmdsrv.exe -s "G:\MSSQL\MSSQL.1\OLAP\Config"

Or did you want something else?

|||

Please open msmdsrv.ini from G:\MSSQL\MSSQL.1\OLAP\Config

Does it contain the following line?

Sunday, March 25, 2012

asp.net

Tuesday, March 20, 2012

Asking for Strong SA password while installing!

Sunday, March 11, 2012

AS2005 without Sql Server 2005

Monday, February 13, 2012

ARe: Problems after the install of the Hotfix

Sunday, February 12, 2012

ARe: Problems after the install of the Hotfix

sql nulls slow

Blog Archive

About Me

About Me

Followers

Blog Archive