Clarity Automations
Our SaaS infrastructure understands Clarity and its unique requirements, delivering tailored automations that ensure optimal stability and performance.
Why Are We Doing This?
Our automations proactively clean up data and resolve common issues that many customers encounter over time. Scripts are executed automatically, ensuring that potential problems are addressed before they impact users.
What Are We Doing?
Cleanup Instance Rights
Regularly removes obsolete instance rights for the admin user (and optionally other users), for example rights where the related object instance no longer exists or where global access already covers the requirement.
Cleanup Old Prlocks
Deletes prImportExport locks that are older than 48 hours.
Cleanup Process Engines
Removes Process Engine entries with an end date older than one day.
Lock Default Password
Locks Clarity user accounts that are still using the default Clarity password for authentication.
Terminating Long-Running Portlet Sessions
Detects and terminates portlet sessions that run longer than 15 minutes. This process has no fixed schedule and is triggered automatically when such sessions are detected.
Benefit for Your Clarity Environment
Our automation initiatives have significantly enhanced the stability and performance of the Clarity system by:
- Proactively identifying and resolving bugs, reducing manual intervention and minimizing system downtime.
- Improving system health through continuous monitoring and automated remediation, ensuring optimal performance and reliability.
- Enhancing user experience by maintaining a smoother, error-free environment, which leads to increased productivity and reduced frustration.
- Accelerating issue resolution, allowing teams to focus on strategic tasks rather than routine maintenance.
- Providing consistent and scalable support, ensuring that the Clarity environment remains robust as usage grows.
These improvements contribute to a more resilient and efficient Clarity ecosystem, supporting better decision-making and operational excellence.
Background Database Activities
No matter if you're running your system on PostgreSQL, Oracle, or MSSQL — our automations ensure stability across all systems.
Why Database Maintenance Matters in Hosted Software
Even in the cloud, your software's performance depends on the health of its database. Over time, databases can accumulate fragmentation, outdated statistics, and bloated indexes - all of which slow down your system and impact user experience.
That’s why our SaaS includes automated, vendor-agnostic Database Maintenance. Whether you’re running on PostgreSQL, Oracle, or MSSQL – our background automations continuously optimize your data layer to:
- Ensure peak performance during high-load operations
- Prevent downtime by proactively addressing potential issues
- Support scalability as your data grows
- Reduce manual intervention, saving time and effort
What We Are Taking Care Of
Dead Tuple Cleanup / Defragmentation
Removes obsolete data to reduce bloat and improve overall efficiency.
Refreshing Database Statistics
Ensures that the database engine makes optimal decisions for query execution.
Info: The Clarity job “Database (Oracle/PostgreSQL) Table Analyze Job” also recalculates table statistics. If you plan to run it alongside our internal job, please avoid the 01:00–05:00 AM UTC window to prevent conflicts.Index Rebuilding
Optimizes data access paths to ensure fast and efficient query performance.
Health Monitoring
Continuously detects anomalies before they impact system performance.
Benefit for Your Clarity Environment
High Data Volume Changes
Issue: Database fragmentation increases and index efficiency decreases
Maintenance Benefit: Automated maintenance ensures that Clarity continues to operate at peak performance, even after significant data changes
Complex SQL Queries
Issue: Query performance may degrade due to complex joins or filters
Maintenance Benefit: Optimized indexes and up-to-date statistics ensure fast and efficient query execution
High System Load or Concurrent Updates
Issue: Load spikes and blocking sessions may occur
Maintenance Benefit: Our monitoring detects these situations in real time, enabling proactive measures before end-user performance is affected