Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 15 Next »

Difficulty: starter

Content

Learning Objectives

After reading this article you will be able to:

  • take into account and configure (some of the) system boundaries

Why are boundaries in place?

Most system boundaries are in place for performance or security considerations. A process might for example be stopped automatically after 1 or 2 minutes to prevent this process causing an issue because an infinite loop was entered. Limits regarding file size are in place for data size management. You don’t want one user to be able to upload a massive file that clogs up available storage space.

All boundaries are in place to ensure an optimal end user experience!

Auto-fill

  • Some fields in Workplace use the auto-fill functionality. This means that after entering 3 or 4 characters, Workplace returns result suggestions in a scrollable list. By default a maximum of 50 results are returned. On client level this number can be lowered, 50 results is the system maximum.

Limitation for uploading data

  • The default maximum file upload size is 32MB. This can be (temporarily) increased to a maximum of 2GB via the client settings. In the navigation menu press: Admin > Setup > “Documents” tab > Maximum upload size MB.

  • For webservice other limitations are in place. A document uploaded via a webservice can be 4 MB maximum.

Limitation for downloading data

  • No limitation to the maximum download size. All files that are uploaded can also be downloaded.

  • 200 files can be exported from a list page in one download action.

Limits for displaying data

Standard and advanced search results

  • When executing a standard or advanced search (for example search properties or requests in the navigation menu), 1000 results are displayed. This amount can be changed via the client.maxRows setting.

    • Its advised not to change this because of performance reasons.

  • Reports are used to display/ export queries of more than 1,000 results.

Reports/ includes

  • Reports will show a maximum of 40,000 rows and no more than 800,000 cells. Whatever is reached first determined the limit.

  • Henceforth, if you have 21 columns in a report, you can have a maximum of (800,000/21)= 38,095 rows.

Limits for exporting data

  • The system default is 32 Mb for exporting data or documents. This cannot be changed in the client settings.

  • Exporting report data:

    • Export to Excel: no additional limitation on top of the 40,000 rows/800,000 cells.
      Excel also has limitations. There is a maximum number of character one cell can contain (d.d. 2022-10-01 this is is 32,767 characters) and a maximum number of rows and columns. For current limitation please consult the Microsoft support page.

    • Export to CSV: 40,000 lines and 800,000 cells (whatever is reached first determined the limit)

      • Note: when using an integration export connector you can choose the file format ‘CSV dump’. For this file format there are no limitations concerning rows and cells. However, technical restrictions apply. Meaning that formulas and the pagefield settings like “export yes/ no“ are ignored.

Timeout

Depending on the process, one of the following timeouts is applicable.

  • 1 minute timeout (e.g. loading includes and executing function button)

  • 2 minute timeout

  • 10 minute timeout

  • 30 minutes (e.g. planning scripts)

When a timeout occurs, Workplace will show a timeout error or a general system error. Unfortunately, there is no one specific reason as to why a timeout occurs. More experienced consultants will learn to recognize and debug timeouts. For more complex debugging the help of our Developers might even be required. Some tips:

  1. Retry what you where trying to do.

  2. If the timeout occurs when executing a query (run a report/ include), refine your search.

MaxFind

  • The default number of objects that can be queried is 120,000. This setting can be changed per object, but only on server level. This means that when you have 130,000 REQs in your environment, 10,000 REQs are not included in the query.

Workorder schedule

  • Work order schedules generate a maximum of 300 work orders. This is a server setting.

Non-production servers: test and backup servers

  • Lower performance levels compared to our production servers.

  • These servers do not have a guaranties uptime/ availability. Nonetheless, we do our best to have them available at all time.

  • A maximum of 1,000 emails can be send on a non-production server since a server was rebooted (e.g. after a release). This email counter is reset when restarting the server. This maximum can only be increased via a server setting by Workplace Development.

Summary

Exercise

  • N/A

Search

  • No labels