Problems installing SQLServer 2000 Developer Edition on Windows XP Pro

Hello!

When trying to install SqlServer 2000 Developer (as Administrator) on my
Windows XP Professional I get the following message at the point where
the system asks Local Account or Domain account:

The logon account cannot be validated for the SQL server service. Verify
that the user name and password entered are correct. The logon attempt
failed.

Anyone an idea what goes wrong here?

Thanks for your info.

Daniel

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Make sure that the account you are providing has the "log on as
service" rights to local machine. After you verified that you didn't
make a typo entering the login. :-)
Alexey

Daniel Kim <daekim_2000@.netzero.net> wrote in message news:<3f73dfb0$0$62084$75868355@.news.frii.net>...
> Hello!
> When trying to install SqlServer 2000 Developer (as Administrator) on my
> Windows XP Professional I get the following message at the point where
> the system asks Local Account or Domain account:
>
> The logon account cannot be validated for the SQL server service. Verify
> that the user name and password entered are correct. The logon attempt
> failed.
>
> Anyone an idea what goes wrong here?
> Thanks for your info.
>
> Daniel
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!sql

Problems installing msde2000a

When i try to install MSDE2000A i get the following error message:
The system cannot open the device or file specified.
Internal error 2755. 110
C:\Msde\Setup\SqlRun01.msi
I start with the following parametres:
DISABLENETWORKPROTOCOLS=0 INSTANCENAME="OpfServer" SAPWD="Opf" SECURITYMODE=SQL
Regards,
Olav
Maybe the media you are installing from is corrupt or the file is missing?
Jim
"Olav" <anonymous@.discussions.microsoft.com> wrote in message
news:BC928DD0-41AC-444E-B211-3A4E7F5800FD@.microsoft.com...
> When i try to install MSDE2000A i get the following error message:
> The system cannot open the device or file specified.
> Internal error 2755. 110
> C:\Msde\Setup\SqlRun01.msi
> I start with the following parametres:
> DISABLENETWORKPROTOCOLS=0 INSTANCENAME="OpfServer" SAPWD="Opf"
SECURITYMODE=SQL
> Regards,
> Olav
|||Hi Jim,
I have just downloaded it from MS and unwrapped it to my harddsisk with the message that it was succesfully delivered. The file SqlRun01.msi is in the Setup directory.
I have uninstalled MS SQL Server 2000 and rebooted after.
Regards,
Olav

Problems installing MSDE

When a double click setup.exe, I get the following message:

"SQL Server 2000 Desktop Engine Setup

SQL Server 2000 Desktop Engine cannot be installed on thiscomputer. This product requires Microsoft Windows NT Version 4.0 Service Pack 5or higher. Please download the service pack fromwww.microsoft.com prior to installing."

My machine is running Windows 2000 5.00.2195 Service Pack 4.
Anyone knows how to solve this problem?

Part of the problems installing MSDE is trying to install the service pack before SQL Server, try the link below and download the eval edition good for 120 days and the developer edition is $30 or less on the web . Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx|||Thanks for your advice. I didn't write back earlier because I wanted to try our solution until I it was successful.
I tried what you suggested, but I was still getting the error message.I looked into the autorun.inf file. In it it had these lines
...
[servicepack]
NTVersion=4
...
I verified that I could run MSDE on my OS by reading the documentation.Then, I commented out the line, and the installation rancorrectly.

Problems inserting datetime object into sql server 2005

hey everyone,

Im trying run a stored procedure, but I am getting the following message when trying to execute it.

Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.

which seems strange, as there is no integer going to a datetime field. Also, it does not return the value that is incorrect, nor the parameter that is failing. If there is anyway to view this in VS 2005 Team suite, please let me know.

It should also be noted that when I execute this sproc from within sql management studio, it executes fine.

This is the stored procedure im trying to execute...

CREATE PROCEDURE [dbo].[sp_UpdateRequest]

@.request_id INT,
@.request_client_id INT,
@.request_description VARCHAR(150), @.request_date DATETIME,
@.request_edit_date DATETIME, @.request_status VARCHAR(25), @.request_approve_date DATETIME,
@.request_activity_code VARCHAR(7), @.request_department_code VARCHAR(3), @.request_participants INT,
@.request_activity_date DATETIME, @.request_activity_due_date DATETIME,
@.request_company_id INT, @.request_company_code INT,
@.request_notes VARCHAR(2000)

AS
BEGIN

UPDATE invoice_requests

SET request_client_id = @.request_client_id, request_description = @.request_description,
request_date = @.request_date, request_edit_date = @.request_edit_date,
request_status = @.request_status, request_approve_date = @.request_approve_date,
request_activity_code = @.request_activity_code,
request_department_code = @.request_department_code,
request_participants = @.request_participants,
request_activity_date = @.request_activity_date,
request_activity_due_date = @.request_activity_due_date,
request_company_code = @.request_company_code, request_company_id = @.request_company_id,
request_notes = @.request_notes

WHERE request_id = @.request_id

END
GO

in my .net app, all the datetime objects are valid dates, so I could not see why this would be generating the error that it is, so I ran the SQL Profiler, and this was the output. Again, i cannot see where im going wrong...

please note, I have seperated the output from the single slab of text, making sure I didnt remove anything...

exec sp_executesql
N'EXECUTE sp_UpdateRequest
@.request_id,
@.request_client_id,
@.request_description,
@.request_date,
@.request_edit_date,
@.request_status,
@.request_approve_date,
@.request_activity_code,
@.request_participants,
@.request_activity_date,
@.request_activity_due_date,
@.request_company_id,
@.request_company_code,
@.request_notes',

N'@.request_id int,
@.request_client_id int,
@.request_description varchar(8000),
@.request_date datetime,
@.request_edit_date datetime,
@.request_status varchar(5),
@.request_approve_date datetime,
@.request_activity_code varchar(8000),
@.request_department_code varchar(8000),
@.request_participants int,
@.request_activity_date datetime,
@.request_activity_due_date datetime,
@.request_company_id int,
@.request_company_code int,
@.request_notes varchar(8000)',

@.request_id=5,
@.request_client_id=1,
@.request_description='',
@.request_date=''2007-11-22 16:34:32:997'',
@.request_edit_date=''2007-11-22 16:34:32:997'',
@.request_status='Draft',
@.request_approve_date=''1970-01-01 00:00:00:000'',
@.request_activity_code='',
@.request_department_code='',
@.request_participants=0,
@.request_activity_date=''2007-11-29 00:00:00:000'',
@.request_activity_due_date=''2007-11-23 00:00:00:000'',
@.request_company_id=0,
@.request_company_code=1,
@.request_notes=''

any help on this would be greatly appreciated.
Cheershey everyone, when i try to run the the following trace result as a query, i get an error near 2007...

