Configuring the Amount of Data in Workflow Results – Revvity Signals

Date Posted: 2018-01-23
Product: TIBCO Spotfire®

Problem:

Configuring the Amount of Data in Workflow Results

Solution:

Configuring the Amount of Data in Workflow Results

Configuring the Amount of Data in Workflow Results

Application Administrator role required.

Displaying many output rows in your web browser could slow down or even freeze your web browser. To keep that from happening, we have a limit on the amount of data that appears in workflow results. This limit is configurable. In general, if you produce large workflows with lots of operators, then you should keep these limits small, in order to keep the total results size for a workflow within reasonable bounds. If you typically have small workflows and want to see more results for a single operator, then you can increase them.

Note: This configuration is system-wide and affects all users. Exercise caution when changing these values.

UI Preferences

To edit this value, navigate to the Actions menu from within a workflow. Select the 'UI' section and edit the value for 'Data Preview Max Rows' (see the attached screenshot).

There is an upper limit on what this value can be. It is defined in the alpine.conf file associated with your installation.

Note: The value entered in 'Data Preview Max Rows' will only be applied if it is less than the upper limit defined in alpine.conf.

alpine.conf Values

Navigate to the ALPINE_DATA_REPOSITORY/configuration/ directory and find alpine.conf.

alpine {
  operators {
    # limit for touchpoints
    max_row_num = 100

    # limit for display rows in result console, since release 5.4.
    max_ser_rows = 25

    # limit for the number of columns to display in the results console
    # currently only applies to output of hadoop operators
    max_column_num = 500
   ...
  }
  ui {
    ...
    max_cell_size = 512
    ...
  }
}

We use the value max_ser_rows to determine how many rows will show in the results console. For Touchpoints, we use the value for max_rom_num.

Limiting Preview Data in the Results Console

If you want 50 rows to appear in the results console, you will need to set alpine.operators.max_ser_rows to at least 50 then set the value in the UI Preferences window to 50. The maximum value is 300.

Limiting Preview Data in Touchpoints

For 100 rows to appear in the results console for Touchpoints, you will need to ensure that alpine.operators.max_row_num is at least 100. This value is set to 100 by default, so you probably do not need to change this. You will also need to update the value in the UI Preferences window to 100.

Maximum Cell Size for Result Tables

alpine.ui.max_cell_size is used to limit the amount of data that appears in any single cell of a table in operator results, with a default of 512 characters.

Related articles