Symptom
When connecting to Kepion, an error message appears with the message: "Sorry, the service is temporarily unavailable. Please check your connection or try again later."
Resolution
The error can arise when insufficient memory is available, but the error is more likely to occur when the web server shares the same machine as the SQL and SSAS servers. The reason for this is the latter two servers will consume all the available memory if not properly restricted.
Typically, we recommend a minimum of 14 GB of memory for a production-shared environment. The recommended memory allocation should be:
Production environment
| Number of Users | Web Server | SQL Server | SSAS Server |
|---|---|---|---|
| Small < 10 | 2+ GB | 4+ GB | 4+ GB |
| Medium < 50 | 4+ GB | 6+ GB | 6+ GB |
| Large > 50 | 6+ GB | 8+ GB | 8+ GB |
If the SQL/SSAS memory thresholds are not properly configured, then each server will consume as much available memory as possible. This causes problems in a shared environment, as the servers will compete with each other for memory.
When this issue occurs, you may still find that memory usage is low in Task Manager. Be aware that memory usage from the Task Manager may not accurately reflect SQL and SSAS memory consumption as those servers don't accurately report their usage to the OS.
To properly restrict the memory of your SQL and SSAS servers, Review the first part of the Kepion Setup Guide.