exec sp_executesql N'EXECUTE sp_UpdateRequest @.request_id, @.request_client_id, @.request_description, @.request_date, @.request_edit_date, @.request_status, @.request_approve_date, @.request_activity_code, @.request_participants,
@.request_activity_date, @.request_activity_due_date, @.request_company_id, @.request_company_code, @.request_notes',N'@.request_id int,@.request_client_id int,@.request_description varchar(6),@.request_date datetime,@.request_edit_date
datetime,@.request_status varchar(5),@.request_approve_date datetime,@.request_activity_code varchar(4),@.request_department_code varchar(3),@.request_participants int,@.request_activity_date datetime,@.request_activity_due_date
datetime,@.request_company_id int,@.request_company_code int,@.request_notes varchar(11)',@.request_id=1,@.request_client_id=1,@.r equest_description='Justin',@.request_date=''2007-11-23 08:59:04:250'',@.request_edit_date=''2007-11-23
08:59:04:250'',@.request_status='Draft',@.request_ap prove_date=''1970-01-01 00:00:00:000'',@.request_activity_code='0000',@.requ est_department_code='022',@.request_participants=50 ,@.request_activity_date=''2007-11-23
00:00:00:000'',@.request_activity_due_date=''2007-11-30 00:00:00:000'',@.request_company_id=5292,@.request_c ompany_code=1,@.request_notes='Other Notes'

are there meant to be the double single quotes('') before and after the date?

Cheers,|||are there meant to be the double single quotes('') before and after the date?No, there should be a single apostrophe surrounding (before and after) date constants.

Your constant ''2007-11-23 08:59:04:250'' syntactically ought to be '2007-11-23 08:59:04:250' for use in Microsoft SQL Server.

-PatP|||No, there should be a single apostrophe surrounding (before and after) date constants.

Your constant ''2007-11-23 08:59:04:250'' syntactically ought to be '2007-11-23 08:59:04:250' for use in Microsoft SQL Server.

-PatP

I'm not sure because it's already surrounded by single quotes.

maybe you can try '''2007-11-23 08:59:04:250'''|||Sorry, I should have looked at your whole example.

There are multiple ways that I could parse what you've posted. The one that makes the most sense to me at the moment is:exec sp_executesql N'EXECUTE sp_UpdateRequest
@.request_id, @.request_client_id, @.request_description
, @.request_date, @.request_edit_date, @.request_status
, @.request_approve_date, @.request_activity_code, @.request_participants
, @.request_activity_date, @.request_activity_due_date, @.request_company_id
, @.request_company_code, @.request_notes'', N''@.request_id int
, @.request_client_id int, @.request_description varchar(6), @.request_date datetime
, @.request_edit_date datetime, @.request_status varchar(5), @.request_approve_date datetime
, @.request_activity_code varchar(4), @.request_department_code varchar(3), @.request_participants int
, @.request_activity_date datetime, @.request_activity_due_date datetime, @.request_company_id int
, @.request_company_code int, @.request_notes varchar(11)''
, @.request_id = 1, @.request_client_id = 1, @.request_description = ''Justin''
, @.request_date = ''2007-11-23 08:59:04:250'', @.request_edit_date = ''2007-11-23 08:59:04:250''
, @.request_status = ''Draft'', @.request_approve_date = ''1970-01-01 00:00:00:000''
, @.request_activity_code = ''0000'', @.request_department_code = ''022'', @.request_participants = 50
, @.request_activity_date = ''2007-11-23 00:00:00:000'', @.request_activity_due_date = ''2007-11-30 00:00:00:000''
, @.request_company_id = 5292, @.request_company_code = 1, @.request_notes = ''Other Notes''
'See if that represents what you think you meant, and let me know how it works for you.

-PatPsql

Problems in selecting record.

I have a table A which has the following structure:
Column Name(Type)
-- --
ID(int)
Repair Code(varchar)
Damage Code(varchar)
Location Code (varchar)
I also have a the master code table
Column Name(Type)
-- --
Code Type (int)
Code Name (varchar)
Code Description ( varchar)
and have a stored procedure called GetCodeDescription which input the Code
Type and Code Name , display the Code Description found in the code master
table.
I want to select the record from TabelA by inputting a ID , then select the
record which have the follwong structure
Column Name(Type)
--
ID (int)
Repair Code (varchar)
Repair Code Description (varchar)
Damage Code (varchar)
Damage Code Description (varchar)
Location Code (varchar)
Location Code Description (varchar)
How can I do it by using the GetCodeDescription stored procedure?
Thnak you very much !Trying to use the stored procedure is only going to make things much,
much more complicated than necessary. How about just doing a query?
SELECT A.ID,
A.RepairCode, B.COdeDescription as RepairDescription,
A.DamagerCode, C.COdeDescription as DamageDescription,
A.LocationCode, D.COdeDescription as LocationDescription
FROM TableA as A
JOIN MasterCodes as B
ON A.RepairCode = B.CodeName
AND B.CodeType = 1
JOIN MasterCodes as C
ON A.DamageCode = C.CodeName
AND C.CodeType = 2
JOIN MasterCodes as D
ON A.LocationrCode = D.CodeName
AND D.CodeType = 3
Roy
On Tue, 21 Feb 2006 18:41:27 -0800, "BallBall"
<BallBall@.discussions.microsoft.com> wrote:

>I have a table A which has the following structure:
>Column Name(Type)
>-- --
>ID(int)
>Repair Code(varchar)
>Damage Code(varchar)
>Location Code (varchar)
>I also have a the master code table
>Column Name(Type)
>-- --
>Code Type (int)
>Code Name (varchar)
>Code Description ( varchar)
>and have a stored procedure called GetCodeDescription which input the Code
>Type and Code Name , display the Code Description found in the code maste
r
>table.
>I want to select the record from TabelA by inputting a ID , then select the
>record which have the follwong structure
>Column Name(Type)
>--
>ID (int)
>Repair Code (varchar)
>Repair Code Description (varchar)
>Damage Code (varchar)
>Damage Code Description (varchar)
>Location Code (varchar)
>Location Code Description (varchar)
>How can I do it by using the GetCodeDescription stored procedure?
>Thnak you very much !
>|||Thank for the answer , but because my code table container about 12000
records, if i join many times , i think the performance will be affected
"Roy Harvey" wrote:

