Cannot create marking.The number of selected items exceed the marking limit for external data

Cannot create marking.The number of selected items exceed the marking limit for external data

book

Article ID: KB0075753

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

By default for any in-database connection the default marking limit is to 1000 and you would receive the below error if you mark more than 1000 rows
=========
Cannot create marking.The number of selected items exceed the marking limit for external data
=========​

 

Issue/Introduction

Cannot create marking.The number of selected items exceed the marking limit for external data

Environment

All Supported Windows OS

Resolution

To update the default value -
1) Go to Tools -> Administration Manager and click on the Preferences tab.
2) For the user/group , that you would like to update the default value ,select the DataOptimization category and click edit
3) Set a value for the MarkingInQueryLimit and MarkingWhereClauseLimit, e.g., to 20000

User-added image

NOTE- Updating this value may also impact the performance

Description of preferences from the manual

MarkingInQueryLimit - Limit applicable for queries within a single column. Specifies the limit for how large queries should be allowed when marking or transferring markings or filterings between related tables. The default is 15000.
MarkingWhereClauseLimit - Limit applicable for queries involving multiple columns. Specifies the limit for how large queries should be allowed when marking or transferring markings or filterings between related tables. Default is 1000.
     

Additional Information

https://docs.tibco.com/pub/sfire-analyst/10.3.3/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_working_with_large_data_volumes.htm&rhsearch=MarkingInQueryLimit&rhhlterm=MarkingInQueryLimit&rhsyns=%20