Out of sort memory in Data Browser

Bug
4

Is that sufficient?

5

Hello @Jorg_Beyer,

yes, thank you.
I’ve created an internal ticket to fix this issue.

7

Hi again,

Could you try adding an index to the column name?

8

It already has an index

9

Do you have any sorting in the related table?

10

Sorry, for the late reply.
No, there is no sorting in the related table. Any sorting in the related table leads to the same error in that table, so I avoid sorting.

11

Any chance to have a deeper look into this topic?

Thanks, Joerg

12

Sorry for the long reply, we looking into it right now.

13

@Jorg_Beyer

I have tried to add relation after disabling all sorting in the related table - and it works as expected.

Could you please go to related table, and manually enable sorting for the first column, and after that disable it. It will help us to be sure, that there are no sorting in any other column.

Does error still appear after this actions?

Regards, Dima.

14

What do you mean by enabling/disabling sorting? I have manually done sorting by clicking on the sorting button of the column in the related table. And did that until no sorting.
The error still appears.

15

Enabled:
image
image

Disabled:
image

Go to StockMRQEvaluationData table and enable sorting for first column, and after that disable it.

After that try to add relation again.

16

That’s what I have done.

17

And as I understand the error still appear.

Ok, lets try to investigate what the difference between your and my cases.

Please do the next steps:

  1. go to the Idea table
  2. open browser devtools(F12 or Right Mouse Click → Inspect)
  3. Choose network tab(1)
  4. Clear all request using button(2)
  5. Try to add relations

And for every “find” request(3) repeat next:

  • choose payload tab(4)
  • Right Mouse Click on request payload(5)
  • Click “Copy object”
  • Paste it here

image
image1227×739 124 KB

18

Hi, the difference is, that my request contains a sort. But why?

image
image955×240 13.3 KB

I checked every single table - not only the related one, biut all tables - and disabled sorting.
But without any effect.

19

I can see that every table view of the related objects is by default sorted! I cannot disable sorting here.

image
image1708×922 72.5 KB

This must be set by the backendless. What do you think?

20

Hello @Jorg_Beyer

We have added an internal task to remove default sorting.

Regards

21

cannot await it. :wink:

22

How do I get the information when you have released this feature?

Regards, Joerg

23

Hi @Jorg_Beyer ,
We will additionally notify you in this topic that this bug has been fixed;
it is currently under development.

Regards,
Sergey

24

Hi @Jorg_Beyer,

We’ve just updated the cloud servers to fix the issue you described above. Could you kindly let us know whether the fix works for you?

Regards,
Bohdan

1 Like