# Bug in 8.1.32 in table filtering if you have thousands of rows

**URL:** <https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [October 4, 2023, 11:11am UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012 "2023-10-04T11:11:31Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 4, 2023, 11:11am UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/1 "2023-10-04T11:11:31Z")

</div>

Hi all,  
in table component, filter feature is not okey when rows are more than about 2000

when I filter in a big table and filter result is more than 2000 rows,it shows connection to gateway is lost .

I just upgraded from 8.1.13 to 8.1.32 and noticed this ,Any advices ☹

[https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/9/d9b7ba3278a19135ee813e97bbb5ad452556358d.mp4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/9/d9b7ba3278a19135ee813e97bbb5ad452556358d.mp4)

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [October 4, 2023, 11:43am UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/2 "2023-10-04T11:43:46Z")

</div>

There seems to be more going on in this page then just filter.  
Does the same happen in a new view with just the table and nothing else?

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 4, 2023, 11:44am UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/3 "2023-10-04T11:44:26Z")

</div>

i will try and tell u

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [October 4, 2023, 11:56am UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/4 "2023-10-04T11:56:35Z")

</div>

seems like it

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/0/a0847ae349d5d5e8f5a5a26b8f9f42fbd4e10f8a.png)

seems like the text message size should be somewhere configurable though...

edit yes:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/b/4be669e90a26bffbd1ff910cf84ff3e1d67e22e4.png)  
Here in the ignition.conf setting something bigger here fixes it. Make sure your server can handle it though. it requires a server restart.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 4, 2023, 1:51pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/5 "2023-10-04T13:51:30Z")

</div>

[https://docs.inductiveautomation.com/display/DOC81/Perspective+Parameters#PerspectiveParameters-WebSocketMessageSize](https://docs.inductiveautomation.com/display/DOC81/Perspective+Parameters#PerspectiveParameters-WebSocketMessageSize)

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 4, 2023, 2:32pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/6 "2023-10-04T14:32:20Z")

</div>

I increased from 4000 to 16000 then restarted the server ,still same attitude.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 4, 2023, 2:34pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/7 "2023-10-04T14:34:30Z")

</div>

Victor provided an error message. Are you actually getting the same, or something different? Have you contacted support? What information can you provide about your problem besides "it doesn't work"?

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 4, 2023, 2:44pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/8 "2023-10-04T14:44:57Z")

</div>

Sorry, I am beginner here.  
Thanks for your support .

I received this message in wrapper log from diagnostic bundle

```auto
INFO | jvm 1 | 2023/10/04 17:40:58 | I [p.ClientSession] [14:40:58]: WebSocket disconnected from session. session-project=MegaMain
INFO | jvm 1 | 2023/10/04 17:40:58 | W [P.WebSocketChannel] [14:40:58]: Websocket connection closed unexpectedly. code=1009, reason=Text message too large: (actual) 2,100,675 > (configured max text message size) 2,097,152, codeMeaning=Message Too Big, codeDescription=The endpoint is terminating the connection because a data frame was received that is too large.  

```

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [October 4, 2023, 2:50pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/9 "2023-10-04T14:50:48Z")

</div>

The max here is still the same, it looks like the configuration change wasn't applied.  
How did you do it ? Maybe you made a mistake somewhere which made it not work ?

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 4, 2023, 3:00pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/10 "2023-10-04T15:00:57Z")

</div>

> [@pascal.fragnoud](#):
>
> figuration change wasn't applied.  
> How did you do it ? Maybe you made a mistake somewhere which made it not work ?

```auto
INFO | jvm 1 | 2023/10/04 17:57:58 | I [p.ClientSession] [14:57:58]: WebSocket disconnected from session. session-project=MegaMain
INFO | jvm 1 | 2023/10/04 17:57:58 | W [P.WebSocketChannel] [14:57:58]: Websocket connection closed unexpectedly. code=1009, reason=Text message too large: (actual) 2,105,327 > (configured max text message size) 2,097,152, codeMeaning=Message Too Big, codeDescription=The endpoint is terminating the connection because a data frame was received that is too large.  
INFO | jvm 1 | 2023/10/04 17:58:04 | I [p.ClientSession] [14:58:04]: Client re-synchronizing. protocol=re-sync-views, session-project=MegaMain

```

I changed value again from 16000 to be 4500 , but still the number is same.  
I just opened the ignition.conf file using notepad , changed value then saved and closed the service then opened.  
then restarted the server .

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [October 4, 2023, 3:16pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-1-32-in-table-filtering-if-you-have-thousands-of-rows/80012/11 "2023-10-04T15:16:32Z")

</div>

The settings to change is thé web socket message size mentioned by paul

[https://docs.inductiveautomation.com/display/DOC81/Perspective+Parameters#PerspectiveParameters-WebSocketMessageSize](https://docs.inductiveautomation.com/display/DOC81/Perspective+Parameters#PerspectiveParameters-WebSocketMessageSize)

Dperspective.websocket.max-message-size
