IIS Reset rqeuires always to generate report

At one of our client site we are facing an issue everytime while generating the Crystal report we require to reset the IIS. Once the IIS is reset report generation start functioning properly.
What is the solution to stop resetting IIS. MS Reporting service is used to generate the report through application.
desaiviveksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Meir RivkinFull stack Software EngineerCommented:
which machine runs the client site?
what's IIS version u use?
0
desaiviveksAuthor Commented:
windows 2000 server & IIS version 6.0
0
desaiviveksAuthor Commented:
hi can anyone help me with this issue.
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

desaiviveksAuthor Commented:
Anyone who can help with this issue. As I am waiting for someone to comment
0
Bob LearnedCommented:
There are too many possibilities to even comment, without more detail.  It would be like trying to find a needle in a haystack.
0
mlmccCommented:
In the question you say you are using Crystal Reports then say it is MS Reporting.  Which is it?

mlmcc
0
Bob LearnedCommented:
That is a great question, Mike!!
0
desaiviveksAuthor Commented:
Hi this is a MS Reporting Service.
0
Bob LearnedCommented:
What version of SQL Server are you working with?  What is the operating system?  What is the IIS version?  How was reporting services installed and configured?  What is the .NET framework version that you are working with?  Is this a problem with a single application, or every one running on that machine?
0
desaiviveksAuthor Commented:
Please find the answer to the question:
What version of SQL Server are you working with?  SQL 2000
What is the operating system? Windows 2000 server
What is the IIS version? IIS version 6.0
How was reporting services installed and configured? Reporting service is installed and configure on database server where MSSQL server is installed. In regard with configuration can you please explain more in details.
What is the .NET framework version that you are working with? .net frame work 1.1
Is this a problem with a single application, or every one running on that machine? this issue is with everyone on on one single user. In our application there is a facility generate a reports. So when end user tries to generate a report sometimes it works fine. But if the report is not generated on regular interval it requires IIS reset. Once the IIS reset we can successfully generate the reports.
Our's is a web base application where we are using web server as Tomcat and for reports it's configure through IIS
On further investigation, I checked the web logs it records a error stating connection was not established. So I assume that IIS goes into sleeping mode and may be if there is some particular settings in IIS where I can keep the connection alive this issue would get resolve.
Could you please help in regard with the same.



0
Bob LearnedCommented:
I work for a conservative insurance company, so I understand old technology.  It does make it difficult for me, though, since I don't think in terms of SQL Server 2000, and Windows 2000 Advanced Server, etc.  

Are there any service packs installed?

Can you show me the error from the web log?  

I wouldn't think that the "keep-alive" setting would be what you want.  The web site should be able to make a connection, generate the report, and close the connection, without having to keep a connection open.
0
desaiviveksAuthor Commented:
Error web log:

ERROR Feb 17 14:36:24 impl.SubscriptionsManagerImpl - Failed to execute snapshot for userNo 4223 and subscriptionId 35
AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
 faultSubcode:
 faultString: Server was unable to process request. --> The Snapshot subscription could not be generated at this time. --> An error has occurred during report processing.

_____________________

at java.lang.Thread.run(Unknown Source)

      {http://xml.apache.org/axis/}hostname:dc2k3risweb1

Server was unable to process request. --> The Snapshot subscription could not be generated at this time. --> An error has occurred during report processing. --> System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing.

Are there any service packs installed?
What service Packs are you looking for. Is the default hot fix or patches from Microsoft.
0
desaiviveksAuthor Commented:
Any help??????
0
Bob LearnedCommented:
I submitted a nice long comment, and E-E went down, and since I wasn't having a good day yesterday, and I didn't come back to this.  

Let's try smaller:  Why does it appear that you are mixing Apache and IIS on the same box?
0
desaiviveksAuthor Commented:
I am not mixing IIS and Apache. Apache is used in front end to host our web application. and IIS is used to run reporting service to generate the reports.
0
Bob LearnedCommented:
"The Snapshot subscription could not be generated at this time"  
Is this referring to a replication problem on SQL Server?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.