Overview
Version
| FineBI Version | Functional Change |
|---|---|
6.1.4 | / |
Application Scenario
Dirty data may be generated in the configuration due to some abnormal issues during system use.
If such dirty data exists in the configuration for a long time, systemic issues may be incurred. Especially during the upgrade, dirty data will incur risks much more possibly.
Function Description
FineBI provides the Dirty Data Repair function to help administrators troubleshoot dirty data in FineBI configuration (with manual/automatic repair supported).
Dirty Data Definition
The following table lists searchable dirty data scenarios supported by the Dirty Data Repair function.
| Configuration Category | Dirty Data Type | Repair Logic | |
|---|---|---|---|
Public data configuration | BI data table | Table not in any folder | One-click repair is not supported. Go to the location of the dirty data and manually delete the dirty data as the admin. |
Table (in a folder) whose ID is inconsistent with index information | Repair index information. | ||
Table that exists in multiple folders | Deduplicate data based on folder relationships. | ||
Table with a duplicate table ID (specified by tableIds) in a folder | Delete the duplicate ID. | ||
Table that no longer exists in a folder | Delete the ID of the non-existent table. | ||
Folder | Folder with a duplicate name | Suffix the name of one folder with +1. | |
Subfolder with a duplicate ID in a folder | Deduplicate the subfolder ID. | ||
Subfolder whose IDs recorded in parent and child folders are inconsistent | Repair related data in the parent folder based on the subfolder. | ||
Empty folder | One-click repair is not supported. Go to the location of the dirty data and manually delete the dirty data as the admin. | ||
Platform configuration | User type | Check whether any user is appointed as the administrator. | Revoke the administrator permission of the viewer. |
Dirty Data Repair
This function is available only to the super admin account.
1. Log in to FineBI as the super admin and choose System Management > Dirty Data Repair.
2. Select the FineBI configuration and type that need to be repaired, and click Dirty Data Check.
3. Wait until the check is completed. Then the detected dirty data will be displayed in a detailed table.
4. Manually/Automatically repair the dirty data as the admin.
For dirty data that supports one-click repair, tick the checkbox, click Repair, and click OK in the pop-up box for automatic repair.
For dirty data that does not support one-click repair (in which case the checkbox is grayed out), manually delete the dirty data based on the location of the dirty data displayed in the detailed table.
