MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Crystal Server Report Instances
Posted on 2012-12-29
Hello experts -
I am looking for an easy way (famous last words, I know) to skip daily instances in Crystal Server 2008. We have over 1,600 daily recurring instances and two nights ago a tech had to stop the CMS because a Crystal report locked all the database tables. I have restarted the CMS, but now all the instances are running in chronological order, starting where it left off two nights ago.
UGH.
I would like to just stop all the pending instances for all recurring reports and have them start up fresh tonight but I don't see any way to do that easily. I have tried to search the instance manager for pending reports but they are not listed as pending until they are queued up to run. If I delete all the recurring instances then I will need to re-create all 1,600 recurring instances all over again.
Am I missing something?
Help!!
Lisa
I am looking for an easy way (famous last words, I know) to skip daily instances in Crystal Server 2008. We have over 1,600 daily recurring instances and two nights ago a tech had to stop the CMS because a Crystal report locked all the database tables. I have restarted the CMS, but now all the instances are running in chronological order, starting where it left off two nights ago.
UGH.
I would like to just stop all the pending instances for all recurring reports and have them start up fresh tonight but I don't see any way to do that easily. I have tried to search the instance manager for pending reports but they are not listed as pending until they are queued up to run. If I delete all the recurring instances then I will need to re-create all 1,600 recurring instances all over again.
Am I missing something?
Help!!
Lisa
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
I don't think you are missing anything.
I am not aware of a way to do what you want.
mlmcc
I am not aware of a way to do what you want.
mlmcc
Unfortunately there isn't an "easy way" to do this, unless you have a 3rd party scheduling tool. There are some that connect into the repository and allow you to search for instances of a certain status, where you could then delete in bulk. However, if your company is anything like the ones I have worked for ;-) you won't be able to acquire one quickly and it might be faster to simply go into the reports one by one and kill off the pending instances.
One other idea I have - change the ODBC connection on the server to be some other database. Allow the reports to run and they should fail almost immediately since the database connection would not contain the tables/views you are looking for. This will give you time to fix the reports and they will continue to fail immediately until you resolve it.
By the way, the only way I know of to prevent table locks is to change the reports to point to stored procedures or views and indicate WITH NO LOCK in the SQL on every table. Check for the correct syntax for implementing NOLOCK, depending on what kind of database you are using.
One other idea I have - change the ODBC connection on the server to be some other database. Allow the reports to run and they should fail almost immediately since the database connection would not contain the tables/views you are looking for. This will give you time to fix the reports and they will continue to fail immediately until you resolve it.
By the way, the only way I know of to prevent table locks is to change the reports to point to stored procedures or views and indicate WITH NO LOCK in the SQL on every table. Check for the correct syntax for implementing NOLOCK, depending on what kind of database you are using.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Crystal Reports: 5 Tests for Top Performance
It is complete, your masterpiece report. Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.
…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 8 hours left to enroll
627 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.