sql nulls slow: sp1

Showing posts with label sp1. Show all posts

Thursday, March 22, 2012

ASP error with stored procedure

SQL Server 2000 on Windows 2003 SP1 and IIS6
I'm getting the following error from my ASP page:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Formal parameter '@.mname' was defined as OUTPUT but the actual parameter
not declared OUTPUT.
However, the formal parameter '@.mname' was used in a previous stored
procedure accessed by the same command object and that parameter has been
been deleted prior to the call.
Here's the DDL for the procedure:
CREATE PROCEDURE InsertAndIdentifyNewStarter
@.peopleID INTEGER,
@.newstarterID BIGINT OUTPUT
AS
INSERT INTO newstarter (peopleID)
VALUES (@.peopleID)
SELECT @.newstarterID = SCOPE_IDENTITY()
GO
And the code snippet that's giving the problem:
Dim cmd, ln
Set cmd = Server.CreateObject("ADODB.Command")
With cmd
.ActiveConnection = "Provider=" & DBPROVIDER & ";" & CONNECTIONSTRING
.CommandType = adCmdStoredProc
.CommandText = "InsertAndIdentifyPerson"
.Parameters.Append .CreateParameter("@.fname", adVarChar, _
adParamInput, 100, firstname)
.Parameters.Append .CreateParameter("@.mname", adVarChar, _
adParamInput, 100, middlename)
.Parameters.Append .CreateParameter("@.sname", adVarChar, _
adParamInput, 100, lastname)
.Parameters.Append .CreateParameter("@.fullname", adVarChar, _
adParamInput, 200, firstname & " " & lastname)
.Parameters.Append .CreateParameter("@.datestarted", adDBDate, _
adParamInput, 10, DBStartDate)
.Parameters.Append .CreateParameter("@.enabled", adInteger, _
adParamInput, 10, 1)
.Parameters.Append .CreateParameter("@.existsinaccounts", _
adInteger, adParamInput, 10, 0)
.Parameters.Append .CreateParameter("@.loggedon", adInteger, _
adParamInput, 10, 0)
.Parameters.Append .CreateParameter("@.itstatus", adInteger, _
adParamInput, 10, 5) ' 5 = New Starter
.Parameters.Append .CreateParameter("@.pID", adInteger, _
adParamOutput, 10)
.Execute ln, , adExecuteNoRecords
pID = .Parameters("@.pID")
' Delete the parameters so that we can reuse the command object
While .Parameters.Count > 0
.Parameters.Delete 0
Wend
' Create a newstarter record for this person
.CommandText = "InsertAndIdentifyPerson"
.Parameters.Append .CreateParameter("@.peopleID", adBigInt, _
adParamInput, 10, pID)
.Parameters.Append .CreateParameter("@.newstarterID", _
adBigInt, adParamOutput, 10)
.Execute ln, , adExecuteNoRecords
' ** The preceding line produces the error **
newstarterID = .Parameters("@.newstarterID")
End With
Set cmd = Nothing
Any ideas what I'm doing wrong or what the problem is?
TIA,
Geoff> CREATE PROCEDURE InsertAndIdentifyNewStarterd">
> snip
> .CommandText = "InsertAndIdentifyPerson"
It looks to me like you are executing the wrong proc.
Hope this helps.
Dan Guzman
SQL Server MVP
"Geoff Lane" <geoff@.nospam.gjctech.co.uk> wrote in message
news:Xns97EA7C83661FBgjctcswxnsrt@.207.46.248.16...
> SQL Server 2000 on Windows 2003 SP1 and IIS6
> I'm getting the following error from my ASP page:
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Formal parameter '@.mname' was defined as OUTPUT but the actual parameter
> not declared OUTPUT.
> However, the formal parameter '@.mname' was used in a previous stored
> procedure accessed by the same command object and that parameter has been
> been deleted prior to the call.
> Here's the DDL for the procedure:
> CREATE PROCEDURE InsertAndIdentifyNewStarter
> @.peopleID INTEGER,
> @.newstarterID BIGINT OUTPUT
> AS
> INSERT INTO newstarter (peopleID)
> VALUES (@.peopleID)
> SELECT @.newstarterID = SCOPE_IDENTITY()
> GO
> And the code snippet that's giving the problem:
> Dim cmd, ln
> Set cmd = Server.CreateObject("ADODB.Command")
> With cmd
> .ActiveConnection = "Provider=" & DBPROVIDER & ";" & CONNECTIONSTRING
> .CommandType = adCmdStoredProc
> .CommandText = "InsertAndIdentifyPerson"
> .Parameters.Append .CreateParameter("@.fname", adVarChar, _
> adParamInput, 100, firstname)
> .Parameters.Append .CreateParameter("@.mname", adVarChar, _
> adParamInput, 100, middlename)
> .Parameters.Append .CreateParameter("@.sname", adVarChar, _
> adParamInput, 100, lastname)
> .Parameters.Append .CreateParameter("@.fullname", adVarChar, _
> adParamInput, 200, firstname & " " & lastname)
> .Parameters.Append .CreateParameter("@.datestarted", adDBDate, _
> adParamInput, 10, DBStartDate)
> .Parameters.Append .CreateParameter("@.enabled", adInteger, _
> adParamInput, 10, 1)
> .Parameters.Append .CreateParameter("@.existsinaccounts", _
> adInteger, adParamInput, 10, 0)
> .Parameters.Append .CreateParameter("@.loggedon", adInteger, _
> adParamInput, 10, 0)
> .Parameters.Append .CreateParameter("@.itstatus", adInteger, _
> adParamInput, 10, 5) ' 5 = New Starter
> .Parameters.Append .CreateParameter("@.pID", adInteger, _
> adParamOutput, 10)
> .Execute ln, , adExecuteNoRecords
> pID = .Parameters("@.pID")
> ' Delete the parameters so that we can reuse the command object
> While .Parameters.Count > 0
> .Parameters.Delete 0
> Wend
> ' Create a newstarter record for this person
> .CommandText = "InsertAndIdentifyPerson"
> .Parameters.Append .CreateParameter("@.peopleID", adBigInt, _
> adParamInput, 10, pID)
> .Parameters.Append .CreateParameter("@.newstarterID", _
> adBigInt, adParamOutput, 10)
> .Execute ln, , adExecuteNoRecords
> ' ** The preceding line produces the error **
> newstarterID = .Parameters("@.newstarterID")
> End With
> Set cmd = Nothing
> Any ideas what I'm doing wrong or what the problem is?
> TIA,
> --
> Geoff|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in
news:elcHsWflGHA.5044@.TK2MSFTNGP02.phx.gbl:

