Report Builder: Error 401

I'm looking for some help/suggestions on how to solve an authentication problem we're having running the ad-hoc reporting tool (Report Builder). Here's the background:

1. It actually installs a client footprint the first time it is launched, and requires .NET 2.0 framework on the client. Authentication to the Report Server is through Windows NT authentication, then additional Reporting Service security controls what rights the accounts have (including the right to use Report Builder).

2. Currently, Windows NT authentication works for providing access to the Report Server, running reports published to the server, and doing other admin functions related to Reporting Services.

3. We are having a problem with accounts not being able to run Report Builder even though they have the correct rights, and it appears to be related to the specific PC being used. Serveral of us have accounts that used to work on our PCs, but no longer work. But the same account will work when used on another PC (which was actually in the same DNR subnet). I've also had someone use my account on their machine, and it worked. We've had others that have never been able to run Report Builder, even though they have the rights to do so. Bellow are error details returned to the client when trying to run the application.

4. Since the problem seems to be machine related and one of the client requirements is the .NET 2.0 framework, I tried un-installing and re-installing this, but it didn't correct the problem.

5. This problem occurs both on both the development server and the new server we will be using for production.

Not sure what to do next...any ideas? Would a network trace help? Or is there any additional info on the Report Server log that would help? Microsoft support?

Let me know what you think, or if you think there are others that might be able to help.

ERROR DETAILS:

PLATFORM VERSION INFO

Windows : 5.1.2600.131072 (Win32NT)

Common Language Runtime : 2.0.50727.42

System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)

mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)

dfdll.dll : 2.0.50727.42 (RTM.050727-4200)

dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES

Deployment url : http://216.159.162.212/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY

Below is a summary of the errors, details of these errors are listed later in the log.

* Activation of http://216.159.162.212/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:

+ Downloading http://216.159.162.212/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.

+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY

No transaction error was detected.

WARNINGS

There were no warnings during this operation.

OPERATION PROGRESS STATUS

* [8/3/2006 10:01:12 AM] : Activation of http://216.159.162.212/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS

Following errors were detected during this operation.

* [8/3/2006 10:01:12 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)

- Downloading http://216.159.162.212/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.

- Source: System.Deployment

- Stack trace:

at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()

at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)

at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)

at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)

at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)

at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)

at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)

-- Inner Exception --

System.Net.WebException

- The remote server returned an error: (401) Unauthorized.

- Source: System

- Stack trace:

at System.Net.HttpWebRequest.GetResponse()

at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS

No transaction information is available.

Did you ever figure this out? we are getting the same errors.

Report Builder: Custom Aggregate

Hi All,
I have used Report Builder to enable user to do Ad-Hoc Report that has
been great so far, but I have unique requirement for below table/view:
Month Headcount
================== January-06 45
February-06 41
March-06 43
April-06 42
May-06 38
June-06 30
July-06 50
(etc...)
Dec-06 42
Above table represents how many employees, one company/department has
during Month column. In January-06, there is 45 employees,
February-06, there is 44 employees, and so on.
If user choose to show Headcount attribute, Report Builder should
display each month headcount. The current problem is on the aggregate.
for example, report should show Headcount for Quarter 1 as 43, which
is headcount for March-06 (how many employees I have at the end of
Quarter 1), Quarter 2 should display 30, which is headcount for
June-06, and for Year of 2006 should be 42 (at Dec-06). There will be
more complexity: if now is still in the month of November 06 and no
data for December yet, report should show headcount of November 06 as
headcount for Year of 2006.
I don't think default available aggregates which are: Total, Average,
Max, Min, able to do this.
Q1, correct value should be 40 (March-06)
If I use Total Aggregate, it will be 99.
If I use Average, it will be 24.75
If I use Max, it will be 45.
If I use Min, it will be 41.
I need an aggregate that show number from last record in the dataset.
Is there any possible way how to do this? Any input is appreciated.
Thank you.On Jun 19, 4:59 pm, Gunady <Gun...@.gmail.com> wrote:
> Hi All,
> I have used Report Builder to enable user to do Ad-Hoc Report that has
> been great so far, but I have unique requirement for below table/view:
> Month Headcount
> ==================> January-06 45
> February-06 41
> March-06 43
> April-06 42
> May-06 38
> June-06 30
> July-06 50
> (etc...)
> Dec-06 42
> Above table represents how many employees, one company/department has
> during Month column. In January-06, there is 45 employees,
> February-06, there is 44 employees, and so on.
> If user choose to show Headcount attribute, Report Builder should
> display each month headcount. The current problem is on the aggregate.
> for example, report should show Headcount for Quarter 1 as 43, which
> is headcount for March-06 (how many employees I have at the end of
> Quarter 1), Quarter 2 should display 30, which is headcount for
> June-06, and for Year of 2006 should be 42 (at Dec-06). There will be
> more complexity: if now is still in the month of November 06 and no
> data for December yet, report should show headcount of November 06 as
> headcount for Year of 2006.
> I don't think default available aggregates which are: Total, Average,
> Max, Min, able to do this.
> Q1, correct value should be 40 (March-06)
> If I use Total Aggregate, it will be 99.
> If I use Average, it will be 24.75
> If I use Max, it will be 45.
> If I use Min, it will be 41.
> I need an aggregate that show number from last record in the dataset.
> Is there any possible way how to do this? Any input is appreciated.
> Thank you.
Reporting Services actually supports "Last" Aggregate (using regular
RDL file, e.g. developed using Visual Studio), which I think can solve
the problem. I notice that we can use
Count,CountDistinct,StDev,StDevP,Var, or VarP, in the Report Builder
editor itself, but there is no First or Last available. Does anyone
knows how to use this "Last" aggregate in report builder?

Report Builder error.

Hi,

I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this ?

---

Report execution error
The report might not be valid or the server could not process the data.

An existing connection was forcibly closed by the remote host.
-
Unable to read data from the transport connection:An existing connection was forcibly closed by the remote host.
-
The underlying connection was closed: An unexpected error occured on a receive.

---

In the same report if I try to add another runtime filter, the application crashes. This filter field has about 50k available values.Is that the reason for such behaviour? What can be the possible solution here ?

Is this error displayed during execution (preview) of the report or during design-time?

If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element.

If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server?

HTH, Jason Tremper

|||

Hi !

Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns.
The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k!
I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the text box.

Report Builder error.

Hi,

I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this ?

---

Report execution error
The report might not be valid or the server could not process the data.

An existing connection was forcibly closed by the remote host.
-
Unable to read data from the transport connection:An existing connection was forcibly closed by the remote host.
-
The underlying connection was closed: An unexpected error occured on a receive.

---

In the same report if I try to add another runtime filter, the application crashes. This filter field has about 50k available values.Is that the reason for such behaviour? What can be the possible solution here ?

Is this error displayed during execution (preview) of the report or during design-time?

If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element.

If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server?

HTH, Jason Tremper

|||

Hi !

Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns.
The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k!
I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the text box.