Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pending Jobs in CE 8.5
- Thread starter jaburke
- Start date
- Thread starter
- #3
We currently have one report and job server per processor. Dual processors. The maximum jobs allowed is set to 10 per server. We have gotten conflicting information regarding whether or not to have two report/job servers per processor.
We are using a custom web app, instead of eportfolio, so I don't get anything on the pending status.
Thanks!!!
We are using a custom web app, instead of eportfolio, so I don't get anything on the pending status.
Thanks!!!
The maximum recommended number of jobs per job server is 5. You need to scale down your jobs.
Regarding multi-processor servers: Per Crystal's sizing guide, having multiple job servers installed on a windows server (one/processor) is shown to be less efficient than if you had single job servers installed on multiple machines. The opposite is true for Unix servers - multiple job servers are more efficient on a multi-processor server.
That being said, I've had multiple job servers on a number of multi-processor machines and haven't had any difficulties, whatsoever.
Please post more technical information regarding your reports, schedules and servers.
~Kurt
Regarding multi-processor servers: Per Crystal's sizing guide, having multiple job servers installed on a windows server (one/processor) is shown to be less efficient than if you had single job servers installed on multiple machines. The opposite is true for Unix servers - multiple job servers are more efficient on a multi-processor server.
That being said, I've had multiple job servers on a number of multi-processor machines and haven't had any difficulties, whatsoever.
Please post more technical information regarding your reports, schedules and servers.
~Kurt
First of all, are they in a Waiting status or a Pending status? Pending would be recurring reports that are cumulative in nature. We currently have over 13,000 Pending. These are set to go off sometime in the future. If you have only a few users, it would be easy enough to go into the "Manage Objects", drilll into a report and look for recurring reports. Or ask the users.
There is a known issue should the maximum number of threads per Job Server be reached. If this happens, the Job Server refuses any further requests until it has been cleared, but upon completing the load, it never sends a response back to the APS asking for more work. A patch has been included in Service Pack 2, and a separate patch fro CE for the issue is ADAPT00229186.
The way to tell if this is occuring is that you have say 10 Job Server threads available on your system, a baclog of reports but only see a few threads (JobserverChilds) running.
We also have multiple servers and Job Servers running. 2 Quad boxes with 4 Job Servers on each. Running 5 threads per, but have experimented with more.
Another issue to look for is a poorly formed query. We found some that were taking all the threads, running for several hours, and causing a backlog of waiting reports.
There is a known issue should the maximum number of threads per Job Server be reached. If this happens, the Job Server refuses any further requests until it has been cleared, but upon completing the load, it never sends a response back to the APS asking for more work. A patch has been included in Service Pack 2, and a separate patch fro CE for the issue is ADAPT00229186.
The way to tell if this is occuring is that you have say 10 Job Server threads available on your system, a baclog of reports but only see a few threads (JobserverChilds) running.
We also have multiple servers and Job Servers running. 2 Quad boxes with 4 Job Servers on each. Running 5 threads per, but have experimented with more.
Another issue to look for is a poorly formed query. We found some that were taking all the threads, running for several hours, and causing a backlog of waiting reports.
- Status
Similar threads
- Locked
- Question
- Locked
- Question