Frequently Asked Question

Symptom

• When feeding components with more than a predefined number of rows, an alert message saying the limit of rows is reached for this component is displayed instead of the chart.
• The message displayed is "Maximum input lines allowed for this chart"

Environment

• Windows Server
• Need4Viz : all versions

Resolution

Each N4V component is limited to a specific number of rows as input. This limitation is done to avoid overloading of the component in the web browser. 

Indeed, unlike Webi's pagination mode (which only loads in the browser the rows displayed on the actual page), the N4V components embed all the input rows available in the bloc.

There is another limitation : Webi limit the number of rows to send to an external engine (N4V for example) to 50.000 rows, that's why you cannot send more than 50.000 rows to a N4V component, even if you define a greater limit with the following method.

To change/update the limit number of rows accepted by a N4V component, choose a method (A, B or C in the above list) and follow the steps on each N4V server :

A/ Update directly in the config.js file

1. Open the file ~Need4Viz\nodejs\node_modules\custom_element\ce_libs\config_charts.js
2. For each component, there is a setting named component_limit_lines that define the limit of rows accepted by the component
3. Find the corresponding component you want to update. For instance, to update the limit for the Pivot Table component, find the pivottable_limit_lines setting and change the value from 10.000 to the value you want (above 50.000)
4. Save the file
5. Open a PowerShell command window as local administror of the server
6. Run the Stop_Need4Viz.ps1 command in the ~Need4Viz/Scripts/ directory
7. Then run the Start_Need4Viz.ps1 command in the ~Need4Viz/Scripts/ directory.

B/ Update from the N4V Web Admin Portal

1. Connect to the N4V Web Admin Portal (for instance, if you are using the ports 8101-8113 for N4V, on your N4V server, open a browser and connect to the URL http://localhost:8101/admin)
2. On each tab (one for each N4V service), change the appropriate Row limit 

3. Update the new configuration on each tab :

   

4. Restart the N4V services : 

   

C/ Update the row limit on individual chart in your Webi report

Since N4V 2025.2 you can change directly on a specific chart in Webi the row limit for the current rendering :

You can go ahead of the global row limit defined for the component (just for this chart in your report, this change will not update the global row limit).

Once you have updated the row limit following method A, B or C, you can turn a Webi bloc with more than 10.000 rows into a Pivot Table, the component is correctly displayed.

Possible issue

Try to update progressively for each component the number of rows depending on your needs. The more the number of rows and column will be huge in the bloc, the higher will be the risk to overload the web browser of the user.

As a second issue possible, if you build a dashboard with many component in the same page and a huge number of rows/columns for each components, the web browser may be overloaded when trying to display the dashboard.