Operation and Maintenance Management FAQ
1. When creating a new date parameter named "Start 1", why does it report "Query statement parsing error" when put into cards?
Reason: Global parameter naming rules don't allow spaces, with spaces it cannot be used normally.
Solution: You can use underscores instead of spaces in parameter names, that is, change "Start 1" to "Start_1".
2. Why does login prompt "Page does not exist (or 404)"?
Reason: The link opened by the user doesn't have permission for that interface.
Solution:
1) User logs in from the BI website homepage without suffix (for example app.guandata.com);
2) If the above error has already appeared, please click the dashboard, data center and other buttons at the top to switch to pages with permissions, and the left navigation bar will be restored.
3. Can sub-user groups be moved under the root directory?
Answer: No, sub-user groups cannot be moved under the root directory, they can only be moved under other user groups.
4. What is the SaaS environment whitelist address? When the database needs to add whitelist to access, you need to add SaaS environment IP
Answer: IP: 52.131.237.184 (app.guandata.com)
5. The company already has many reports, now wants to purchase Guandata for self-service analysis, what about those original reports, do they need to be completely redone?
Answer: Currently there's no way to convert them to Guandata reports with one click. You can use iframe to embed them into the enterprise unified portal; or use external link cards on Guandata pages to embed other third-party report pages.
6. How to count Guandata platform usage over a period of time?
Answer: Through Administrator Settings-Task Management interface, you can view short-term Guandata platform task situations; through BI User Behavior Analysis page and datasets in the Built-in-Dataset folder, you can count all users' BI usage; through Nine-grid-Cloud Inspection, you can view recent system health status.
7. After logging into Guandata system, if you don't operate or refresh for a long time on the page, will the system automatically exit?
Answer: It will automatically exit after 24 hours.
8. Ordinary users, who are dataset owners, can authorize user permissions, but cannot authorize user group permissions, what's the reason?
Reason: In Administrator Settings-Permission Management-Advanced Settings-Group Permission Control, the "Allow users to assign permissions to user groups" switch is turned off.
Solution: Turn on the "Allow users to assign permissions to user groups" switch.
9. Which has higher priority between account synchronization created LDAP associations and manually created LDAP associations?
Answer: No priority distinction, based on the most recent run time.
10. Server resource alerts, at what value will alerts be pushed?
Answer: CPU, memory, and disk all alert at 75%. If adjustment is needed, please contact Guandata personnel to operate from the server side.
11. When a user belongs to two user groups, and both user groups have default pages set, which default page will the user get when opening, what's the rule?
Answer: When a user belongs to multiple user groups (for example A and B), the system will judge the user group default page modification time of user group A and user group B,
Then take the most recently modified user group default page.
12. Does BI allow shutting down the server without stopping services?
Answer: BI allows shutting down the server without stopping services, and supports automatic BI service activation after server startup, but for standardized operation purposes and to avoid data loss, it's recommended to close BI services according to the Start-Stop Manual before shutting down the server.
13. What are the task statuses when restarting ETL jobserver and restarting BI from the server?
Answer: In Administrator Settings--Service Management, restarting ETL jobserver can forcibly cancel all running tasks; restarting BI from the server (operations colleagues operate) will forcibly cancel all running and queued tasks. But both will briefly affect user usage.
14. When no tasks are running, why does the resource monitoring page show memory usage rate of 80% or even higher?
Answer: BI system mainly relies on Spark for calculations, so it will pre-allocate memory for Spark. For better response speed, this part of memory won't be released every time as the system is used. General machines after running for a period of time will stabilize at occupying 80% ~ 90% of the entire machine memory, this is in line with expectations and normal. If greater than 90%, please contact Guandata in time to adjust memory allocation.
15. Cloud Inspection: When multiple domains are deployed on one server, if only a certain domain does cloud inspection, will the inspection results have discrepancies?
Answer: Some data is not domain-divided, such as server-level data like CPU, memory, etc. These don't look at domains, only count that server. But ETL, datasets and other system usage statistical indicators will be divided by domain.
16. After importing file datasets and deleting them, but they keep showing as running in task management, how to cancel?
Import and export consume server resources, cannot be cancelled by clicking cancel in task management. Once deleted, this task cannot be cancelled and will run until failure. So when uploading file data, if it's large, it's recommended to upload during idle time. If after uploading you find it hasn't succeeded for half a day, first click cancel, then click delete, don't delete directly.
17. What's the specific logic for task priority support?
When not in queued status, this priority doesn't take effect; when queuing, first look at priority, then look at time. When priorities are the same, look at time. (For example, if there are currently a bunch of tasks queuing, the highest priority one will be next to run.)
18. How to limit accounts to only log in on one device at a time?
Administrator Settings——System Management——Login Settings——Ensure the "Ensure Single Login" setting switch is not enabled (Single Login: When the same account attempts to log in on multiple devices, new device login, old device automatically goes offline.)