.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SSRS asking for credentials while reports running for long time.

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

We have a report which executes a stored procedure and it runs for 10 minutes.  After running for 5 minutes, the report keeps asking for username and password for 3 times and redirects to unauthorized page.  The website uses WIDE IP for crash and recovery handling, so it has two nodes.  Could some one please help me to figure out what problem it is ?  The SP data is not huge, which produces only 300 odd rows and 20+ columns.

 

Any help will be appreciated.  Thanks.





View Complete Post


More Related Resource Links

I'm getting exception while running Report builder 2.0 for SSRS Reports

  
Hi,
I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.

sunmoon_1411

By any chance can we able to optimize the below query.. It is running for long time..

  

By any chance, can we optimize the below query..This is running for 2 hrs..As of now, i really don't have any execution plans. 

If i replace "IN" with "Exists", i am saving few minutes. Can someone please optimize the query little more?
SELECT pm.pm_no,
pm.pm_key, 
trunc(pm.last_completion_dt), 
pm.location_name,
loc.unid,
loc.location_desc,
loc.tva_eq_owner_key
FROM 
eam_od_pm_tb pm, 
eam_od_location_tb loc
where 
pm.site_id in ('ALF','BRF', 'COF','CUF','GAF','JOF','JSF','KIF','SHF','WCF', 

SSRS taking a long time to run an MDX query

  

Hi,

I have an MDX query which runs fine in the MDX Sample Application. It runs against an SSAS 2000 cube. In my query there is a recursion kind of a logic. It takes about 1-2 sec to run in the MDX Sample Application. My sample application is in the same server as my AS 2000 cube is. However when I run the same MDX from another server through BIDS (2008) it takes an unusually long amount of time to run. Most of the time it times out. :(

As a workaround I created 4 calculated members in my Cube itself (Initially these were used as members in my MDX). I thought that maybe the recursion logic is the culprit so I modified my MDX, removed the recursion part. But still from my SSRS it is taking a long time.

Any pointers to where I am missing the trick ?

Thanks in advance,

Suman


WPF 4 with SSRS Report Viewer and long running Background Worker Dispatch task.

  

Hello,

I've recently run into an issue with with WPF 4 and the SSRS viewer control with a batch emailing application. See http://www.jenasysdesign.com.au/dnn/Blogs/tabid/71/EntryId/5/WPF-4-SQL-Server-Reporting-Services-processing-application-Memory-Leak.aspx for details of some performance profiling issues I found with this technology stack.

I've got two issues.

Firstly, I implemented a background worker process to handling looping through the 2,800 reports. I found to run the SSRS report viewer to export the report results in a slow memory leak. See Red-gate Ants memory profiler 6 image in the link above. I'm not sure what I need to do to remove weak references with this combination of technology. Any ideas?

Secondly, the following code runs on the background worker process, designed so the user can monitor the progress of the a large batch of report files getting generated.  The catch here is involves using the SSRS viewer to export a reports results requires the Dispatcher.Invoke method to ensure that ReportViewer.xaml screen gets a UI thread, but in the process it interferes with the background workers report progress methods, so the UI doesn't see the progress.  

WPF 4 with SSRS Report Viewer and long running Background Worker Dispatch task.

  

Hello,

I've recently run into an issue with with WPF 4 and the SSRS viewer control with a batch emailing application. See http://www.jenasysdesign.com.au/dnn/Blogs/tabid/71/EntryId/5/WPF-4-SQL-Server-Reporting-Services-processing-application-Memory-Leak.aspx for details of some performance profiling issues I found with this technology stack.

I've got two issues.

Firstly, I implemented a background worker process to handling looping through the 2,800 reports. I found to run the SSRS report viewer to export the report results in a slow memory leak. See Red-gate Ants memory profiler 6 image in the link above. I'm not sure what I need to do to remove weak references with this combination of technology. Any ideas?

Secondly, the following code runs on the background worker process, designed so the user can monitor the progress of the a large batch of report files getting generated.  The catch here is involves using the SSRS viewer to export a reports results requires the Dispatcher.Invoke method to ensure that ReportViewer.xaml screen gets a UI thread, but in the process it interferes with the background workers report progress methods, so the UI doesn't see the progress.  

Prompted for network credentials via internet while accessing SSRS reports in SharePoint integrated

  
Hi

We have developed a SharePoint- FBA site and published it through ISA.  The site, among many features, displays SSRS reports through Performance Point Monitoring dashboards.  SSRS is using windows integrated authentication (Kerberos).  Through intranet, the reports are getting displayed without any issue, but, through internet, its getting prompted when we try to access the reports for the first time after logging into the site using FBA credentials.  When we enter valid domain credentials after being prompted, it starts displaying reports without any issues and never prompts again for that FBA session.

We have been trying to eliminate the prompt through internet, but couldn't do so. 

Has anyone experienced the same before?

Any help is appreciated.


Running Reports from a SSRS Scale-Out instance

  

Hi to all,

First of all, thanks for the good information that usually all of us can find here to solve our problems with SQL.

Now I'm going to try to explain my problem. Following some of the Q&A published here, I have installed a SSRS Scale-Out environment with 2 SSRS Web instances and an external SSRS DB repository. After that, I have published some rdl files without any kind of problems.

The problem that I found is the following, if in one of my SSRS Web instances I call to the report using localhost (http://localhost:9000/Reports/Pages/Report.aspx?ItemPath=%2fMy+Reports%2fEQUIPOS_HW+-+RMA), the report works perfectly and I can see the data obtained from an OLAP cube in SSAS, but if I call to the report using any other way to call to the system (example: IP, hostname, etc. --> http://127.0.0.1:9000/Reports/Pages/Report.aspx?ItemPath=%2fMy+Reports%2fEQUIPOS_HW+-+RMA), I receive this kind of error:

  • Error al procesar el informe. (rsProcessingAborted)
    • SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.

        

      Hi,

      I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

      • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

      I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

      I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

      Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):

      http://<Servername>/ReportServer_SQLSERVER97170

      Am able to view the report from report viewer webpart but unable to schedule it.

      Kindly let me know what's going wrong.

      Thanks in Advance,

      Sachin R. Chavan.


      Sachin R. Chavan.

ASP.NET Workflow: Web Apps That Support Long-Running Operations

  

Integrating workflow into ASP.NET applications means communicating with activities via a workflow queue and hosting the runtime in the global application class. We'll show you how.

Michael Kennedy

MSDN Magazine January 2009


how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help

  

Hi,

I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help

 

Thanks in advance!


Share Point integrated SSRS reports rendering when access from external site

  

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

 
An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft

  

HI,

Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.

Thanks.

John.

 


Video: Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services

  
Watch this visual how-to video as you learn to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0. (Length: 7:56)

Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services 3.0 (V

  
Watch the video and explore code as you learn how to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0.

How to keep my Workflow alive only during the time my client application is running ?

  
Hi, I want to my workflow do some action when server  lose connection with client and at the same time client get exceptions about it. It is possible to implement some session mechanism or something like that with workflow service ? Regards Marcin

WCF Service: takes very long time to start up

  
Hi, What could be the reasons, why my WCF service takes up to 40 seconds to get started? My service class is set to [ServiceBehavior(InstanceContextMode = InstanceContextMode.Single)] I am running a thread inside this class. The WCF service gets initialized and opened within the context of this thread. The Initialization: private void InitializeWCFService() {      // initialize servcie base addrresses      this.SetupBaseAddresses();      //MetaData behaviour : allow HttpGet      ServiceMetadataBehavior metaDataBehavior = new ServiceMetadataBehavior();      metaDataBehavior.HttpGetEnabled = true;      // initialize service host instance      this.seviceHost = new ServiceHost(this, this.httpBaseAddress, this.tcpBaseAddress);      // add service endpoints and behavior.      this.seviceHost.AddServiceEndpoint(typeof(IUpdateServer), this.GetServerBinding(BindingType.Tcp), EndpointName);      this.seviceHost.AddServiceEndpoint(typeof(IUpdateServer), this.GetServerBinding(BindingType.Http), EndpointName);      this.seviceHost.Description.Behaviors.Add(metaDataBehavior);      // MEX endpoint      this.seviceHost.AddServic

Workflow Runtime and Long Running Processes

  
I am trying to get a handle on the fact that applications have to manage the persistance of workflows directly. in 4.0.  If I set a workflow to run every night at 3:00 AM and then be persisted, how will I know that my application will be awake and ready to do the job.  I know that SharePoint currently uses a timer on the server which fires off every 5 minutes (default). 
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend