Prev: Anyone else notice this problem?
Next: FIND equivalent in an SRS Expression
From: Venkat on 7 Apr 2010 10:20
Hi, on further analysis, we identified that:
Call to reportingservice2005.asmx is not comming back. the last request we
have seen in IIS log file is: /Reports/reportingservice2005.asmx (At the same
time we noticed DCOM errors in event log)
And then no response even after 10 minutes time.
Then we have to reset the IIS to make it work

Just a small correction on the issue titile. while request to report is
hangging, we are able to continue and browse the other applicaiton aspx pages.

Any one faced these kind of issues?

"Venkat" wrote:

> Hello,
> we have a strange issue at customer site.
> We are using SQL 2005 Service pack 2 reporting services, OS is: Windows 2003
> server
> Some times IIS/web requests hangs when accessing reports. once this is
> hanged, i can't event browse: http://localhost/Reports. Nothing can be done.
> I need to restart to start accessing/running reports.
>
> Whenever this happens, i can see one DCOM error in event viewer:
> NT AUTHORITY\NETWORK SERVICE account does not have permission on NETMAN
>
> I am not sure how Network Service account and Netman and Reports are related
> together.
> can any one help me in finding why and in what scenarios the reports hangs
> (when accessed through web)
> and what is the relation between NT AUTHORITY\NETWORK SERVICE and NETMAN and
> Reports?
>
> Thanks,
> Venkat
From: Venkat on 13 Apr 2010 03:33
finally the issue is figured out. Web server does not have permissions on log
files so it is hanging intermitently

"Venkat" wrote:

> Hi, on further analysis, we identified that:
> Call to reportingservice2005.asmx is not comming back. the last request we
> have seen in IIS log file is: /Reports/reportingservice2005.asmx (At the same
> time we noticed DCOM errors in event log)
> And then no response even after 10 minutes time.
> Then we have to reset the IIS to make it work
>
> Just a small correction on the issue titile. while request to report is
> hangging, we are able to continue and browse the other applicaiton aspx pages.
>
> Any one faced these kind of issues?
>
> "Venkat" wrote:
>
> > Hello,
> > we have a strange issue at customer site.
> > We are using SQL 2005 Service pack 2 reporting services, OS is: Windows 2003
> > server
> > Some times IIS/web requests hangs when accessing reports. once this is
> > hanged, i can't event browse: http://localhost/Reports. Nothing can be done.
> > I need to restart to start accessing/running reports.
> >
> > Whenever this happens, i can see one DCOM error in event viewer:
> > NT AUTHORITY\NETWORK SERVICE account does not have permission on NETMAN
> >
> > I am not sure how Network Service account and Netman and Reports are related
> > together.
> > can any one help me in finding why and in what scenarios the reports hangs
> > (when accessed through web)
> > and what is the relation between NT AUTHORITY\NETWORK SERVICE and NETMAN and
> > Reports?
> >
> > Thanks,
> > Venkat
 | 
Pages: 1
Prev: Anyone else notice this problem?
Next: FIND equivalent in an SRS Expression