> Trying to use the stored procedure is only going to make things much,
> much more complicated than necessary. How about just doing a query?
> SELECT A.ID,
> A.RepairCode, B.COdeDescription as RepairDescription,
> A.DamagerCode, C.COdeDescription as DamageDescription,
> A.LocationCode, D.COdeDescription as LocationDescription
> FROM TableA as A
> JOIN MasterCodes as B
> ON A.RepairCode = B.CodeName
> AND B.CodeType = 1
> JOIN MasterCodes as C
> ON A.DamageCode = C.CodeName
> AND C.CodeType = 2
> JOIN MasterCodes as D
> ON A.LocationrCode = D.CodeName
> AND D.CodeType = 3
> Roy
>
> On Tue, 21 Feb 2006 18:41:27 -0800, "BallBall"
> <BallBall@.discussions.microsoft.com> wrote:
>
>|||Try the join first. You will probably find the performance is just fine,
and simpler to manage.
"BallBall" <BallBall@.discussions.microsoft.com> wrote in message
news:36B2D0B0-6201-42BE-933B-079D4FCE44DE@.microsoft.com...
> Thank for the answer , but because my code table container about 12000
> records, if i join many times , i think the performance will be affected
> "Roy Harvey" wrote:
>
Code
master
the|||Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. Your personal narrative and pseudo-code are useless.
That would be a horrible design error! Go back to the foundations; a
table is made up of one and only one kind of entity. There is no such
thing as "master code table" in a valid schema.
Next, a data element can be a type or a code but not a "type_code";
read ISO-11179. Next you confuse rows with records and columns with
fields and do not bother to give us table names.
Finally, how do you get enough codes into a VARCHAR(1) column? In a
good design, codes are fixed length and have a validation rule. There
is no such thing as a magical universal "id" in RDBMS; you are not
actually using IDENTITY in an RDBMS, are you'
I have to make a wild guess about the key
CREATE TABLE RepairRequests
(repair_nbr INTEGER NOT NULL,
repair_code INTEGER NOT NULL
REFERENCES Repairs (repair_code)
ON UPDATE CASCADE,
PRIMARY KEY (repair_nbr, repair_code),
damage_code INTEGER NOT NULL
REFERENCES Damages(damage_code)
ON UPDATE CASCADE,
location_code INTEGER NOT NULL
REFERENCES Locations (location_code)
ON UPDATE CASCADE);
CREATE TABLE Repairs
(repair_code INTEGER NOT NULL PRIMARY KEY,
repair_description VARCHAR(20) NOT NULL,
.) ;
CREATE TABLE Damages
(damage_code INTEGER NOT NULL PRIMARY KEY,
damage_description VARCHAR(20) NOT NULL,
.) ;
CREATE TABLE Locations
(location_code INTEGER NOT NULL PRIMARY KEY,
location_description VARCHAR(20) NOT NULL,
.) ;
I have no idea; where is the code for this stored procedure?
I see that you also do not understand what a repeated group is and how
to program in a tiered architecture. This should be done as a simple
query. But assuming that you really do hate RDBMS, how do you handle
a repair request with more or less than two damages on it?|||>Thank for the answer , but because my code table container about 12000
>records, if i join many times , i think the performance will be affected
If performance is bad the table is not indexed correctly. Also it is
not necessary to guess what performance will be, all you have to do is
run the queries in Query Analyzer to see what it is. Easy, quick, and
you can learn a lot.
Twelve thousand rows is really all that large, by the way. With
proper indexing performance should be fine with ten or a hundred times
as many rows.
Roy

problems in variable passing from shell to procedure

hi,
i need to passing the variable from shell script to procedure,but it does not work.the following are my shell and procedure.
job(){
sqlplus user/password@.orcl <<EOF
exec count_prize_proc($1,$2,$3)
EOF
}
if [ $# -eq 3 ] ;then
job
else
echo " EXAMPLEjobstart.sh 155 200 210 "
fi

create or replace procedure count_prize_proc
(t_play_code in varchar2,
t_begin_term in varchar2,
t_end_term in varchar2 )
IS

------------------
call_proc.sh 005 100 200
write win_prize Program
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Oct 30 13:59:02 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production

SQL> BEGIN count_prize_proc(,,); END;
*
ERROR at line 1:
ORA-06550: line 1, column 24:
PLS-00103: Encountered the symbol "," when expecting one of the following:
( ) - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table avg count current exists max min prior sql stddev sum
variance execute multiset the both leading trailing forall
year month DAY_ HOUR_ MINUTE_ second TIMEZONE_HOUR_
TIMEZONE_MINUTE_ time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>

SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
-------------------
then i modified my shell
exec count_prize_proc("$1","$2","$3")

------------------
SQL> ERROR:
ORA-01741: illegal zero-length identifier

Any ideas/suggestions?
thanks advance

graceHi,

ORA-01741: illegal zero-length identifier is raised because, an attempt was made to use two double quotes ("") as an identifier.

An identifier must be at least one character long. Action: Insert at least one character between the double quotes in the identifier. If a blank identifier is required, specify a blank space between the double quotes (" ").sql

Problems exporting to Excel

I am getting the following error message when I try to export to mulitple sheets (running 2000)

Excel Rendering Extension : Width of excel cell in the excel sheet exceeded the max limit of 1726.5 points.

If I take each the matrix out, it works ok. If I put the matrix back in, and take out the table it also works ok, it is only when I try to go both.

Does the matrix or table have a very wide column? Is there a large horizontal space between them? The Excel has to map the structures to cells in Excel. These cells have maximum widths that cannot be exceeded.

If you post your RDL, I might be able to offer more specific guidance.

|||How do I post the rdl.

Problems exporting to Excel

I am getting the following error message when I try to export to mulitple sheets (running 2000)

Excel Rendering Extension : Width of excel cell in the excel sheet exceeded the max limit of 1726.5 points.

If I take each the matrix out, it works ok. If I put the matrix back in, and take out the table it also works ok, it is only when I try to go both.

Does the matrix or table have a very wide column? Is there a large horizontal space between them? The Excel has to map the structures to cells in Excel. These cells have maximum widths that cannot be exceeded.

If you post your RDL, I might be able to offer more specific guidance.

|||How do I post the rdl.sql

Problems deploying SSRS2005 security extension example

Dear All,
I've been trying to deploy the security extension example from
Microsoft for SSRS2005 and have encountered the following errors when
I access the reports virtual directory (although the pages/
UILogin.aspx page comes up)
- Report Server Web App reports that the report server is not
responding.
- Report Server reports that it cannot access (access denied)
accessing the dll file.
Can anyone help me with this?
Config File Segments:
________________________________________________________________________
rsmreportserver.config (file exists when I do a dir command on the
path in the type attribute)
<Security>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.Authorization,
Microsoft.Samples.ReportingServices.CustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>prime</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
<Authentication>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension,
Microsoft.Samples.ReportingServices.CustomSecurity" />
</Authentication>
_____________________________________________________________________
rssrvpolicy.config
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="SecurityExtensionCodeGroup"
Description="Code group for the sample security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin
\Microsoft.Samples.ReportingServices.CustomSecurity.dll"
/>
</CodeGroup>
_____________________________________________________________________
rsswebapplication.config (note xxx=actual hostname)
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://xxx/reportserver</ReportServerUrl>
</UI>
_____________________________________________________________________
_____________________________________________________________________
ReportServer WebApp Log
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing WatsonFlags
to default value of '1064' because it was not specified in
Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
WatsonDumpOnExceptions to default value of
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
because it was not specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to default value of
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
because it was not specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not
specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it
was not specified in Configuration file.
w3wp!ui!1!12/3/2007-18:28:05:: e ERROR: The report server is not
responding. Verify that the report server is running and can be
accessed from this computer.
w3wp!ui!1!12/3/2007-18:28:06:: e ERROR: HTTP status code --> 500
--Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper
+CantCommunicateWithReportServerException: The report server is not
responding. Verify that the report server is running and can be
accessed from this computer.
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!12/3/2007-18:28:07:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at
Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at
Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
_________________________________________________________________________
ReportServer Log
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Running Requests DB
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Memory stats update
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!extensionfactory!7!12/03/2007-18:28:04:: e ERROR: Exception
caught instantiating Forms report server extension:
System.IO.FileLoadException: Could not load file or assembly
'Microsoft.Samples.ReportingServices.CustomSecurity' or one of its
dependencies. Access is denied.
File name: 'Microsoft.Samples.ReportingServices.CustomSecurity'
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String
codeBase, Evidence assemblySecurity, Assembly locationHint,
StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean
forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName
assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark,
Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String
name)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension
extConfig)
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM
\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind
failure logging.
To turn this feature off, remove the registry value [HKLM\Software
\Microsoft\Fusion!EnableLog].
.
w3wp!library!7!12/03/2007-18:28:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information., Could not load
Authentication extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information.
w3wp!library!7!12/03/2007-18:28:06:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information., Could not load
Authentication extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information.
w3wp!library!8!12/3/2007-18:29:04:: i INFO: Catalog SQL Server Edition
= Developer
w3wp!library!7!12/3/2007-18:38:04:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs, 0 persisted streams
__________________________________________________________
Thanks, HerbHi
Ive got the same problem, but only on windows server 2003 using ssl. It runs
fine untill i install a ssl certificate, then it gives me a similar error. *.
ReportingServices.CustomSecurity* file not found.
If i reverse the ssl certificate, the problem remains. The same stuff works
fine on win xp with ssl though, and on win server 2003 without ssl. How did
you resolve this?
thanks
Leon
url:http://www.ureader.com/msg/115713209.aspx

Problems deleting a column from SQL2000

Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:
'web_cartOrders' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line
2: Incorrect
syntax near 'abc1'.
I tried to delete it from SQL Analyzer directly from the server's console,
but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'abc1'."
I tried to rename, change data type and size of the data type of the column,
but still could not delete it.
Any thoughts?
Thanksmight be worth running Profiler to capture the SQL that is getting issued /
generated by Enterprise Manager just to try and see whats going on
Andy.
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:B221D62F-4C50-4DEB-96F0-766AE8B7D8EF@.microsoft.com...
> Hello,
> I'm trying to delete an existing varchar(10) column called "abc1" o in a
> table on a SQL 2000 database and I'm getting the following error message
in
> Enterprise Manager.:
> 'web_cartOrders' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:[/vb
col]
Incorrect[vbcol=seagreen]
> syntax near 'abc1'.
>
> I tried to delete it from SQL Analyzer directly from the server's console,
> but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
> Line 1: Incorrect syntax near 'abc1'."
> I tried to rename, change data type and size of the data type of the
column,
> but still could not delete it.
> Any thoughts?
> Thanks|||Check your database compatibility level. I know some people
have hit the error when it's set to 64. You can execute
sp_dbcmptlevel to check it.
-Sue
On Tue, 10 Aug 2004 15:25:04 -0700, "Vi"
<Vi@.discussions.microsoft.com> wrote:

>Hello,
>I'm trying to delete an existing varchar(10) column called "abc1" o in a
>table on a SQL 2000 database and I'm getting the following error message in
>Enterprise Manager.:
>'web_cartOrders' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line
2: Incorrect
>syntax near 'abc1'.
>
>I tried to delete it from SQL Analyzer directly from the server's console,
>but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
>Line 1: Incorrect syntax near 'abc1'."
>I tried to rename, change data type and size of the data type of the column
,
>but still could not delete it.
>Any thoughts?
>Thanks

Problems deleting a column from SQL2000

Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:
'web_cartOrders' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
syntax near 'abc1'.
I tried to delete it from SQL Analyzer directly from the server's console,
but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'abc1'."
I tried to rename, change data type and size of the data type of the column,
but still could not delete it.
Any thoughts?
Thanks
might be worth running Profiler to capture the SQL that is getting issued /
generated by Enterprise Manager just to try and see whats going on
Andy.
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:B221D62F-4C50-4DEB-96F0-766AE8B7D8EF@.microsoft.com...
> Hello,
> I'm trying to delete an existing varchar(10) column called "abc1" o in a
> table on a SQL 2000 database and I'm getting the following error message
in
> Enterprise Manager.:
> 'web_cartOrders' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect
> syntax near 'abc1'.
>
> I tried to delete it from SQL Analyzer directly from the server's console,
> but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
> Line 1: Incorrect syntax near 'abc1'."
> I tried to rename, change data type and size of the data type of the
column,
> but still could not delete it.
> Any thoughts?
> Thanks
|||Check your database compatibility level. I know some people
have hit the error when it's set to 64. You can execute
sp_dbcmptlevel to check it.
-Sue
On Tue, 10 Aug 2004 15:25:04 -0700, "Vi"
<Vi@.discussions.microsoft.com> wrote:

>Hello,
>I'm trying to delete an existing varchar(10) column called "abc1" o in a
>table on a SQL 2000 database and I'm getting the following error message in
>Enterprise Manager.:
>'web_cartOrders' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
>syntax near 'abc1'.
>
>I tried to delete it from SQL Analyzer directly from the server's console,
>but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
>Line 1: Incorrect syntax near 'abc1'."
>I tried to rename, change data type and size of the data type of the column,
>but still could not delete it.
>Any thoughts?
>Thanks
sql

