Data Source Limits

Data sources have specific limits to prevent Silk Central from getting into an unstable state due to excessive data generation.

Atomic vs. Non-Atomic Tests

For detailed information on the data-driven test types that are available in Silk Central, see Atomic and Non-Atomic Data-Driven Tests.

Limits

Data sources for data-driven tests have the following default limits:
  • 100 rows for non-atomic tests
  • 1000 rows for atomic tests
  • 20000 rows+cells for XLSX data sources (20000 is the amount of rows + the amount of cells. For example: If you have 3000 rows with 6 columns, the calculated amount is 3000 + (3000 * 6) = 21000, so the limit is exceeded.)
  • 220 characters for data set names (Excel sheet names/table names)
  • 220 characters for column key names
  • The concatenated length of all primary keys may not exceed 255 characters in length for JDBC, Excel, and CSV data sources
  • 2000 characters per cell (longer strings will be truncated). Note that data-driven Silk Test Classic tests only accept data source strings in quotation marks. If the string length in a cell exceeds 2000 characters, the string is truncated and the trailing quotation mark is missing, which leads to an error.

Modifying the Default Limits

The default limits can be modified, if required. Modify these values with care though to avoid excessive data generation. Before attempting to modify these values, stop the application server and restart it again after you have saved your changes.

The row limits for atomic and non-atomic tests can be configured in the TmAppServerHomeConf.xml file. The default path for this file is C:\Program Files (x86)\Silk\Silk Central 20.0\instance_<instance number>_<instance name>\Conf\AppServer on the application server. Modify the values of the Config/DataDriven/MaxRowsAtomic and Config/DataDriven/MaxRows XML tags, respectively.

The XLSX cell limit can be configured in the configuration.properties file in the Excel data source plugin (DS-Excel.zip). The default path for this file is C:\Program Files (x86)\Silk\Silk Central 20.0\instance_<instance number>_<instance name>\Plugins on the application server. Modify the value of the excel.importcelllimit property accordingly.