List Collector

[Navyashree]

Hi All,

 I've a List collector variable in the catalog item which is referenced to a custom table. The table has 81K + records and it is required to load all the data for end users. Since it is trying to load lot of data, though it is working from ServicePortal without any issue and users are able to select the data and submit the form. When Support engineer try to open that RITM or SCTASK, getting an error "Information couldn't be downloaded from the server and the transaction has been cancelled". Can someone assist here please?

[Nilesh Pol]

@Navyashree Yes — this is a common performance issue when using List Collector variables in ServiceNow backed by large datasets (like your custom table with 81,000+ records). 

when support engineers open the RITM or SCTASK in the backend UI, it tries to load all selected values causing with a error.

Recommendations:

You should not load all 81K records unless absolutely necessary. Even if Portal can handle it, the backend UI will struggle. Use a Reference Qualifier to filter the list based on the some criteria's.

[Ankur Bawiskar]

@Navyashree 

For native the instance tries to fetch the data in 1 go and hence that issue is coming.

Things to try

1) Apply filter to reduce the records

Transaction error "Information couldn't be downloaded from the server because the transaction was ca... 

2) try to increase quota rules, OOTB 15 seconds is the time which is used to fetch list collector values but it might be failing here as data is huge

List Collector (slushbucket) opened from the All button on Affected CIs related list is timeing out 

3) try to add glide_list in the variable attributes so that it loads as Glide list in native and see if that helps 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Navyashree]

Hi Ankur & Nilesh,

 Thanks for your quick response.

1. I'm unable to apply any filter condition here as end users can select any record out of 81K and it is required to list all the data from the custom table.

2. Increase quota rules also may not be feasible as it'll be global change and may cause performance issues.

3. I've tried with glide_list variable attribute but no luck:(

 Please let me know if you've any other suggestions.

[Navyashree]

Adding to my response, I've set the some filter condition in script include and calling that script include in reference qualifier of List collector variable.