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

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
=========?

  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



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.
      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