Dirty Data Repair

  • Last update:December 05, 2025
  • Overview

    Version

    FineBI Server Version

    Functional Change

    6.1.4

    /

    6.1.6

    Allowed you to repair dirty data in Analysis Subject Configuration.

    Allowed you to repair dirty data in Recycle Bin in Platform Configuration.

    Application Scenario

    Dirty data may be generated in configurations due to some abnormal issues during system use.

    If such dirty data persists in the configuration, systemic issues may be incurred. This risk is particularly increased during upgrades, when dirty data can be generated across the system.

    Function Description

    FineBI provides the Dirty Data Repair function to help super administrators repair dirty data in FineBI configurations (manually or automatically).

    Dirty Data Definition

    The following table lists searchable dirty data scenarios supported by the Dirty Data Repair function.

    ConfigurationCategory

    Dirty Data Type

    Repair Logic

    Public Data Configuration

    BI Data Table

    Table not in any folder

    One-click repair is not supported.

    Locate and manually delete the dirty data as the administrator.

    Table (in a folder) whose ID is inconsistent with index information

    Correct index information.

    Table distributed across 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 1 to the name of one of the folders.

    Subfolder with a duplicate ID in a folder

    Deduplicate the subfolder ID.

    Subfolder whose IDs recorded in parent and child folders are inconsistent

    Correct related data in the parent folder based on the subfolder.

    Empty folder

    One-click repair is not supported.

    Locate and manually delete the dirty data as the administrator.

    Analysis Subject Configuration

    Folder

    Folder/Subject missing

    The system automatically reads configurations and repairs the dirty data.

    Subject

    Subject in which the resource mapping relationship is null

    Clear the records in which the resource mapping relationship is null.

    Subject/Folder containing existing resources that do not belong to the subject/folder

    Restore the resources to their corresponding subject/folder.

    Subject Model

    Subject model with abnormal associations

    Keep only one association and delete the others.

    Self-Service Dataset

    Self-service dataset with inconsistent publication records and states

    Repair publication states and records according to the publication table.

    Field

    Field missing

    Recalculate data to obtain relevant configurations.

    Platform Configuration

    User management

    Viewer set as an administrator

    Revoke the administrator privileges of the viewer.

    Recycle Bin

    Recycle bin with non-restorable resources

    Clear non-restorable resources in Recycle Bin.

    Dirty Data Repair

    This function is available only to the super administrator.

    1. Log in to FineBI as the super administrator 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. After the check is completed, the detected dirty data is displayed in a detail table.

    4. Manually/Automatically repair the dirty data.

    • For dirty data that supports one-click repair, tick the checkbox(s) as needed, 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 locate and delete the dirty data based on its location displayed in the detail table.

    附件列表


    主题: System Management
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy