skip to main content
Using Hybrid Data Pipeline : Using the Web UI : Manage Limits view
  

Try Now

Manage Limits view

The Manage Limits view allows you to view and set limits for features such as throttling and logging.
In the Manage Limits view, limits can be set at either the system or tenant level. System limits apply to behavior across Hybrid Data Pipeline and override default behavior, while tenant limits apply to the resources of a given tenant and override default behavior and system limits. Most limits can only be configured at the system level. However, some limits, such as MaxFetchRows and MaxConcurrentQueries, can be configured at any level.
Note: Limits can also be specified for users and data sources. User limits can be set either through the Manage Users view or the Limits API. User limits override default, system, and tenant limits. Data source limits can only be set via the Limits API. Data source limits override all other limits.
The Manage Limits view is available to users with either set of the following permissions.
*Administrator (12) permission
*WebUI (8) permission, Limits (27) permission, and administrative access on the given tenant
system limits viewsystem limits view
The table below provides descriptions for limits that may be set via the Manage Limits view.
Note:
*Throttling limits can be set either for the system tenant or any child tenant across the system.
*Log Management, Data Usage Meter, and Security limits can only be set for the system.
*To set system limits, the system tenant must be selected from the Tenant dropdown. The user must have the Administrator (12) permission.
*To set tenant limits, the child tenant must be selected from the Tenant dropdown. The user must have either the Administrator (12) permission, or WebUI (8), Limits (27) permissions, and administrative access on the given tenant.
*Tenant limits can also be set via the Manage Tenants view.
Category
Limit
Description
Throttling
MaxFetchRows
Maximum number of rows allowed to be fetched for a single query.
Throttling
ODataMaxConcurrentQueries
Maximum number of concurrent active OData queries per data source.
Throttling
TransactionTimeout
The number of seconds the system allows a transaction to be idle before rolling it back.
Throttling
XdbcMaxResponse
Approximate maximum size of JDBC/ODBC HTTP result data in KB.
Log Management
LogRetentionDays
Number of days log files should be retained.
Log Management
MonitorRetentionDays
Number of days monitor details should be retained
Data Usage Meter
UserMeterRetentionDays
Number of days user meter details should be retained
Data Usage Meter
UserMeterWriteInterval
The number of seconds the system waits before scanning sessions for current metrics. A lower setting will result in more rows written to the meter table
Data Usage Meter
UserMeterMaxAge
The number seconds the system waits before writing out meter records. A lower setting will result in the rows written to meter table to occur more frequently
Security
PasswordLockoutInterval
The duration, in seconds, for counting the number of consecutive failed authentication attempts.
Security
PasswordLockoutLimit
The number of consecutive failed authentication attempts that are allowed before locking the user account.
Security
PasswordLockoutPeriod
The duration, in seconds, for which a user account will not be allowed to authenticate to the system when the PasswordLockoutLimit is reached.
Security
OAuthAccessTokenDuration
The duration, in minutes, for which a Access token is valid.
Security
OAuthAccessTokenCacheSize
Number of oauth access tokens to be cached in memory for OAuth Authentication. By default up to 2000 tokens will be cached in memory.
Security
CORSBehavior
Configuration parameter for CORS behavior. Setting the value to 0 disables the CORS filter. Setting the value to 1 enables the CORS filter. Setting the value to 2 enables the CORS filter with the whitelist option.