Problems deleting a column

Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:
'myTable' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
syntax near 'abc1'.
I tried to delete it from SQL Analyzer directly from the server's console,
but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'abc1'."
I tried to rename, change data type and size of the data type of the column,
but still could not delete it.
Any thoughts?
ThanksOn Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:
>Hello,
>I'm trying to delete an existing varchar(10) column called "abc1" o in a
>table on a SQL 2000 database and I'm getting the following error message in
>Enterprise Manager.:
>'myTable' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
>syntax near 'abc1'.
>
>I tried to delete it from SQL Analyzer directly from the server's console,
>but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
>Line 1: Incorrect syntax near 'abc1'."
>I tried to rename, change data type and size of the data type of the column,
>but still could not delete it.
>Any thoughts?
>Thanks
Hi Vi,
You forgot to include the code you executed in query analyzer when you got
this error message.
Dropping the column abc1 from table myTable should be possible with the
following statement:
ALTER TABLE myTable
DROP COLUMN abc1
(untested)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||The code is:
--
USE myDatabase
go
ALTER TABLE dbo.myTable DROP COLUMN abc1
go
--
"Hugo Kornelis" wrote:
> On Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:
> >Hello,
> >I'm trying to delete an existing varchar(10) column called "abc1" o in a
> >table on a SQL 2000 database and I'm getting the following error message in
> >Enterprise Manager.:
> >
> >'myTable' table
> >- Unable to modify table.
> >ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
> >syntax near 'abc1'.
> >
> >
> >I tried to delete it from SQL Analyzer directly from the server's console,
> >but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
> >Line 1: Incorrect syntax near 'abc1'."
> >
> >I tried to rename, change data type and size of the data type of the column,
> >but still could not delete it.
> >
> >Any thoughts?
> >Thanks
> Hi Vi,
> You forgot to include the code you executed in query analyzer when you got
> this error message.
> Dropping the column abc1 from table myTable should be possible with the
> following statement:
> ALTER TABLE myTable
> DROP COLUMN abc1
> (untested)
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>|||Perhaps your database is set to a pre 70 compatibility level. You can check
this with:
EXEC sp_dbcmptlevel 'myDatabase'
And set it with:
EXEC sp_dbcmptlevel 'myDatabase', 80
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:EA353C88-D7EC-46BB-A31A-F748F87B40FE@.microsoft.com...
> The code is:
> --
> USE myDatabase
> go
> ALTER TABLE dbo.myTable DROP COLUMN abc1
> go
> --
> "Hugo Kornelis" wrote:
> > On Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:
> >
> > >Hello,
> > >I'm trying to delete an existing varchar(10) column called "abc1" o in
a
> > >table on a SQL 2000 database and I'm getting the following error
message in
> > >Enterprise Manager.:
> > >
> > >'myTable' table
> > >- Unable to modify table.
> > >ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect
> > >syntax near 'abc1'.
> > >
> > >
> > >I tried to delete it from SQL Analyzer directly from the server's
console,
> > >but I'm getting a similar error: "Server: Msg 170, Level 15, State 1,
Line 1
> > >Line 1: Incorrect syntax near 'abc1'."
> > >
> > >I tried to rename, change data type and size of the data type of the
column,
> > >but still could not delete it.
> > >
> > >Any thoughts?
> > >Thanks
> >
> > Hi Vi,
> >
> > You forgot to include the code you executed in query analyzer when you
got
> > this error message.
> >
> > Dropping the column abc1 from table myTable should be possible with the
> > following statement:
> >
> > ALTER TABLE myTable
> > DROP COLUMN abc1
> > (untested)
> >
> > Best, Hugo
> > --
> >
> > (Remove _NO_ and _SPAM_ to get my e-mail address)
> >|||What do you mean that you tried to change the data type and size of the
column? Were you able to do that? Or did you get error messages for those
operations also.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:9F0BD776-CA70-42C4-92D6-0338228817EA@.microsoft.com...
> Hello,
> I'm trying to delete an existing varchar(10) column called "abc1" o in a
> table on a SQL 2000 database and I'm getting the following error message
in
> Enterprise Manager.:
> 'myTable' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect
> syntax near 'abc1'.
>
> I tried to delete it from SQL Analyzer directly from the server's console,
> but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
> Line 1: Incorrect syntax near 'abc1'."
> I tried to rename, change data type and size of the data type of the
column,
> but still could not delete it.
> Any thoughts?
> Thanks

Problems deleting a column

Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:
'myTable' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line
2: Incorrect
syntax near 'abc1'.
I tried to delete it from SQL Analyzer directly from the server's console,
but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'abc1'."
I tried to rename, change data type and size of the data type of the column,
but still could not delete it.
Any thoughts?
ThanksOn Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:

>Hello,
>I'm trying to delete an existing varchar(10) column called "abc1" o in a
>table on a SQL 2000 database and I'm getting the following error message in
>Enterprise Manager.:
>'myTable' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line
2: Incorrect
>syntax near 'abc1'.
>
>I tried to delete it from SQL Analyzer directly from the server's console,
>but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
>Line 1: Incorrect syntax near 'abc1'."
>I tried to rename, change data type and size of the data type of the column
,
>but still could not delete it.
>Any thoughts?
>Thanks
Hi Vi,
You forgot to include the code you executed in query analyzer when you got
this error message.
Dropping the column abc1 from table myTable should be possible with the
following statement:
ALTER TABLE myTable
DROP COLUMN abc1
(untested)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||The code is:
--
USE myDatabase
go
ALTER TABLE dbo.myTable DROP COLUMN abc1
go
--
"Hugo Kornelis" wrote:

> On Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:
>
> Hi Vi,
> You forgot to include the code you executed in query analyzer when you got
> this error message.
> Dropping the column abc1 from table myTable should be possible with the
> following statement:
> ALTER TABLE myTable
> DROP COLUMN abc1
> (untested)
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>|||Perhaps your database is set to a pre 70 compatibility level. You can check
this with:
EXEC sp_dbcmptlevel 'myDatabase'
And set it with:
EXEC sp_dbcmptlevel 'myDatabase', 80
Hope this helps.
Dan Guzman
SQL Server MVP
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:EA353C88-D7EC-46BB-A31A-F748F87B40FE@.microsoft.com...[vbcol=seagreen]
> The code is:
> --
> USE myDatabase
> go
> ALTER TABLE dbo.myTable DROP COLUMN abc1
> go
> --
> "Hugo Kornelis" wrote:
>
a[vbcol=seagreen]
message in[vbcol=seagreen]
Incorrect[vbcol=seagreen]
console,[vbcol=seagreen]
Line 1[vbcol=seagreen]
column,[vbcol=seagreen]
got[vbcol=seagreen]|||What do you mean that you tried to change the data type and size of the
column? Were you able to do that? Or did you get error messages for those
operations also.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:9F0BD776-CA70-42C4-92D6-0338228817EA@.microsoft.com...
> Hello,
> I'm trying to delete an existing varchar(10) column called "abc1" o in a
> table on a SQL 2000 database and I'm getting the following error message
in
> Enterprise Manager.:
> 'myTable' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:[/vb
col]
Incorrect[vbcol=seagreen]
> syntax near 'abc1'.
>
> I tried to delete it from SQL Analyzer directly from the server's console,
> but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
> Line 1: Incorrect syntax near 'abc1'."
> I tried to rename, change data type and size of the data type of the
column,
> but still could not delete it.
> Any thoughts?
> Thanks

