11/25/2024 10:39:14 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Server Locks when Crystal Reports for SLX runs
Posted: 31 May 07 1:22 PM
|
Hi Everyone,
I continue to encounter a problem periodically when I run Crystal Reports via a script inside of SLX. Many of the Crystal Reports we run are launched via script. In most instances we pass an AccountID or an OpportunityID to Crystal Reports as a parameter so the report only runs for the "current" record.
The problem I seem to encounter frequently is that the workstation will lock the SQL server with a Page I/O lock when the report is running. This blocks everyone else from queries in SalesLogix. Now that we are at 200 SLX users, the problem is encountered daily! I've seen a symptom in particular with batch jobs. I open the RDC, and loop through and print the report 50 to 100 times. The first 25 or so will print in rapid succession, but after that the report will take over a minute to run for one record - thus locking the whole of SQL server for that minute. 
I have a gumption that the SLX provider opens the database in read/write mode when the report requests the data, rather than a read-only mode, thus causing the SQL lock.
Anyone had a similar situation? What did you do to alieviate the problem? |
|
|
|
Re: Server Locks when Crystal Reports for SLX runs
Posted: 07 Dec 07 2:11 PM
|
| This post is old but I'm having a similar problem so figured I'd give it a bump. Has anyone else encountered this? I've built a couple reports that are doing text lookups against the history table, so they run quite slowly. The problem is that they are locking the history table until they complete. Sometimes in design mode this would freeze the entire environment until the lock was cleared. Now we're having the same problem when just running reports from SLX. Any ideas on what can be done to make CR stop locking the table? We're running SLX 7.2 against SQL Server 2000 SP4. |
|
|
|
Re: Server Locks when Crystal Reports for SLX runs
Posted: 24 Apr 08 3:04 PM
|
I'm also seeing this when running Crystal Reports from SLX. Even when the Crystal Report is just displayed in the viewer, as soon as someone else tries to access the same table, the Crystal Report Select statement goes into the NetworkIO wait status (looking in SQL Enterprise Manager) and everything else behind it locks. Once the Crystal Select NetworkIO process id is killed, all locked transaction process normally. We're running SLX 7.0.1 against SQL Server 2000 SP4. Has anyone else seen this problem or have any ideas what might solve it? I've tried everything I can think of. Thanks in advance! |
|
|
|
Re: Server Locks when Crystal Reports for SLX runs
Posted: 25 Apr 08 2:19 PM
|
I had this problem sometimeback and i had to get into the report to change something obvious that was *not* even required. But here i dont see that...i am seeing something else..Why do you need to call a report 50 times? Why cant you create and add these 50 vals to a parameter and then call the report just once .you know you can change the rpt layout to look like separate reports for batch processing with page pbreaks and resetting pagenumbers at intervals.
Or if you want 50 separate reports, then why dont you send us the code which calls that report. Maybe something is not handled/destroyed properly before allocating another instance to that...If some components is not meant to be used in these situations, dont use it..
CR 8.5 rds components are buggy and are not meant to be used in a loop or something(You are simply using the crviewer.dll to run reports in slx right?) .
You said ....[The first 25 or so will print in rapid succession, but after that the report will take over a minute to run for one record -]
Is this consistent?can you reproduce this behaviour? Can you check the mem usage at this point?
This indicates that there are some mem leaks in that component which your using. Did someone tell you that these components can be used this way.
Also if it was me , i would be running the batch reports during off hours. |
|
|
|
Re: Server Locks when Crystal Reports for SLX runs
Posted: 17 Nov 08 5:55 PM
|
Found what worked for us... After you export the report (objRDC.Export False), you need to perform objRDC.discardSavedData. That solves it!
P.S. The reason it's 50+ seperate reports is I'm printing a form letter for customers in a loop. The letter is too complex and involves too many table to be a simple Word document. And yes, this is done off hours.
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|