The CCCAPPLY report server is exceptionally slow today. Any reason?
The CCCAPPLY report server is exceptionally slow today. By the time it finds and downloads an application, I've been kicked off.
3
Categories
- 4 CCC Data Warehouse
- 66 CCCTC System Alerts
- 708 CCCApply
- 60 CCC MyPath
- 13 OpenCCC Student Account
- 28 CCC Promise Grant Application
- 62 CCC Accessibility Center
- 8 CCC Glue: College Adaptor
- 2 Enabling Services
- Implementation Project Managers (IPM)
- 1 College Relationship Managers (CRM)
- 116 CCCApply Report Center
- 34 CCCApply International Application
- CCCApply Administrator
- 47 Multiple Measures Initiative
- 45 Library Services Platform
- 11 Career Coach
- 4 C-ID
- 17 COCI
- 9 CCC ConferZoom
- eTranscript California
Answers
same at Allan Hancock College
Same at Allan Hancock College. It is taking longer to load than it keeps me logged in.
Your screen shot didn't show. Is this still happening? I was just able to log into the Report Center.
Over the past several weeks, users of the CCC Technology Center’s CCC Report Center have reported multiple instances of performance issues and outages.
First and foremost, we apologize for the downgraded user experience. We understand how frustrating barriers to your work can be.
Secondly, we want to ensure that you are aware of the short and long-term steps that we are taking to address the underlying issues.
The short term solution has been to restart the Report Center servers. The restart process clears out any long-running database queries, which appear to be the root cause of several of the instances of downgraded performance.
Following today’s outage, the Tech Center Support staff and Developers will be taking several steps to significantly reduce the frequency of performance issues, and increase the reliability of the Report Center user experience.
Index all fields that can be used for report generation
Enable controls to limit the ability to generate ad-hoc reports that rely on long-running queries against unindexed fields.
Conduct a Database Administrator’s review of all pre-generated reports insure existing reports are optimized.
Steps to prevent running bad queries
There are several precautions that you, as a Report Center user, can take to prevent bad queries.
Avoid overly complex searches that require joining multiple tables and/or views
Rather than using your browser’s “Back” button to navigate within Report Center, using the native navigation tools inside of Report Center (using the browser’s back button can inadvertently re-submit a duplicate query).
We apologize for any inconvenience caused by the disruptions in service, and we greatly appreciate your patience while we continue our efforts to improve your experience with Report Center.
John Hadad
Product Manager - CCCTC Report Center
[email protected]