Problems deleting a column

Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:
'myTable' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
syntax near 'abc1'.
I tried to delete it from SQL Analyzer directly from the server's console,
but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'abc1'."
I tried to rename, change data type and size of the data type of the column,
but still could not delete it.
Any thoughts?
Thanks
On Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:

>Hello,
>I'm trying to delete an existing varchar(10) column called "abc1" o in a
>table on a SQL 2000 database and I'm getting the following error message in
>Enterprise Manager.:
>'myTable' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
>syntax near 'abc1'.
>
>I tried to delete it from SQL Analyzer directly from the server's console,
>but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
>Line 1: Incorrect syntax near 'abc1'."
>I tried to rename, change data type and size of the data type of the column,
>but still could not delete it.
>Any thoughts?
>Thanks
Hi Vi,
You forgot to include the code you executed in query analyzer when you got
this error message.
Dropping the column abc1 from table myTable should be possible with the
following statement:
ALTER TABLE myTable
DROP COLUMN abc1
(untested)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||The code is:
USE myDatabase
go
ALTER TABLE dbo.myTable DROP COLUMN abc1
go
"Hugo Kornelis" wrote:

> On Tue, 10 Aug 2004 15:25:01 -0700, Vi wrote:
>
> Hi Vi,
> You forgot to include the code you executed in query analyzer when you got
> this error message.
> Dropping the column abc1 from table myTable should be possible with the
> following statement:
> ALTER TABLE myTable
> DROP COLUMN abc1
> (untested)
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>
|||Perhaps your database is set to a pre 70 compatibility level. You can check
this with:
EXEC sp_dbcmptlevel 'myDatabase'
And set it with:
EXEC sp_dbcmptlevel 'myDatabase', 80
Hope this helps.
Dan Guzman
SQL Server MVP
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:EA353C88-D7EC-46BB-A31A-F748F87B40FE@.microsoft.com...[vbcol=seagreen]
> The code is:
> --
> USE myDatabase
> go
> ALTER TABLE dbo.myTable DROP COLUMN abc1
> go
> --
> "Hugo Kornelis" wrote:
a[vbcol=seagreen]
message in[vbcol=seagreen]
Incorrect[vbcol=seagreen]
console,[vbcol=seagreen]
Line 1[vbcol=seagreen]
column,[vbcol=seagreen]
got[vbcol=seagreen]
|||What do you mean that you tried to change the data type and size of the
column? Were you able to do that? Or did you get error messages for those
operations also.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:9F0BD776-CA70-42C4-92D6-0338228817EA@.microsoft.com...
> Hello,
> I'm trying to delete an existing varchar(10) column called "abc1" o in a
> table on a SQL 2000 database and I'm getting the following error message
in
> Enterprise Manager.:
> 'myTable' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect
> syntax near 'abc1'.
>
> I tried to delete it from SQL Analyzer directly from the server's console,
> but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
> Line 1: Incorrect syntax near 'abc1'."
> I tried to rename, change data type and size of the data type of the
column,
> but still could not delete it.
> Any thoughts?
> Thanks

Problems Creating a Full-Text Catalog

When I attempt to create a full-text catalog on a database, I receive the following error:

Create failed for FullTextCatalog 'AccountNotes'. (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service. (Microsoft SQL Server, Error: 9955)

I have ensured that my SQL Server Service and the Full-Text service are running as the same account. I've had little luck finding an answer in the documentation.

Any help is greatly appreciated.

Thank you in advance.

MB
Just checking to see if anyone had any suggestions. I'm still stuck where I was before.

I'm running SQL Developer Edition 2005.

Thank you.

Problems continued - Cannot establish remote connection to Analysis Services

hello,

i am trying to connect to Analysis services server through another pc but i am unable to do so.

Using the following commands i manage to connect to analysis services server at my pc

Server.srv=new Server ();

srv.Connect('ip address or name');

but not to another pc. Are there any settings under sql server should i change ?

I assume that you are using Analysis Services 2005.

First, make sure that the Analysis Services allows remote connections:

On the machine running analysis services, please perform the following steps:

- All programs\Microsoft SQL Server 2005\Configuration Tools\Sql Server Surface Area Configuration

- Click on the Surface Area Configuration for Services and Connections

- Select Remote Connections under the MSSQLSERVER\Analysis Services node

- Make sure that Local and Remote connections is selected (to allow remote connections)

At this point, the client machine should be able to connect to the remote server. Before everything works, you will need to make sure that the client machine connection code is running under credentials that can access Analysis Services

|||

Well i have already enable remote connections and chech credentials as well

This is the error i am getting :

{"A connection cannot be made. Ensure that the server is running."} System.Exception {Microsoft.AnalysisServices.ConnectionException}

{"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"} System.Exception {System.Net.Sockets.SocketException}

Any help ? thanks.

|||That is unusual. Does PING work for the remote computer? Also, could you please check any firewall settings on the remote computer? Analysis Services (msmdsrv.exe) needs permissions through the firewall|||

PING works fine among the two ps's and analysis services is excepted under firewall .

I am still facing the same problem.

Can you please provide me the exact connection string from a pc1 with ip 10.181.11.1 to a pc2 with ip 10.181.11.2 (asp form in pc1 to analysis server in pc2)?

Maybe i use a wrong connection string

This is the error i am getting :

Unable to read data from the transport connection : an existing connection was forcibly closed by the remote host

Any help?

Thanks

|||

Are you using OLE DB or Adomd.Net?

The Connection String should look like "Data Source=10.181.11.2; Initial Catalog=<Your Database>"

One possible reason for the error is that your current user does not have permissions on the server. Are the computers in the same domain? If not, is Everyone allowed to access a database on the server?

|||

I am using ADOMD connection,,if you have an example connection string it would be helpful to check with the one i use

(i have tried different ways of setting the connection string but still cannot connect ).

As far as user credentials are concerned i have also tried to set them in different ways.

I am not quite sure which user (WinXP user, Database Engine User , IIS user, Analysis Services user) must have access to which place,, i am a bit confused about this.

I appreciate your help. Thank you

|||

To begin, let's make sure the physical connection works correctly. On the Analysis Services machine, create a new Analysis Services role which has permissions on your target database, and make sure that Everyone is a member of that role.

Then, try to connect from your client machine, using a connection string like

"Data Source=<IP of the remote machine>; Initial catalog=<name of the DB which is accessible to Everyone>"

If this works, the physical connection is OK and we'll focus on credentials.

Are your machines part of the same Windows NT domain? Tell me a few things about your application, I understand it is a web application, is it correct? Is it impersonating the remote user or running uner a set of specified credentials, or running under the default credentials (machine\ASPNET user)?

And, if you don't mind, could you please reply to this thread rather than creating a new post? It is easier to keep track of the issues

|||

We did what you suggested but we still get the same error.

Do we need to give the permissions and to the actual database (database engine) except to the one in analysis services ?

Our machines are part of the same workgroup connected via a router.

It is a web application and it is runnig under the default credentials.

But we tried with a windows application to check if we can connect to the analysis services and we still get the error

We can access a remote database engine througn sql server management studio but not remote analysis services server.

Is there a way to access a remote analysis services through sql server management studio?

Thanks

|||

This reply involves another error (not the one mentioned above). It seems to have a problem in creating the DIMENSION through source code and the problem seems to be on 'Process' command. We removed the Process command from the code and tried to process it through anaysis services management studio and still got error 'process failed' . This is a critical issue ,,i cannot continue to create cubes, etc.

As far as my application is concerned ,,it is a web application ,,the user will choose through an asp form measures and dimensions and then dimensions,cubes,structures will be created dynamically. So the problem is at initial state since i cannot create the dimenions.

Pls help.

This is the source code i use for dimension creation :

static void CreateDateDimension(Database db)

{

// Create the Date dimension

Dimension dim = db.Dimensions.Add("Invitquest");

dim.Type = DimensionType.Time;

dim.UnknownMember = UnknownMemberBehavior.Hidden;

dim.AttributeAllMemberName = "All Periods";

dim.Source = new DataSourceViewBinding(datasourceName);

dim.StorageMode = DimensionStorageMode.Molap;

#region Create attributes

DimensionAttribute attr;

attr = dim.Attributes.Add("Invitquest");

attr.Usage = AttributeUsage.Key;

attr.Type = AttributeType.Date;

attr.OrderBy = OrderBy.Key;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "invno"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "tableid");

attr = dim.Attributes.Add("YPopto");

attr.Type = AttributeType.Regular;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "Ypopto"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "Ypopto");

