We help IT Professionals succeed at work.

Crystal Reports 9 + reports locking up on Web Server

255 Views
Last Modified: 2012-06-27
I have created a report using crystal reports 9.0.  The report runs fine locally.  ITs pulling data from SQL 2000.  When I run the report from the web over the web server....the report will not run...sometimes it will run..but it seems to be intermittent.  When I log into the web server...I do not see any errors in the event log.  Does anyone have some suggestions on how to debug this.
Thanks.
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you running from your machine?

mlmcc
Robb HillSenior .Net Full Stack Developer
CERTIFIED EXPERT

Author

Commented:
When I run from my machine its fine...
only when I access via the webserver over a url...
IM assuming the process for rendering is different....one uses client the other uses server
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
It uns fine on your machine when run from the server?

How did you install it to the web server?

Sounds like you could have permission issues or you need to include the merge modules so the user can download them.

mlmcc
Robb HillSenior .Net Full Stack Developer
CERTIFIED EXPERT

Author

Commented:
The strange thing ..is it seems intermittent...sometimes it works fine....and then sometimes it doesnt run at all.......what would cause an intermittent issue...there doesnt seem to be any performance hit on the server...atleast not obvious.  The account is run by user:  report_user when I run it from my machine...and I notice that its run under user:  sa when its hit from the web.

Well not sure about merge modules..whats that...
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
The merge modules are the files Crystal needs on a client machine to run.

Is it intermittent on the same machine?

mlmcc
Robb HillSenior .Net Full Stack Developer
CERTIFIED EXPERT

Author

Commented:
no...it works fine when running from within crystal....but intermittenly will not run at all from any machine via the web.  It more likely throughout the day will not run...and then without making anychanges runs perfectly
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Robb HillSenior .Net Full Stack Developer
CERTIFIED EXPERT

Author

Commented:
ok...well thanks for your help
Robb HillSenior .Net Full Stack Developer
CERTIFIED EXPERT

Author

Commented:
The answer was not in crystal.  Actually the problem lied in the fact that my stored procedures behind the scenes for recompiling.  Thanks for trying to help

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.