Difficulty: starter

Why are limitations in place?

Most system limitations 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 for example don’t want an user to be able to upload a massive file that clogs up available storage space.

Good to know, is that all limitation are in place to ensure an optimal end user experience!

Auto-fill

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

File size limitation for uploading data

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

File size limitation for downloading data

• No limitation to the 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), 1000 results can be are displayed. This amount can be changed via the client.maxRows setting.

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

• Reports can be used to display/ export more than 1,000 results

Reports/ includes

• Reports will show a maximum of 40,00 rows and no more than 800,000 cells. Whatever is reached first determined the limit. So, if you have more than 20 columns, this will result in having less than 40,000 rows.

Limits for exporting data

• Exporting a report: no limitation on the file size.

• Exporting report data:

  • Export to Excel: Same as the limitation of displaying data mentioned before.
    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 to limitation. 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 is 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 (e.g. requests) that can be queried is 120.000. This setting can be changed per object, but only on server level. When there are for example more 120,000 requests in an environment not all requests can be returned.

Workorder schedule

• Work order schedule generate a maximum of 300 work orders.

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 as much as possible.

• A maximum of 1,000 emails can be send on 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