attr = dim.Attributes.Add("cancer");

attr.Type = AttributeType.Regular;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "CANCER"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "CANCER");

attr = dim.Attributes.Add("AM BIO");

attr.Type = AttributeType.Regular;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "AMBIO"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "AMBIO");

#endregion

dim.Update();

}

Thanks.

|||I merged all these threads.|||

> Our machines are part of the same workgroup connected via a router.

This seems to be the issue. Analysis Services uses exclusively Windows Integrated security. User accounts are not shared across machines in a workgroup, only in a domain (or related domains). This might explain both the management studio failure as well as the custom application failure.

Can you try allowing Everyone access to the Analysis Services database? Eventually , the permissions for the Everyone role can be restricted to what is needed (most likely, Read Definition and predictions), but you can start with Everyone as administrator -- not a great security suggestion, but it allows you to easily figure out if this is the source of the problem.

sql

Problems configuring Execution Log Reports

I receive the following error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'RSExecutionLog'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
My ReportServer DB is separate from my ReportServer IIS boxes, I'm trying to
use Windows NT Integrated Security to access the Execution Log. I'm a Local
Admin of both servers but still receive the error.
Am I dealing with a permissions hop issue? Any suggestions would help.
DavidYes. Use stored credentials in the shared data source for the reports
(another slightly more complex option would be to use Kerberos delegation)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"David Dubay" <DavidDubay@.discussions.microsoft.com> wrote in message
news:30C3BBF3-5DE7-4F4E-9008-349CA172D6EC@.microsoft.com...
>I receive the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'RSExecutionLog'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> My ReportServer DB is separate from my ReportServer IIS boxes, I'm trying
> to
> use Windows NT Integrated Security to access the Execution Log. I'm a
> Local
> Admin of both servers but still receive the error.
> Am I dealing with a permissions hop issue? Any suggestions would help.
> David

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>&lt;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"&gt;
&lt;Hierarchies&gt;
&lt;Hierarchy&gt;
&lt;BaseEntity&gt;
&lt;!--Donations--&gt;
&lt;EntityID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Entity_MeasureGroup_All_Petra_Donations&lt;/EntityID&gt;
&lt;/BaseEntity&gt;
&lt;Groupings&gt;
&lt;Grouping Name="Donation Payment Method"&gt;
&lt;Expression Name="Donation Payment Method"&gt;
&lt;Path&gt;
&lt;RolePathItem&gt;
&lt;!--Donation Payment Method--&gt;
&lt;RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Donation_Payment_Method_Entity_Dimension_All_Petra_Donation_Payment_Method&lt;/RoleID&gt;
&lt;/RolePathItem&gt;
&lt;/Path&gt;
&lt;EntityRef&gt;
&lt;!--Donation Payment Method--&gt;
&lt;EntityID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Entity_Dimension_Donation_Payment_Method&lt;/EntityID&gt;
&lt;/EntityRef&gt;
&lt;/Expression&gt;
&lt;Details&gt;
&lt;Expression Name="Donation Payment Method1"&gt;
&lt;AttributeRef&gt;
&lt;!--Donation Payment Method--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Hierarchy_Donation_Payment_Method.Donation_Payment_Method&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;/Details&gt;
&lt;/Grouping&gt;
&lt;Grouping Name="Core Cause Entity"&gt;
&lt;Expression Name="Core Cause Entity"&gt;
&lt;Path&gt;
&lt;RolePathItem&gt;
&lt;!--Partner Account--&gt;
&lt;RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Partner_Account_Entity_Dimension_All_Petra_Partner_Account&lt;/RoleID&gt;
&lt;/RolePathItem&gt;
&lt;/Path&gt;
&lt;AttributeRef&gt;
&lt;!--Core Cause Entity--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Hierarchy_Partner_Account.Core_Cause_Entity&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;/Grouping&gt;
&lt;Grouping Name="Distribution Name"&gt;
&lt;Expression Name="Distribution Name"&gt;
&lt;Path&gt;
&lt;RolePathItem&gt;
&lt;!--Fund Distribution--&gt;
&lt;RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Fund_Distribution_Entity_Dimension_All_Petra_Fund_Distribution&lt;/RoleID&gt;
&lt;/RolePathItem&gt;
&lt;/Path&gt;
&lt;AttributeRef&gt;
&lt;!--Distribution Name--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Hierarchy_Fund_Distribution.Distribution_Name&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;/Grouping&gt;
&lt;/Groupings&gt;
&lt;Filter&gt;
&lt;Expression Name="expr2"&gt;
&lt;Function&gt;
&lt;FunctionName&gt;GreaterThan&lt;/FunctionName&gt;
&lt;Arguments&gt;
&lt;Expression&gt;
&lt;Path&gt;
&lt;RolePathItem&gt;
&lt;!--Transaction Date--&gt;
&lt;RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Date_Entity_Dimension_All_Petra_Transaction_Date&lt;/RoleID&gt;
&lt;/RolePathItem&gt;
&lt;/Path&gt;
&lt;AttributeRef&gt;
&lt;!--MDY Date (Date)--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Time_Attribute_Hierarchy_Date.`_Date&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;Expression&gt;
&lt;ParameterRef&gt;
&lt;ParameterName&gt;Transaction Date MDY Date (Date)&lt;/ParameterName&gt;
&lt;/ParameterRef&gt;
&lt;/Expression&gt;
&lt;/Arguments&gt;
&lt;/Function&gt;
&lt;CustomProperties&gt;
&lt;CustomProperty Name="qd:FilterCondition" /&gt;
&lt;CustomProperty Name="qd:Filter" /&gt;
&lt;CustomProperty Name="qd:ContextEntityID"&gt;
&lt;Value xsi:type="xsd:string"&gt;http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations&lt;/Value&gt;
&lt;/CustomProperty&gt;
&lt;CustomProperty Name="qd:AutoChangeBaseEntity" /&gt;
&lt;CustomProperty Name="qd:Design"&gt;
&lt;Value xsi:type="xsd:string"&gt;expr3&lt;/Value&gt;
&lt;/CustomProperty&gt;
&lt;/CustomProperties&gt;
&lt;/Expression&gt;
&lt;/Filter&gt;
&lt;/Hierarchy&gt;
&lt;/Hierarchies&gt;
&lt;MeasureGroups&gt;
&lt;MeasureGroup&gt;
&lt;BaseEntity&gt;
&lt;!--Donations--&gt;
&lt;EntityID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Entity_MeasureGroup_All_Petra_Donations&lt;/EntityID&gt;
&lt;/BaseEntity&gt;
&lt;Measures&gt;
&lt;Expression Name="Transaction Amount"&gt;
&lt;AttributeRef&gt;
&lt;!--Transaction Amount--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Measure_All_Petra_Transaction_Amount&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;Expression Name="Transaction Count"&gt;
&lt;AttributeRef&gt;
&lt;!--Transaction Count--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Measure_All_Petra_Transaction_Count&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;/Measures&gt;
&lt;SubtotalSets&gt;
&lt;SubtotalSet&gt;
&lt;SubtotalMeasures&gt;
&lt;MeasureName&gt;Transaction Amount&lt;/MeasureName&gt;
&lt;MeasureName&gt;Transaction Count&lt;/MeasureName&gt;
&lt;/SubtotalMeasures&gt;
&lt;/SubtotalSet&gt;
&lt;SubtotalSet&gt;
&lt;SubtotalGroupings&gt;
&lt;GroupingName&gt;Donation Payment Method&lt;/GroupingName&gt;
&lt;/SubtotalGroupings&gt;
&lt;SubtotalMeasures&gt;
&lt;MeasureName&gt;Transaction Amount&lt;/MeasureName&gt;
&lt;MeasureName&gt;Transaction Count&lt;/MeasureName&gt;
&lt;/SubtotalMeasures&gt;
&lt;/SubtotalSet&gt;
&lt;SubtotalSet&gt;
&lt;SubtotalGroupings&gt;
&lt;GroupingName&gt;Donation Payment Method&lt;/GroupingName&gt;
&lt;GroupingName&gt;Core Cause Entity&lt;/GroupingName&gt;
&lt;/SubtotalGroupings&gt;
&lt;SubtotalMeasures&gt;
&lt;MeasureName&gt;Transaction Amount&lt;/MeasureName&gt;
&lt;MeasureName&gt;Transaction Count&lt;/MeasureName&gt;
&lt;/SubtotalMeasures&gt;
&lt;/SubtotalSet&gt;
&lt;/SubtotalSets&gt;
&lt;/MeasureGroup&gt;
&lt;/MeasureGroups&gt;
&lt;CalculatedAttributes&gt;
&lt;Expression Name="expr3"&gt;
&lt;Function&gt;
&lt;FunctionName&gt;And&lt;/FunctionName&gt;
&lt;Arguments&gt;
&lt;Expression&gt;
&lt;Function&gt;
&lt;FunctionName&gt;GreaterThan&lt;/FunctionName&gt;
&lt;Arguments&gt;
&lt;Expression&gt;
&lt;Path&gt;
&lt;RolePathItem&gt;
&lt;!--Transaction Date--&gt;
&lt;RoleID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Role_MeasureGroupDimension_Entity_MeasureGroup_All_Petra_Donations_Entity_Dimension_Date_Entity_Dimension_All_Petra_Transaction_Date&lt;/RoleID&gt;
&lt;/RolePathItem&gt;
&lt;/Path&gt;
&lt;AttributeRef&gt;
&lt;!--MDY Date (Date)--&gt;
&lt;AttributeID xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling"&gt;np:Attribute_Time_Attribute_Hierarchy_Date.MDY_Date&lt;/AttributeID&gt;
&lt;/AttributeRef&gt;
&lt;/Expression&gt;
&lt;Expression&gt;
&lt;ParameterRef&gt;
&lt;ParameterName&gt;Transaction Date MDY Date (Date)&lt;/ParameterName&gt;
&lt;/ParameterRef&gt;
&lt;/Expression&gt;
&lt;/Arguments&gt;
&lt;/Function&gt;
&lt;CustomProperties&gt;
&lt;CustomProperty Name="qd:FilterCondition" /&gt;
&lt;/CustomProperties&gt;
&lt;/Expression&gt;
&lt;Expression&gt;
&lt;Null /&gt;
&lt;CustomProperties&gt;
&lt;CustomProperty Name="qd:Unspecified" /&gt;
&lt;/CustomProperties&gt;
&lt;/Expression&gt;
&lt;/Arguments&gt;
&lt;/Function&gt;
&lt;CustomProperties&gt;
&lt;CustomProperty Name="qd:Filter" /&gt;
&lt;CustomProperty Name="qd:ContextEntityID"&gt;
&lt;Value xsi:type="xsd:string"&gt;http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Entity_MeasureGroup_All_Petra_Donations&lt;/Value&gt;
&lt;/CustomProperty&gt;
&lt;CustomProperty Name="qd:AutoChangeBaseEntity" /&gt;
&lt;/CustomProperties&gt;
&lt;/Expression&gt;
&lt;/CalculatedAttributes&gt;
&lt;Parameters&gt;
&lt;Parameter Name="Transaction Date MDY Date (Date)"&gt;
&lt;DataType&gt;DateTime&lt;/DataType&gt;
&lt;/Parameter&gt;
&lt;/Parameters&gt;
&lt;CustomProperties&gt;
&lt;CustomProperty Name="qd:PerspectiveID"&gt;
&lt;Value xsi:type="xsd:string"&gt;http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_Donations&lt;/Value&gt;
&lt;/CustomProperty&gt;
&lt;/CustomProperties&gt;
&lt;/SemanticQuery&gt;</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" &amp; Chr(58) &amp; " {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?

<UseVBANet>1</UseVBANet>