> It looks to me like you are executing the wrong proc.
D'Oh! That'll teach me to cut-and-paste code :(
Thanks - you are correct!
Geoff

ASP data access difficulties

I'm using ASP pages to access a Microsoft SQL 2005 SP1 database server for information that populates dropdown menus. I ran into an interesting problem. We can query all existing data without a problem (all expected rows return and correctly populate the dropdowns).

I manually add a new row to the database table for a dropdown. I can manually query the database from the SQL2005 management tool, and the new records are included in the results.

I load the ASP page, and the newly added records never appear in the dropdown... only the old, existing data.

What could cause this? The queries from ASP are the same as the queries I make directly from the SQL server.

Could you please post the part of your code that is filling the dropdown boxes ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

-relevant snip-

<% SQL = "sp_GetVMFarmList"
set rs = conn.execute(SQL) %>
<select name="VMFarm" class="InputBox">
<option></option>
<% while not rs.eof
strSelected = ""
if intFarmID <> "" then
if cint(intFarmID) = cint(rs("FarmID")) then
strSelected = "Selected"
end if
end if %>
<option <%=strSelected %> value="<%=rs("FarmID")%>"><%=rs("FarmName")%></option>

<% rs.movenext
wend %>
</select>

|||

Any page directives or server settings to cache the pages ? BTW you should not use sp_ prefixes as SQL will *always* do a recompilation to the procedures as the prefix is reserved for system procedures. Better use usp_Something or spSomething.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||No caching, nothing on the web server (IIS 6) has changed. I restarted the IIS service several times to make sure it wasn't trying to hold onto any data|||

Probably a silly question, but have you checked from another computer to make sure your computer isn't caching the data?

|||

Oh yes... in fact it was several other users reporting that they couldn't see the new data I added to the tables. they all use different PCs.

|||

I assume you've made a backup of your data If not, that would be my first step right now. Now I'm going to go into what I call "guess mode because I don't really know what's going on"....

Then I would start playing with it, see if the website even recognizes any sort of change, such as removing some rows. If nothing is responding I would drop the table and reload it and see if that helps. However, like I said, you definitely need to have a backup of your data because you never know how the reloading stage might go.

|||When you say "I can manually query the database from SQL2005 management tool", you mean you run sp_GetVMFarmList, or you are doing the query that is defined in the stored procedure?|||

Both

|||

try Response.Expires = 0 at the top of the ASP page, to make sure you don't have some additional caching. But probably you should now examine your update code, instead of the dropdown code.

ASP data access difficulties

I manually add a new row to the database table for a dropdown. I can manually query the database from the SQL2005 management tool, and the new records are included in the results.

I load the ASP page, and the newly added records never appear in the dropdown... only the old, existing data.

What could cause this? The queries from ASP are the same as the queries I make directly from the SQL server.

Could you please post the part of your code that is filling the dropdown boxes ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

-relevant snip-

<% rs.movenext
wend %>
</select>

|||

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

No caching, nothing on the web server (IIS 6) has changed. I restarted the IIS service several times to make sure it wasn't trying to hold onto any data|||

Probably a silly question, but have you checked from another computer to make sure your computer isn't caching the data?

|||

Oh yes... in fact it was several other users reporting that they couldn't see the new data I added to the tables. they all use different PCs.

|||

I assume you've made a backup of your data If not, that would be my first step right now. Now I'm going to go into what I call "guess mode because I don't really know what's going on"....

|||When you say "I can manually query the database from SQL2005 management tool", you mean you run sp_GetVMFarmList, or you are doing the query that is defined in the stored procedure?

|||

Both

|||

try Response.Expires = 0 at the top of the ASP page, to make sure you don't have some additional caching. But probably you should now examine your update code, instead of the dropdown code.

Thursday, March 8, 2012

AS2005 calculations bug?

This problem appears in BI-Developer Studio SP1 on a Windows 2003 Terminal server session. It appeared when I switched from the list view to the script/code view.

The calculations tab is empty with only this error message:

"Unexpected error occurred. Length cannot be less than zero. Parmeter name:length"

I am unable to see the calculations in the script view and in the list view. It is possible to see the calculations in the xml file if I choose code view.

Anyone who have seen this before?

Regards

Thomas Ivarsson

Problem solved. I had some rolling last 12 months calculations in a cube with only a few months of data that I tried to set to null and commented out all MDX-code. The purpose was to activate these calculations later. After removing null and activating the MDX-code everything works fine.

I think however that this is a minor bug.

Regards

Thomas Ivarsson

Saturday, February 25, 2012

AS 2005 browse cube problem

I have successfully deployed an Analysis Services Project on Analysis
Server 2005 with SP1. However, when I try to browse the cube using
either BI studio or SQL Server management studio, everything stucks.
Dimensions browsing and cube processing works fine!
Any ideas?
Thanks, MakisYou can use Profiler to trace against Analysis Services with 2005. I suggest
you give that a try to examine what is happening behind the scenes
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David@.MutuallyBeneficial.com
<gmarketos@.gmail.com> wrote in message
news:1147262990.507126.46230@.j33g2000cwa.googlegroups.com...
>I have successfully deployed an Analysis Services Project on Analysis
> Server 2005 with SP1. However, when I try to browse the cube using
> either BI studio or SQL Server management studio, everything stucks.
> Dimensions browsing and cube processing works fine!
> Any ideas?
> Thanks, Makis
>|||Thank you David for your answer.
After all I realized that my firewall created the problem.
Makis
David Lundell wrote:[vbcol=seagreen]
> You can use Profiler to trace against Analysis Services with 2005. I sugge
st
> you give that a try to examine what is happening behind the scenes
> --
> David Lundell
> Principal Consultant and Trainer
> www.MutuallyBeneficial.com
> David@.MutuallyBeneficial.com
> <gmarketos@.gmail.com> wrote in message
> news:1147262990.507126.46230@.j33g2000cwa.googlegroups.com...

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?

Thursday, March 22, 2012

ASP error with stored procedure

ASP data access difficulties

ASP data access difficulties

Thursday, March 8, 2012

AS2005 calculations bug?

Saturday, February 25, 2012

AS 2005 browse cube problem

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