Note: I am taking a safe approach here since this client's Sage X3 and SEI setup can be extremely complex.
SEI version details (requires a defense and a guarantee if need to update):
```
Version : 2023
Release : 2
Build : 23.0.2.20012
```
SEI server specs
```
CPU: 8x vCPU (Intel Xeon Silver, 2.1 GHz; non-negotiable)
RAM: 32 GB
```
Sage X3 version: v12p31, not allowed to update.
Reference: SEI View stuck in Pre-Fetching Data
When I access a SEI view, I get the following message: "Pre-Fetching"
Normally, this is a loading screen and should not be of concern.
However, my client waited for half an hour when the report used to complete in 20 seconds.
As per reference, I have restarted the whole SEI infrastructure as a temporary stopgap.
This issue reoccurs randomly and could not be predicted when it will have infinite Pre-Fetching loading issue.
No error given from Chrome web console other than the Network tab wait for a long period without any timeout triggered.
How can I resolve this issue permanently?
Management have a concern of SEI reliability and getting caught with pants down due to this unexplained SEI "Pre-Fetching" issue.