Salesforce

WorldServer - How to display/load more than 1000 rows in any page (Projects, Tasks, Browser Workbench, Translation Memories, Users etc)

« Go Back

Information

 
Article TypeSolution Article
Scope/EnvironmentWorldServer
Symptoms/Context
When opening a project to view all the active tasks, if the project contains more that 1000 tasks/files, the message

Table is too big to be displayed as one page. Displaying 1,000 rows

is displayed at the bottom of the page. The user needs to select more than the 1,000 tasks available, but is unable to because of the error message and limit in place.

The same message may be displayed on other pages that contain more that 1000 records, including the number of segments in Browser Workbench.
 
Resolution
The reason for the default value of 1000 rows is to make sure that a page is loaded as quickly as possible. The higher the number of rows to be loaded, the longer it will take for the page to load them. If you apply the change below, please know that you might face a longer loading time.

There are 2 resolutions available

1. A temporary resolution is to change the view_all_page_row_limit through ws_gate. Note: in Worldserver version 11.x., this can only be applied in the Legacy UI and does not require a WorldServer restart. Follow these steps:
  • Open the project's page, resulting in this URL (example):http://myworldserver/ws-legacy/assignments_tasks?&token=1406998776&project=1209
  • Replace assignments_tasks through ws_gate and add &action=config&name=view_all_page_row_limit&value=1000 to the token. This is just an example if you want to set the number of rows to 1000. You can set them to 500 or any other number. Setting the number of rows too high might affect the page's performance/time to load.
  • The resulting URL will be http://myworldserver/ws-legacy/ws_gate?&token=1406998776&project=1209&action=config&name=view_all_page_row_limit&value=1000
  • Click enter
  • A foo.xml file will be generated in Firefox/Chrome or a page will display in Internet Explorer.
  • Open it. The change should be confirmed as follows:
<?xml version="1.0" encoding="UTF-8"?>
<result msgs="page_row_limit=1000" error="OK"/>

The change has been applied and will remain active until the next Idiom restart. After the Idiom restart, the setting from general.properties will be applied.

2. For a more permanent change, modify the below entry in general.properties to the number needed for a more permanent change:

view_all_page_row_limit=1000

to - for instance:

view_all_page_row_limit=2000

After the value has been updated, save the general.properties file and restart the Idiom service on the server where WorldServer is installed.

Be aware that increasing the value might result in a longer page loading time and possible performance issues.
Root Cause
The property view_all_page_row_limit in the general.properties file is defaulted at 1,000 and that is the limit of rows (for instance, tasks) that are able to be displayed.
Reference
Attachment 1 
Attachment 2 
Attachment 3 
Attachment 4 
Attachment 5 

Powered by