反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

LogDB Table Structure

  • Recent Updates: August 26, 2022
  • 1. Overview

    This article will briefly introduce the meaning of each data table and table field in the Logdb database.

    surface

    name

    fine_record_execute

    BI execution table

    fine_record_login

    login form

    fine_record_logout

    logout form

    fine_record_email

    mailing list

    fine_record_write

    Fill out the report

    fine_record_error

    Execution error log table

    fine_record_param

    Common parameter combination table

    fine_record_sms

    SMS sending form

    fine_record_operate

    Manage log tables

    fine_record_sql

    SQL execution table

    fine_record_gc

    GC log sheet

    fine_record_conf

    Part of the configuration information table

    fine_record_lock

    User lock log table

    fine_tpl_info

    Template property sheet

    fine_container_entity

    Container Information Sheet

    fine_function_process

    Function point information table

    fine_operation_process_log

    Cloud operation and maintenance operation log table

    fine_operation_shutdown_record

    Semaphore Information Table

    fine_plugin_usage

    Plugin Information Sheet

    fine_schedule_record

    Scheduled task execution log table

    fine_config_operation

    delete behavior monitoring table

    fine_relationship

    blood relationship analysis table

    fine_intelli_honeypot

    Instant burial table

    fine_intelli_log_honeypot

    log entry table

    fine_update_task

    Update task list

    fine_update_task_detail

    Update task schedule

    performAnalysis

    data structure

    fine_intelli_focus_point

    Function Buried Point Table

    fine_real_time_usage

    Application Live Fact Sheet

    fine_intelli_consume_point

    Performance Information Sheet

    fine_template_errorExecution error log
    fine_engine_performanceComputational task basic information record


    2. fine_record_execute BI execution table

    BI execution table: report access/export/print log, that is, if the report is accessed/exported/printed, a record will be added to the table, and the corresponding information record will be filled in the corresponding field.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user-VARCHAR

    id

    primary key

    -

    VARCHAR

    tname

    Dashboard storage path

    -

    VARCHAR

    displayName

    The   name of the directory to mount to the platform

    record   directory full path

    Empty   if the link is accessed directly

    VARCHAR

    type

    Report access method

    The details are listed in the table   below

    The range is 0~105, and 33 codes have   been used so far

    INTEGER

    param

    Record the shared node name

    2020-08-04 and later JARs have a value   for this field

    If the shared node is a multi-level   department, the record format is: 1-level node/2-level node/node

    Record one row of data per share, only   record, but not export

    VARCHAR

    ip

    Operator IP

    Only log, but not export

    VARCHAR

    username

    User who executed the report


    VARCHAR

    userrole

    User role to execute the report


    VARCHAR

    consume

    time consuming to execute

    Including   SQL execution time and report calculation time

    The   unit is ms

    BIGINT

    time

    log start time


    BIGINT

    sql

    SQL statement


    VARCHAR

    sqlTime

    Total time for SQL execution

    FR valid field, 0 for BI Dashboard,   not used by BI

    BIGINT

    browser

    The browser version used by the client   to access the report

    5.1.11   and later versions, you can use the terminal in this field to determine the   access terminal

    browser:   browser type and version

    OSInfo   : Operating system, divided into Windows, Mac, Unix

    terminal:   Client ID, divided into PC, App, H5

    • PC: The access terminal        is the PC side

    • App: The access        terminal is FanRuan App/HTML5 terminal to access the public link

    • H5: HTML5 side access        to non-public link templates

    VARCHAR

    memory

    Report occupies memory, unit B

    FR valid field, 0 for BI Dashboard,   not used by BI

    BIGINT

    reportId

    Template number


    VARCHAR

    userId

    User ID


    VARCHAR

    complete

    Whether the calculation is complete

    FR valid field, 0 for BI Dashboard,   not used by BI

    INTEGER

    source

    interview method

    FR valid field, 0 for BI Dashboard,   not used by BI

    VARCHAR

    sessionID

    session id

    the front-end rendering time-consuming   related points in the performance point table ( fine_intelli_consume_point )

    VARCHAR

    node

    The   node name of the loaded template

    treasure   package needs to be exported. For details, please refer to: Cloud   operation and maintenance steps

    VARCHAR

    error

    The   first error message during template execution

    treasure   package needs to be exported. For details, please refer to: Cloud   operation and maintenance steps

    VARCHAR

    webInfo

    Template   execution information

    webResolution   : The resolution of the current template execution when accessed on the front   end, the record format is x*y

    fullScreen   : Whether the current template execution is in full screen mode when accessed   on the front end, the record format is 1/0

    VARCHAR

    lastModLast change time of template-BIGINT
    detaildetailed informationUsed to record the shared dashboard detailsVARCHAR
    fineMarIdPreview the device ID used by the template-VARCHAR

    Note: The node, error, and webInfo fields need to be updated to the JAR package of 2021-03-17 and later versions.

    The specific meaning of the field type:

    coding

    type

    parameter

    0

    Pagination preview

    page

    1

    Online analysis

    view

    2

    Fill in the preview

    write

    3

    Decision report preview

    form

    4

    line engine

    layer

    5

    online editing

    edit

    6

    new report

    write_plus

    7

    New engine preview

    page_plus

    8Large screen FVS Preview
    9Developer debug Preview

    10

    Excel Paginated Export

    excel

    11

    Export to Excel as is

    excelO

    12

    Excel full page export

    excelL

    13

    Excel pagination and sheet export

    excelS

    14

    PDF export

    pdf

    15

    Word export

    word

    16

    SVG export

    svg

    17

    CSV export

    csv

    18

    Text export

    text

    19

    JPG image export

    jpg

    20

    PNG image export

    png

    21

    GIF image export

    gif

    22

    BMP image export

    bmp

    23

    WBMP image export

    wbmp

    24

    Built-in dataset export templates

    cpt

    25

    HTML export

    html

    26

    Fill out HTML export

    write_html

    27

    BI Export Excel


    30

    Flash printing

    print_flash

    31

    PDF printing

    print_pdf

    32

    Applet printing

    print_applet 

    33

    Zero client printing

    print_noclient

    34

    local software printing

    print_native

    101

    View BI Templates

    bi_view

    102

    Edit BI templates

    1)   Recording logic: Click on a dashboard to enter the editing state, wait for   the page to be fully loaded, no matter how many operations are performed or   no operations are performed, record it once; next time, click on the template   to edit or refresh the web page to record the second time

    2)   The same dashboard, each edit will have a record

    bi_edit

    103

    Share BI templates

    bi_share

    104

    Create BI public link

    bi_create_publink

    105

    View BI public link

    bi_view_share

    106

    BI template global export PDF

    bi_template_export_pdf

    107

    BI template global export to Excel

    bi_template_export_excel

    108

    BI component export to Excel

    bi_component_export_excel

    109

    BI template save as


    201

    Close the browser or tab page (BI)


    202

    Edit Self-Service Datasets


    203

    Share self-service datasets

    bi_analysis_table_share

    204

    Close Share Self-Service Datasets


    205

    Close Share BI Template


    206

    Close BI public link


    302Edit component
    401Preview excel plug-in template
    402Edit excel plug-in template (reserved)
    403Share excel plug-in template
    404Create excel plug-in public link
    405Access excel plug-in templates through public links
    408Excel component export Excel
    409Save excel dashboard as

     

    3. fine_record_login login form

    Login table : User login log, used to record user login information.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    Log in time

    BIGINT

    ip

    Login IP address

    VARCHAR

    username

    logged in user

    VARCHAR

    userrole

    logged in user role

    VARCHAR


    4. fine_record_logout logout table

    Logout table : User logout log, used to record user logout information.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    User exit the platform time

    BIGINT

    ip

    logout IP address

    VARCHAR

    username

    Username to log out of the platform

    VARCHAR

    userrole

    User role to log out of the platform

    VARCHAR


    5. fine_record_email mailing form

    Mail table : Mail sending log (only includes "Mail" in the toolbar), that is, if the report sends mail, a record will be added to the table, and the corresponding information record will be filled in the corresponding field.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR
    senderSender user nameVARCHAR

    receiver

    recipient username

    VARCHAR

    mail

    recipient email

    VARCHAR

    ip

    The IP address from which the email   was sent

    VARCHAR

    username

    the user who sent the email

    VARCHAR

    tname

    Dashboard storage path

    VARCHAR

    displayName

    The actual name of the dashboard, not   the name of the dashboard in Catalog Management

    Empty if the link is accessed directly

    VARCHAR

    content

    content of email

    VARCHAR

    time

    send time

    BIGINT

    result

    Is it sent successfully

    BIT

    detail

    Details

    VARCHAR


    6. fine_record_write fill in the report

    Fill in the report : record the log information of the report, that is, if the report is filled out, a record will be added to the table, and the corresponding information record will be filled in the corresponding field.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    username

    User who filled out the report

    VARCHAR

    tname  

    Dashboard storage path

    VARCHAR

    time

    Fill in time

    BIGINT

    sql

    SQL statement

    VARCHAR

    sqlTime

    Total time for SQL execution

    BIGINT

    result

    Whether the filling is successful

    BIT

    ip

    The IP address for filling in the   report

    VARCHAR

    displayName

    The actual name of the dashboard, not   the name of the dashboard in Catalog Management

    Empty if the link is accessed directly

    VARCHAR

    detail

    Details

    VARCHAR

    browser

    The browser version used by the client   to access the report

    VARCHAR

    consume

    Execution time, including SQL   execution time, report calculation time

    BIGINT

    bodyUse the JSON data structure to record the following information:

    1) Key: request fixed flag

    2)value:(times, max,min,avg)

    • Times: occurrence times of this type of request, unit: Times

    • Max: maximum response time of this type of request, unit: ms

    • Min: minimum response time of this type of request, unit: ms

    • AVG: average response time of this type of request, unit: ms

    VARCHAR


    7. fine_record_error execution error log table

    Execution error log table : that is, if an error is reported during the execution of the report, a record will be added to the table, and the corresponding information record will be filled in the corresponding field to record all error and fatal level error messages.

    The corresponding meanings of each field are shown in the following table:

    Note: finebi5.1.19 and later, fine_ record_ Error is no longer used, and the error information is recorded in fine_ template_ Error table.

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    displayName

    The actual name of the dashboard, not   the name of the dashboard in Catalog Management

    Empty if the link is accessed directly

    VARCHAR

    ip

    The IP address where the report is   executed


    VARCHAR

    msg

    error message


    VARCHAR

    time

    Error record time


    DATE

    tname

    Incorrect dashboard storage path

    If it is not a template error, tname   is logged as "non-template trigger error".

    VARCHAR

    trace

    wrong path


    VARCHAR

    username

    User who executed the report


    VARCHAR

    userrole

    User role to execute the report


    VARCHAR

    errorcode

    error code

    Empty when there is no error code

    VARCHAR

    platformDisplay

    Whether to show in the platform

    1 - yes

    0-no

    There is an error log recorded to this   table, this field is recorded as 1, otherwise this field is recorded as 0

    Filter the display in the error log of   the platform log, and only display the records with platformDisplay =1.

    INTEGER


    8. Fine_record_param common parameter combination table

    Common parameter combination table : record common parameter combination log information.

    Note: fine_ record_ Param table is a common parameter table of fr

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuid
    Unique identification field of the user
    VARCHAR

    templateid

    Dashboard ID


    VARCHAR

    username

    user


    VARCHAR

    pgroup

    Parameters, values are displayed in   array form:

    {parameter1: parameter value,   parameter2: parameter value}

    2020-02-28 and later JAR, pgroup field   value encrypted display

    VARCHAR

    time

    record time


    BIGINT


    9. fine_record_sms SMS sending form

    SMS sending table : record the message sending log information, that is, if sending a short message, a record will be added to the table, and the corresponding information record will be filled in the corresponding field.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    receiver

    recipient username

    VARCHAR

    mobile

    Receiver's mobile phone number

    VARCHAR

    content

    content of email

    VARCHAR

    time

    send time

    BIGINT

    result

    Is it sent successfully

    BIT

    detail

    Details

    VARCHAR

    sender

    sender username

    VARCHAR


    10. fine_record_operate management log table

    Management log table: that is, when the user operates the module, a record will be added to the table, and the corresponding information record will be filled in the corresponding field.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    type

    Module (stores internationalized keys)

    VARCHAR

    item

    setting item

    VARCHAR

    resource

    Accessed resource

    VARCHAR

    operate

    operate

    VARCHAR

    username

    username

    VARCHAR

    ip

    User IP address

    VARCHAR

    time

    User operation time

    BIGINT

    detail

    Details

    VARCHAR

    requestParam

    request parameters

    VARCHAR

    platformDisplay

    Platform display level

    INTEGER

    status

    success or failure of this operation

    INTEGER

    The specific scenarios that need to be recorded are shown in the following table:

    TYPE-module

    ITEM-settings

    RESOURCE - Accessed resource

    OPERATION - Operation

    DETAIL-details

    Directory management

    node

    "node full path"

    add/delete/modify


    Directory management

    template

    "node full path"

    add/delete/modify


    Directory management

    Link

    "node full path"

    add/delete/modify


    Directory management

    escalation label

    "node full path"

    add/delete/modify


    User Management

    Global Settings


    change


    User Management

    user

    "name (username)"

    add/delete/modify


    User Management

    department

    "Department-wide path"

    add/delete/modify


    User Management

    Under the department

    "Job Full Path"

    add/delete


    User Management

    Position

    "position Name"

    add/delete


    User Management

    Person under the post

    "Job Title" - "Name   (Username)"

    add/delete


    User Management

    Role

    "Role Name"

    add/delete/modify


    User Management

    Personnel under the role

    "role name" - "name   (username)"

    add/delete


    User Management

    Platform users

    "name (username)"

    add/delete


    User Management

    BI view only users

    "name (username)"

    add/delete


    User Management

    BI editor user

    "name (username)"

    add/delete


    User Management

    mobile platform users

    "name (username)"

    add/delete


    authority management

    Global Settings


    change


    authority management

    Permission settings

    "Department/Role/Name   (Username)"

    add/delete

    Permission Item: "Directory/Data   Connection/Business Package/Manageable Department Role"
      Type: View/Authorize/Edit

    authority management

    Permission reuse

    "Effective object   [department/role/name (username)]"

    multiplex

    Source: "Department/Role/Name   (Username)"
      Type: "Permission Item"

    System Management

    Log in

    single sign-on

    switch


    System Management

    Log in

    Single sign-on setup

    change


    System Management

    Log in

    Last login information prompt

    switch


    System Management

    Log in

    Forgot password

    switch


    System Management

    Log in

    SMS verification

    switch


    System Management

    conventional

    General parameters

    change


    System Management

    conventional

    BI parameters

    change


    System Management

    Print

    Print Settings

    change


    System Management

    Short message

    SMS platform

    switch


    System Management

    Short message

    account binding

    change


    System Management

    Mail

    sender account

    change


    Backup restore

    Global configuration


    change


    Backup restore

    Platform configuration

    automatic backup

    switch


    Backup restore

    Platform configuration

    backup file

    Add/Delete/Restore


    Backup restore

    report template

    automatic backup

    switch


    Backup restore

    report template

    backup file

    Add/Delete/Restore


    Backup restore

    BI template

    automatic backup

    switch


    Backup restore

    BI template

    backup file

    Add/Delete/Restore


    Backup restore

    jar package

    automatic backup

    switch


    Backup restore

    jar package

    backup file

    Add/Delete/Restore


    Backup restore

    plugin

    automatic backup

    switch


    Backup restore

    plugin

    backup file

    Add/Delete/Restore


    Backup restore

    Update and upgrade

    jar package update

    renew


    Backup restore

    Update and upgrade

    jar package restore

    reduction


    Backup restore

    Update and upgrade

    Backup jar package

    delete


    Platform log

    log settings


    change


    Platform log

    access details


    export


    Platform log

    user behavior


    export


    Platform log

    Template heat


    export


    Platform log

    performance monitoring


    export


    memory management

    Intelligent early warning


    change


    memory management

    memory session

    "name (username)" -   "template path"

    Finish


    memory management

    Smart release


    change


    memory management

    Template restrictions


    change


    memory management

    The life cycle


    change


    Data Connections

    Data Connections

    "Data Connection Name"

    add/delete/modify


    registration message

    Public cloud authentication/private   cloud authentication/upload lic file


    change


    safety management

    SQL injection prevention

    Disable special keywords

    switch


    safety management

    SQL injection prevention

    Disabled special keywords

    change


    safety management

    SQL injection prevention

    escape character

    switch


    safety management

    SQL injection prevention

    escaped character

    change


    Scheduled

    timed task

    "mission name"

    add/delete/modify


    Scheduled

    Global Settings


    change


    Multi-level reporting

    Reporting process

    "process name"

    add/delete/modify


    Multi-level reporting

    escalate task

    "task name"

    add/delete/modify


    mobile platform

    mobile platform


    switch


    mobile platform

    Authorized device


    change


    mobile platform

    QR code configuration


    change


    Template authentication

    Global Settings


    change


    Template authentication

    Permission settings

    "Department/Role/Name   (Username)"

    add/delete

    Permission item: "Template   Path"
      Type: View/Fill

    Remote Design Permission

    Permission settings

    "name (username)"

    change

    Changed permission item:   "template path"

    Plugin management

    Plugin management

    "plugin name"

    install/remove/enable/disable/update



    11. fine_record_sql SQL execution table

    SQL execution table: records the execution of SQL.

    Note: fine_ record_ The SQL table does not store the SQL records of the Bi template, but only the SQL calculation process of the report engine.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    columns

    dataset size

    number of record columns

    BIGINT

    dsname

    the name of the dataset


    VARCHAR

    executeid

    execution table id


    VARCHAR

    rows

    dataset size

    number of records

    BIGINT

    sqltime

    SQL execution time

    Unit: milliseconds

    BIGINT

    connection

    data connection name


    VARCHAR

    connectionID

    data connection ID

    with the data source connection   related points in the function point table ( fine_intelli_focus_point )

    VARCHAR

    time

    record time


    BIGINT


    12. fine_record_gc GC record table

    GC record table: record the GC information of the system.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    heapBeforeUsed

    Heap memory usage before GC


    BIGINT

    heapAfterUsed

    Heap memory usage before GC


    BIGINT

    heapBeforeCommitted

    Heap request memory after GC


    BIGINT

    heapAfterCommitted

    Heap request memory after GC


    BIGINT

    gcStartTime

    GC start time


    BIGINT

    duration

    GC duration


    BIGINT

    gcCause

    Reasons for GC

    Common causes are: System.gc () ,   allocation failure, humongous

    VARCHAR

    gcType

    GC type

    Divided into Young GC and Full GC

    VARCHAR

    metaspaceBeforeUsed

    metaspace GC


    BIGINT

    metaspaceBeforeCommitted

    metaspace GC


    BIGINT

    metaspaceAfterUsed

    metaspace GC


    BIGINT

    metaspaceAfterCommitted

    metaspace GC


    BIGINT

    balancePromoterScore

    stop score


    INTEGER

    youngBeforeUsed

    Memory used before young generation GC


    BIGINT

    youngBeforeCommitted

    Allocate memory before young   generation GC


    BIGINT

    youngAfterUsed

    Memory usage after young generation GC


    BIGINT

    youngAfterCommitted

    Allocating memory after young   generation GC


    BIGINT

    loadScore

    Overall Load Score


    INTEGER

    node

    User named node name

    Standalone is empty

    VARCHAR

    oldBeforeUsed

    Memory used before old generation GC


    BIGINT

    oldBeforeCommitted

    Allocate memory before old age GC


    BIGINT

    oldAfterUsed

    Memory usage after old generation GC


    BIGINT

    oldAfterCommitted

    Allocating memory after old age GC


    BIGINT

    pid

    process pid


    VARCHAR

    releasePromoterScore

    release points


    INTEGER

    timeRecord time
    BIGINT


    13. Fine_record_conf part of the configuration information table

    Record some configuration information in fine_conf_entity.

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    record time

    BIGINT

    id

    configuration item

    VARCHAR

    value

    Configuration item value

    VARCHAR


    14. fine_record_lock user lock log table

    log user lockout

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    warehousing time

    BIGINT

    lockItem

    lock object

    VARCHAR

    lockTime

    lock time

    VARCHAR

    autoUnlockTime

    Auto unlock time

    VARCHAR


    15. fine_tpl_info template attribute table

    record template properties

    Note: This table has no practical use and is only for backup. So no data will be recorded in the table.

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    time

    warehousing time


    BIGINT

    id

    serial number


    VARCHAR

    tid

    template id


    VARCHAR

    tname

    Physical template name

    Record the full path under the   reportlet

    VARCHAR

    cnums

    number of conditional attributes


    BIGINT

    formnums

    Number of formulas


    BIGINT

    sheetnums

    Number of sheets


    BIGINT

    dsnums

    number of datasets


    BIGINT

    compformnums

    number of complex formulas

    Including hierarchical coordinates,   sql , value formulas

    BIGINT

    submitnums

    Number of built-in commits


    BIGINT

    isfrozen

    whether to use freeze


    BIT

    isfoldtree

    whether a folded tree is used


    BIT

    widgetnums

    Number of controls


    BIGINT

    tsize

    total template size


    BIGINT

    imgsize

    The size of the image in the template


    BIGINT

    execute0

    Engine Condition Summary 0


    BIGINT

    execute1

    Engine Condition Summary 1


    BIGINT

    execute2

    Engine Condition Summary 2


    BIGINT

    execute3

    Engine Condition Summary 3


    BIGINT

    execute4

    Engine Condition Summary 4


    BIGINT

    mem0

    Summary of memory conditions 0


    BIGINT

    mem1

    Summary of memory conditions 1


    BIGINT

    mem2

    Memory situation summary 2


    BIGINT

    mem3

    Memory situation summary 3


    BIGINT

    mem4

    Memory situation summary 4


    BIGINT

    sql0

    sql situation summary 0


    BIGINT

    sql1

    sql situation summary 1


    BIGINT

    sql2

    sql situation summary 2


    BIGINT

    sql3

    sql situation summary 3


    BIGINT

    sql4

    sql situation summary 4


    BIGINT

    filternums

    number of filters


    BIGINT

    injectnums

    The number of parameter injections


    BIGINT

    formula

    Use of formulas in templates


    VARCHAR

    jsapi

    JS API usage in templates


    VARCHAR

    recordtime

    Template detection time


    VARCHAR


    16. fine_container_entity container information table

    record container information

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    warehousing time

    BIGINT

    node

    node name

    VARCHAR

    item

    configuration item

    VARCHAR

    value

    configuration item

    VARCHAR



    17. fine_function_process function point information table

    Record function point information


    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    warehousing time

    BIGINT

    function

    function points

    VARCHAR



    18. fine_operation_process_log cloud operation and maintenance operation log table

    Record cloud operation and maintenance operation logs


    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    record time

    BIGINT

    node

    node name

    VARCHAR

    process

    log content

    VARCHAR



    19. fine_operation_shutdown_record semaphore information table

    record semaphore information

    Note: fine_ operation_ shutdown_ Record and fine_ plugin_ Usage integrated into fine_ intelli_ focus_ Point table

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    warehousing time

    BIGINT

    pid

    Process ID

    VARCHAR

    startTime

    Starting time

    BIGINT

    upTime

    deadline

    BIGINT

    node

    node

    VARCHAR

    signalName

    signal name

    VARCHAR


    20. fine_plugin_usage plugin information table

    Log plugin information

    Note: fine_ operation_ shutdown_ Record and fine_ plugin_ Usage integrated into fine_ intelli_ focus_ Point table

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR

    time

    warehousing time

    BIGINT

    plugin

    plugin name

    VARCHAR

    version

    Plugin version

    VARCHAR

    API

    Interface usage in plugins

    VARCHAR

    operation

    Plugin operation

    VARCHAR

    register

    Plug-in registration

    VARCHAR

    enable

    Whether the plugin is enabled

    BIT


    21. fine_schedule_record timed task execution log table

    Record timing task execution information

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    id

    primary key


    UUID

    VARCHAR

    creator

    creator

    -

    VARCHAR

    detailMessage

    details

    -

    VARCHAR

    filePath

    Generate attachment path

    reserved field, unused

    VARCHAR

    logMessage

    log information

    -

    VARCHAR

    logTime

    task execution time

    log print time

    BIGINT

    logType

    log type

    0 - fail

    1 - Success

    2- Skip

    INTEGER

    nextFireTime

    next recording time

    reserved field, unused

    BIGINT

    runType

    Attachment Handling Type

    0 - snapshot generation

    1- Mail sending

    2-FTP upload

    3-Message push

    4-File printing

    5-SMS sending

    6-Platform mount

    7- Custom class

    8- Timely fill in the report

    9- Client Notification

    10-SFTP upload

    INTEGER

    taskName

    mission name

    -

    VARCHAR

    taskID

    task id

    -

    VARCHAR

    time

    warehousing time

    -

    BIGINT


    22. Fine_intelli_focus_point function buried point table

    Function burial point table: used to save all public burial point information.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    id

    Buried point ID number


    VARCHAR

    text

    Main content of the record


    VARCHAR

    source

    Buried point source

    -1 - no source defined (UNDEFINED)

    1- Function point of built-in JAR   package (EMBED)

    2-Plug-in function point (PLUGIN)

    4- FineReport 's function points   (REPORT)

    8- Function Points (BI) of FineBI

    INTEGER

    time

    time


    DATE

    username

    username

    Transcoding processing, super user is   0

    VARCHAR

    ip

    The IP of the departure point


    VARCHAR

    title

    title, what's the point


    VARCHAR

    body

    a JSON data structure

    Store the information of different   function points according to the function point ID

    secondary information, may be empty

    VARCHAR

    Field id format description:

    Example: FR-P1001

    FR prefix, indicating that it is the buried point of FR.

    The first letter indicates function/performance: F-function, P-performance.

    The second digit indicates the classification: 1-data source, 2-frontend, 3-error, 4-intelligent operation and maintenance, 5-designer.

    The relationship between the field id and body in the table is shown in the following table:

    id

    body

    effect

    FR-P1001

    id: data connection ID

    version: data source version

    driver: connection driver information

    times: times of use

    connecttime : the time the connection   was created

    Used to log data connection related   information

    FR-F3001

    Record the specific error stack

    Record the cause of the project   startup failure error message

    FR-F4001

    Example of the first version of the   plug-in record: {node:2,memory:16,situation:normal,inform:1,type:auto}

    node is the recommended number of   nodes (referred to as 1 when a single machine is recommended)

    memory is the recommended single   machine/single node memory

    situation is the recommended   situation: when it is marked as "normal", it is a normal   recommendation, when it is "error", it is an abnormal situation of   the recommended value, when it is " inequacy ", it is a situation   where the running data is insufficient, and when it is   "nonsupport", the recommended configuration is not supported. Among   them, in the "normal" case, node and memory have values, and in   other cases, node and memory are recorded as empty.

    inform is whether the notification has   been made, recorded as 1 for notified, and 0 for not notified

    type is the recommended type, marked   as "auto" is the result of recommendation based on the running data   of a natural day, marked as "manual" is the result recommended by   the user access interface link

    Recommended values for memory   configuration

    FR-F4002

    Record example: { sessionid : xxxxxx ,   reason: release, detail: row count, load: high load, cell num: 100000,   survival time: 600000}

    sessionid : the session id being   cleared

    reason: Category of the reason why the   session was cleared. Including life (life cycle), limit (template limit),   release (smart release) three items

    detail: the detailed reason why the   session was cleared

    • When reason is recorded as life, this record is        empty.

    • When reason is recorded as limit, this record        is: row count (limit of rows in a single data set), cell count (limit of        cells in a single template), sql time ( limit of sql execution time),        excel cell count (limit of imported Excel cells) ), commit row count        (commit record number limit), cartesian (fill in Cartesian product        limit)

    • When reason is recorded as release, this record        is: stop calculating

    load: The load status of the system   when the session was killed. Including endanger (dangerous state), terrible   load (ultra-high load), high load (high load), normal load (medium and low   load)

    cell num: the number of cells that   have been calculated

    survival time: survival time

    Logs when sessions are cleared due to   lifetime, template limits, and stops computing at high load

    FR-F4003

    Record example: {type: high load kill,   kill num time: 50, kill num cell: 50, session num: 300, load: terrible load}

    type: including high load kill (small   kill), terrible load kill (big kill), remove all (super kill to clear all   sessions)

    kill num time: The number of sessions   killed due to not updating for a long time. When the type is removeAll , it   is recorded as empty

    kill num cell: The number of sessions   killed due to too many cells. When the type is removeAll , it is recorded as   empty

    kill num sum: the sum of the number of   sessions killed

    session num: the total number of   sessions before releasing the session

    load: The load status of the system   when the session was killed. Including endanger (dangerous state), terrible   load (ultra-high load), high load (high load), normal load (medium and low   load)

    Record the release session triggered   by the GC callback

    FR-F5001

    Example record: {disk_beforegc:50,   disk_aftergc:50}

    Record template version management GC   cleanup

    FR-F5002

    node: node name

    time: process shutdown time

    pid : process pid

    startTime : Process start time

    upTime : Process duration

    signalName : semaphore

    System shutdown record: record the   process information and shutdown type before and after system shutdown

    FR-F5003

    node: node name

    containerMem : The memory size set by   the container

    cpu : the number of CPU cores

    disk: total disk space

    diskUsed disk used space

    jdkVersion : JDK version

    containerVersion : Web container   version

    machineMem : physical machine memory

    system: server operating system

    systemNum : Server OS Bits

    arch: processor architecture, such as   x86_64, x86

    diskSpeed : disk access speed

    FRbuildNO : the jar package version of   FR

    BIbuildNO : BI jar package version   (record the BI jar package version, if BI is not used, record it as empty)

    serverType : server type (cloud   represents cloud server, local represents local server)

    gcType : garbage collector type

    Container configuration: configuration   information of the container and server where the application is located.   record once a day

    FR-F5004

    licType : registration type

    expireTime : registration expiration   time

    CTRID: Contract ID

    companyId : Company ID

    productVersion : product version

    platformUserNum : the number of users

    User basic information: the user's   registration information and other content. record once a day

    FR-F5005

    tid : Template ID

    tName : Physical template name ( full   path under reportlets )

    cNums : the number of conditional   attributes

    formNums : the number of formulas

    sheetNums : the number of multiple   sheets

    dsNums : the number of datasets

    compFormNums : The number of complex   formulas (including hierarchical coordinates, SQL, and Value formulas)

    submitNums : the number of built-in   submissions

    isFrozen : whether freezing is used

    isFoldTree : whether a folded tree is   used

    widgetNums : the number of controls

    filterNums : number of filters

    injectNums : the number of parameter   injections

    formula: formula usage in the template

    jsAPI : In-template JS API usage   (limit record to 255 characters)

    tSize : total template size

    imgSize : The size of the image in the   template

    lineEngine : whether to enable the   line engine (1 is enabled, 0 is not enabled)

    execute0-execute4: 5-level segmented   record of execution time

    mem0-mem4: 5-level segmented record of   memory usage

    sql0-sql4: 5-level segmented record of   SQL execution time

    Template attribute information: record   the information of the template, each template outputs one record per day

    FR-F5006

    id: the location of the data in the   configuration

    value: data value

    Configuration information: record   specific information in the fine_conf_entity table in FineDB once a day

    FR-F5007

    plugin: plugin name

    version: plugin version

    API: The interface used in the plug-in

    opration : plugin operation status

    register: plugin registration status

    enable: whether the plugin is enabled

    Plugin usage: the usage of plugins,   each plugin is recorded once a day

    FR-F5008

    function: Purchase status of function   points

    Purchase of function points: Purchase   of function points, recorded once a day


    23. fine_real_time_usage application real-time situation table

    Application real-time situation table: record application real-time situation.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    VARCHAR

    node

    node name

    2019-05-20 and later JAR new fields

    VARCHAR

    cpu

    CPU utilization


    DOUBLE

    memory

    Current JVM memory situation


    BIGINT

    time

    Record time, one per minute


    BIGINT

    sessionNum

    Number of live sessions

    2019-05-20 and later JAR new fields

    BIGINT

    onlineNum

    Number of people online

    2019-05-20 and later JAR new fields

    BIGINT

    pid

    Process PID

    2019-05-20 and later JAR new fields

    VARCHAR

    templateRequest

    Counting template requests


    INTEGER

    httpRequest

    The total number of http requests   being processed


    INTEGER

    sessionRequest

    Number of requests with sessionid   being processed


    INTEGER

    fineIO

    fineIO occupies off-heap memory size

    Unit KB

    2020-08-04 and later JAR new fields

    BIGINT

    NIO

    NIO occupies off-heap memory size

    Unit KB

    2020-08-04 and later JAR new fields

    BIGINT

    bufferMemUse

    Total memory used off-heap

    directMem " nio " and   mappedMem

    Unit KB

    2020-08-04 and later JAR new fields

    BIGINT

    physicalMemUse

    Physical memory used space

    Unit KB

    2020-08-04 and later JAR new fields

    BIGINT

    physicalMemFree

    Physical memory free space

    Unit KB

    2020-08-04 and later JAR new fields

    BIGINT


    24. fine_intelli_consume_point performance information table

    Performance Information Sheet: Records performance-related information.

    The corresponding meanings of each field are shown in the following table:

    field

    meaning

    Remark

    Field Type

    uuidUnique identification field of the user
    String
    time

    time

    Starting time


    Long

    id

    Buried point id number

    BI is X961

    String
    text

    Resource content

    It can be template name, analysis table name, etc. Bi does not use this fielString

    source

    Buried point source

    Inside the Original class

    embed: Indicates the current system

    plugin: Indicates the buried point of   the plugin

    undefined: indicates that no source is   defined

    Int
    usernameoperator
    String
    ipOperation IP
    String
    titleresource IDCan be template ID, analysis table ID,   table ID, etc.String
    frFullVersion
    FR version

    String
    biFullVersionBI version
    String
    cloudVersion
    Cloud operation and maintenance versionString
    finish

    End Time

    FR valid field, BI is 0, this field is   not used by BI

    String

    consume

    Time-consuming unit ms


    String

    memory

    Memory size unit byte

    FR valid field, BI is 0, this field is   not used by BI

    String
    type

    Operation type

    It is possible to indicate which   operation was performed. BI does not use the field

    String

    comment

    Resource Notes

    It can be more specific information,   data that needs to be analyzed directly. BI does not use the field 

    String

    body

    Bury specific information

    A JSON data structure that stores   different information according to different buried points

    String


    25.fine_template_error Execution error log

    The corresponding meanings of each field are shown in the following table:

    Note: finebi5.1.19 and later, fine_ record_ Error is no longer used, and the error information is recorded in fine_ template_ Error table.

    field name

    meaning

    Data Format

    uuid

    Unique identification field of the user

    VARCHAR

    time

    Error recording time

    BIGINT

    displayName

    The name of the directory mounted to the platform. The front-end processing of the platform is internationalized

    Nopath: indicates non mounted access

    VARCHAR
    tnameName of the physical template in error (full path under the report portlet)VARCHAR
    username

    The user who executes the template, and the platform front-end processing is internationalized

    Notlogged: no login access

    Fromschedule: scheduled scheduling

    VARCHAR
    ipIP address of the execution template (scheduled scheduling is empty)VARCHAR
    msgThe error information does not contain the specific error location, and basically matches the error code (for example, the cell loop does not display the specific cell)VARCHAR
    trace

    Error stack

    Length 1000 characters, exceeding truncation

    VARCHAR
    codeerror codeVARCHAR
    paraQuery parameters on errorVARCHAR
    result

    Preview successfully

    1: Preview succeeded

    0: preview failed

    BIGINT
    platfromDisplayDisplay levelBIGINT


    26. fine_config_operation delete behavior monitoring table

    Record grouping, business package, table, a ssociated delete operations

    This table is added in 5.1.12 and later versions.

    field name

    meaning

    Data Format

    uuid

    Unique identification field of the user

    VARCHAR

    time

    time

    Long

    user

    username

    VARCHAR

    resource_type

    Resource   types, including:

    Dashboard

    grouping

    business   package

    surface

    association

    VARCHAR

    operate_type

    Operation   type, currently only delete operations are recorded

    VARCHAR

    info

    Configuration   information, table name, business package name, group name, etc.

    VARCHAR

    thread_name

    thread   name

    VARCHAR


    27. Fine_relationship blood relationship analysis table

    Record bloodline data for the data table dashboard.

    This table is added in 5.1.14 and later versions.This table is empty by default. The contents of this table will appear only after the administrator performs synchronization data in the blood relationship analysis function of dashboard in Bi tools.

    field name

    meaning

    Data Format

    uuid

    Unique identification field of the user

    VARCHAR

    time

    time

    Long

    tableId

    Table   Name

    VARCHAR

    tableName

    escaped   name

    VARCHAR

    engine

    use   engine

    VARCHAR

    tableType

    Table   type:

    database

    sql

    server

    excel

    analysis

    confAnalysis

    VARCHAR

    creatorName

    table   creator

    VARCHAR

    childTable

    child   table name

    VARCHAR

    firstChild

    Is   it a direct child table

    0:   not a direct child table

    1:   is a direct child table

    Long

    dashboardName

    Dashboard   name

    VARCHAR

    dashboardId

    Dashboard   ID

    VARCHAR


    28. fine_intelli_honeypot instant buried point table

    field

    Field format

    definition

    uuid

    VARCHARUnique identification field of the user

    id

    VARCHAR

    Buried point ID

    time

    BIGINT

    log time

    addr

    VARCHAR

    ip

    userName

    VARCHAR

    Operation username

    tableId

    VARCHAR

    Action table ID

    comment

    VARCHAR

    Operation object escape name

    target

    VARCHAR

    Operation object

    tableName

    VARCHAR

    Action table name

    transferName

    VARCHAR

    Operation Notes

    describe

    VARCHAR

    parameter


    29. fine_intelli_log_honeypot log buried point table

    field

    meaning

    Field format

    uuidUnique identification field of the userVARCHAR

    id

    ID

    VARCHAR

    startTime

    Error log time

    BIGINT

    errorCode

    error code

    VARCHAR

    timetime recordingBIGINT


    30. fine_update_task update task table

    Note: For BI projects before 5.1.12, this part of the information can be viewed in LogDB .

          For BI projects of version 5.1.12 and later, this part of the information can be viewed in FineDB .

    field name

    meaning

    Remark

    type

    uuidUnique identification field of the user
    string

    planId

    The unique identifier of the task   instance, which is different for each run


    string

    taskName

    mission name

    Table   name + task type (single table/business package/global)

    string

    startTime

    task start time


    Long

    endTime

    task end time


    Long

    runningResult

    finished condition

    ALL:   All successful

    PART:   Partial success

    string

    state

    update status

    END:   has ended

    RUNNING:   run

    string

    triggerType

    Trigger method

    MANUAL:   Manual

    AUTO:   timing

    string

    roleId

    Trigger Id


    string

    roleName

    Trigger name


    string

    countOverView

    The update status of each type of   table in the task . JSON

    expectBaseTableUpdate expects the   number of base tables

    actualBaseTableUpdate the actual   number of base tables that were successfully updated

    expectComplexUpdate expected number of   bootstrap datasets

    actualComplexUpdate actual number of   successful bootstrap datasets

    expectRelationUpdate expected number   of association updates

    actualRelationUpdate actual number of   successful associations

    string

    extra1

    extra field 1


    string

    extra2

    extra field 2


    string

    extra3

    extra field 3


    string

    time

    Data insertion time, swift table   cleanup required


    Long


    31. fine_update_task_detail update task details

    Note: For BI projects before 5.1.6 , the information related to the update task is recorded in fine_DSGenerateFinishMap_SwiftTable (dataset update information temporary table) and fine_DSGenerate_SwiftTable (dataset update information table)

          For BI projects between 5.1.6 and 5.1.11, this part of the information can be viewed in the fine_update_task_detail (update task detail table) of LogDB .

          For BI projects of version 5.1.12 and later, this part of the information can be found in FineDB View in fine_update_task_detail (update task detail table) .

    field name

    meaning

    Remark

    type
    uuidUnique identification field of the user
    string

    planId

    The unique identifier of the task   instance, which is different for each run


    string

    loadId

    Detail ID, unique within an update   task


    Integer

    loadName

    name of detail

    The table is the table name + package   name, and the association is the associated information

    string

    loadType

    detail type

    BASE:   base table

    FAST,   ETL: Self-Service Datasets

    RELATION:   Relation

    string

    updateType

    update type

    FULL:   full amount

    INCREASE:   Increment

    string

    state

    update status

    LOADING:   Updating

    SUCCESS:   success

    PART_SUCCESS:   Partial success

    WAITING:   waiting in line

    WRONG:   failed

    string

    endTime

    Data update end time


    Long

    effectTime

    Effective time, really available


    Long

    startTime

    Update start time


    Long

    execption

    failure error message


    string

    failedSonId

    The set of IDs of the table whose   update failed due to the underlying table


    string

    extra1

    extra field 1


    string

    extra2

    extra field 2


    string

    extra3

    extra field 3


    string

    time

    Data insertion time, swift table   cleanup required


    Long

    fatherFailedIds

    The ID collection of the parent table   that failed to update


    string

    tableId

    extra fields


    string

    updateCount

    The number of rows changed, may   increase or decrease

    New   fields in version 5.1.10

    Long

    errorCode

    error   code

    New   fields in version 5.1.10

    Long

    totalCount

    total   number of rows

    New   fields in version 5.1.10

    Long

    deleteCount

    Increment and decrement the number of   rows

    New   fields in version 5.1.10

    Long

    writeTime

    file write time

    New   fields in version 5.1.10

    Long

    etlFlow

    Steps for Self-Service Datasets

    New   fields in version 5.1.10

    string

    appendCount

    Incremental number of rows

    New   fields in version 5.1.10

    Long

    columns

    List

    New   fields in version 5.1.10

    Long

    jdbcTime

    data acquisition time

    New   fields in version 5.1.10

    Long

    openTime

    sql execution time

    New   fields in version 5.1.10

    Long

    infos

    Non-error message (only   internationalized key values and parameters)

    New   fields in version 5.1.10

    string


    32. performAnalysis data structure

    Includes both dashboard and data preparation structures.

    Note: this table is currently disabled and no data will be written. To view the SQL statements related to the data table, please view them in the SQL performance monitoring of bi tools.

    field name

    meaning

    Remark

    type
    uuid

    an identifier that uniquely represents   the event


    String
    time

    Long

    type

    Category type

    enumerable numeric type

    0: Dashboard

    1: Data preparation

    Int

    user

    user name


    String

    startTime

    Starting time

    date format string

    Long

    endTime

    End Time

    date format string

    Long

    category

    Dashboard Name/Table Name


    String

    subCategory

    component name/step name


    String

    event



    String
    subevent

    String

    exclusiveDuration

    Exclusive time for this event

    number ( ms )


    dataSource

    Describe data source information

    string


    query

    SQL executed

    string


    row

    Rows

    number


    contentSize

    Occupied memory size

    Number (kb)


    exception

    exception information

    If there is any abnormal information,   please record it here to facilitate troubleshooting

    string


    additionalInfo

    extra information

    String (JSON parsable)


    event list

    event category

    event name

    event subname

    meaning

    dash board

    type: 0


     
     

    cache

    SpiderBaseCriteria

    SQL L3 cache

    GroupCacheProcedure

      CrossCacheProcedure

    Second level cache

    GroupPagingCacheProcedure 
      CrossPagingCacheProcedure

    Paging Level 1 Cache

    crossPage 
      groupPage

    paging

    makeTree

    2D table tree

    postGroup

    Grouping and summarizing again after   multiple indicators

    treeSort

    tree sorting

    multiTarget (Old)

    Multi-index calculation logic (old   engine) may split multiple SQL

    multiTarget (New)

    Multi-index calculation logic (new   engine) may split multiple SQL

    data preparation

    type:1

    previewData

    Preview of table data (non-editable)

    processResultData preview in autonomous dataset   editing
    getDataGet in-edit preview data for   autonomous datasets

    public event

    type: 0 or 1

    sqlQuery

    SQL data query

    excelQueryExcel data query
    excelQueryGet field information


    33. performAnalysis data structure

    This table is added in version 5.1.22 and later.

    Engine performance burying point requirements, burying point records of calculation time and other relevant information

    field

    meaning

    Field Type

    uuidUnique identification field of the userVARCHAR
    timeRecord timeBIGINT
    queryldQuery ID / IDVARCHAR
    start timestart timeBIGINT
    end timeend timeBIGINT
    engine Type

    Engine type

    1: Direct connection

    2: Draw

    INTEGER
    innerEngine TypeSubdivide internal engine typesINTEGER
    baseStartTimeStart time of basic calculationBIGINT
    baseEndTimeend time of basic calculationBIGINT
    dateModelColNumber of basic result columnsINTEGER
    dateModelRowNumber of basic result rowsINTEGER
    dateModelMemBase result memory footprintINTEGER
    peakMemoryMemory peak in calculation resultBIGINT
    cacheHitTypeCache hitINTEGER
    cacheCostCache processing timeBIGINT
    matchType

    Hit situation of some strategies

    0: indicates a miss

    1: Indicates a rule hit but an actual miss

    2: Indicates rule hit, actual hit

    INTEGER
    parseTimeParsing timeBIGINT
    mergeCostTime consumption of merge operation after concurrent calculationBIGINT
    tableldDataset IDVARCHAR
    widgetldComponent IDVARCHAR
    widgetType
    Component typeINTEGER
    dashboardldTemplate IDVARCHAR
    baseCriteriaBasic query informationVARCHAR
    extraExpand fieldVARCHAR
    executeType

    running state 

    0: success

    1: Error reporting

    INTEGER


    Attachment List


    Theme: Admin Guide
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ:800049425

    热线电话:400-811-8890转2

    总裁办24H投诉

    热线电话:173-1278-1526

    文 档反 馈

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    10s后关闭