asked on

Crystal Reports 9 + reports locking up on Web Server

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.

Mike McCracken

Are you running from your machine?

mlmcc

Robb Hill

ASKER

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 McCracken

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 Hill

ASKER

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 McCracken

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

Is it intermittent on the same machine?

mlmcc

Robb Hill

ASKER

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

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Robb Hill

ASKER

ok...well thanks for your help

Robb Hill

ASKER

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