[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Reports 9 + reports locking up on Web Server

Posted on 2007-10-11
9
Medium Priority
?
238 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.
0
Comment
Question by:Robb Hill
  • 5
  • 4
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 20056799
Are you running from your machine?

mlmcc
0
 
LVL 11

Author Comment

by:Robb Hill
ID: 20056827
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
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 20057794
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
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 11

Author Comment

by:Robb Hill
ID: 20057860
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...
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 20058031
The merge modules are the files Crystal needs on a client machine to run.

Is it intermittent on the same machine?

mlmcc
0
 
LVL 11

Author Comment

by:Robb Hill
ID: 20058070
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
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 20058151
I don't know.  Hopefully another expert will come along and add some suggestions.

mlmcc
0
 
LVL 11

Author Comment

by:Robb Hill
ID: 20058201
ok...well thanks for your help
0
 
LVL 11

Author Comment

by:Robb Hill
ID: 20196840
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question