Regarding Slowness Issue for MRVS

VenkataAviM
Tera Contributor

Hello Everyone,


I am experiencing a performance issue with the Multi-Row Variable Set (MRVS) functionality. Specifically, when I click on the Add button to insert a new row, the system takes an unusually long time to load and respond. This delay is impacting the overall user experience and workflow efficiency. Could someone please assist in identifying the root cause and suggest possible solutions or optimizations to resolve this issue?

 

PFA the snapshot.

8 REPLIES 8

@VenkataAviM 

when you deactivate all client scripts and UI policies how it behaves?

Also how many variables you have in MRVS? seems that's causing slowness

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi @Ankur Bawiskar 

When i have deactivated all Client Scripts and UI Policies still it is behaving the same. 

We have total 19 variables inside the MRVS including different datatypes for the variables such as References, Lookup Select Boxes, Single Line Texts and Date Types.

@VenkataAviM 

I think it's because of 19 variables.

But now I am not sure any ref qualifier is applied on that etc

so you need to debug from your side.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Kajal_19
Tera Contributor

@VenkataAviM ,

 

I have faced same issue in one of my implementation. I have raised Hi case

1. it's basically occurred when there are many variables with Reference or Lookup Select box  which contains large table data

2. please check if there are any variables which are inactive and Reference or Lookup Select box type in your variable set remove variable sets name form those variables

3. Use advanced reference qualifier for Reference and Lookup Select box type variable. so number of records will be reduced

 

Below is the response form ServiceNow Team:=======


After further investigation, we believe this issue is a defect as we can also replicate this behavior in our own test instances.
What happened is that the Multirow variable set is evaluating these three Lookup Select Box Variables, even though they are not active:

These Variables are referencing very large tables, hence why you are seeing this performance issue.
I will provide steps for relief, but please do not close this case yet as I need internal teams to create a PRB for this issue for our documentation.

RELIEF:
1) Open below URL to access the Lookup Select Box variables that are part of the MRVS:

2) Remove the values for 'Variable set' for these records
3) Try to add the row to the Multi Row Variable Set, and this should now be near-instance

I will provide you further updates once our internal team reviews this behavior.

 

 

 

 

Please mark as correct if you find any help 

Thanks,

Kajal