Log Keywords Explained

  • Last update:October 24, 2025
  • Overview

    Version      

    FineBI Server Version

    Functional Change

    6.0

    /

    Function Description

    After a data update in FineBI, if an error occurs and you need to identify the cause, you can check the log for detailed information.

    This document will explain the log keywords related to data updates and real-time data execution, helping administrators locate system issues.

    Log Path

    Log location: FineBI installation directory/logs

    Log file: fanruan.log (or fanruan.log.Date)

    Explanation of the Extracted Data Update Log

    Execution sequence: starting the update > updating the base table > updating the analysis table > updating the association > failing the update > ending the update

    iconNote:
    The log description here is generated at the INFO level. After viewing/retrieving detailed logs following the log level adjustment, you must promptly reset the log level to the daily ERROR level. Otherwise, it will affect the operational performance.

    1. Log keyword for the update type

    Update Type
    Keyword

    Single table update

    Table Load: {}

    Folder update

    Package Load Table: {}

    Global update

    Global Load Trigger!: {}

    2. Log keyword for the table update

    Function

    Sub-function

    Keyword

    Update start marker

    Base table

    Full Load:{}

    Incremental update of base tables

    Increase Load:{}

    Self-service dataset

    analysis Load:{}

    fast Load:{}

    Association cache

    relation load start

    relation load success

    relation load fail

    Start of table update execution

    table load start

    Table execution success

    table load success

    Table execution failure

    table load fail

    3. Log keyword for the association update

    Number of associations updated: [Group Load] RelationTask Size: {}

    4. Log keyword for the grouping task update

    Function

    Keyword

    Start of task execution

    [Group Load] Start {}

    Task execution failure

    [Group Load] Fail {}

    Task execution success

    [Group Load] Success {}

    Description of Real-Time Data Execution Log

    SQL Editing Page Preview

    Log level: INFO

    Log keyword: the preview sql is

    1.png

    SQL Dataset Field Extraction

    Log level: DEBUG

    Log keyword: direct.sql.table.field.sql

    Example:

    2.png

    SQL Dataset Data Extraction

    Log level: DEBUG

    Log keyword:

    • sql create: time consumed for SQL conversion

    • sql execute/slice sql execute: time consumed for the SQL query

    • sql foreach result/slice sql foreach result: time consumed for SQL data extraction

    The following figure shows the log example of dashboard preview.

    3.png

    The following figure shows the log example of dashboard editing.

    4.png

    附件列表


    主题: System Management
    Previous
    Next
    • 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