Dynamics 365 Business Central and Search timeout

Are you using Dynamics 365 Business Central on-premise and are you obtaining this error message when searching on a list?

This is because your applied filters are returning a query result set with a too long execution time.

With Dynamics 365 Business Central on-premise there’s a “not so well known” setting on the Database tab in the Business Central Server Administration tool called SearchTimeout.

This setting specifies the time (in seconds) that a search operation on lists in the client will continue until it is terminated. When the limit is reached, the message you can see in the above picture is displayed in the client.

If needed, in the on-premise world you can increase this limit (via Server Administration or directly from Powershell) and in this way you can enable longest queries. Not so recommended, but sometimes it could be useful to change it.

2 Comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.