Layout exceeds rows limit

Navan Mehra · 2025-03-11T07:14:01+00:00

There was an error rendering this rich post.

All,

I have a layout with 12 blocks. It is an algorithm block that is causing an error.

a. Text Block

b. MID(a,2, 30)

It is the block with the MID formula causing an issue. When the algorithm block is marked as numeric, the layout works fine and shows 0 in the column. But when it is changed to Text, I get the below error.

If it was really an error due to exceeding number of rows, we should get the error irrespective of what Algorithm block is marked. Do we know if this is a known issue or anyone encountered this earlier

Board 14.2. 1.1.282551

Find more posts tagged with

Accepted answers

All comments

Julien CARDON

hello

I don't think it's a bug, it's a new setup introduced in 14.2 to prevent web server failure

You need to check the log at info level, you will find the exact nb of rows / cells for each block so you can see nb of rows generated by the query and test different options.
With a numeric algo, it will only work on non empty members that may explain why it works while text algo will work on all member combinations that you have in rows (including empty combinations)

you can increase this setting in your server config file if you don't find any alternative

regards

julien

Navan Mehra

Thanks. This is a case of an upgrade from B10 to B12. This layout in B10 has 2 more blocks and works perfectly but causes issue with B14. I will check the logs in details.