Layout exceeds rows limit

Navan Mehra
Navan Mehra Employee
Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board
in Platform

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

image.png

Answers

  • Julien CARDON
    Julien CARDON Customer
    Fourth Anniversary 100 Comments 25 Likes Board Advanced Developer
    edited March 11

    hello

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

    1. 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.
    2. 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
    Navan Mehra Employee
    Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board

    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.

Categories