Sep.22

Dragan Todorovic 0 SharePoint

Database Connector has throttled the response. The response from database contains more than ‘2000’ rows – error on external list in SharePoint

Database Connector has throttled the response. The response from database contains more than ‘2000’ rows – error on external list in SharePoint

By default, SharePoint will try to fetch 2000 rows for external list, and in case you get this error, the only way is to increase default settings by simple Powershell command in a few easy steps.

Error:
Database Connector has throttled the response. The response from database contains more than ‘2000’ rows. The maximum number of rows that can be read through Database Connector is ‘2000’. The limit can be changed via the ‘Set-SPBusinessDataCatalogThrottleConfig’ cmdlet.

Solution:

  1. Log in to SharePoint server
  2. Start SharePoint Management Shell as administrator (right-click, run as administrator)
  3. Execute the following command: Get-SPServiceApplicationProxy
  4. Note the ID value for “Business Data Con” application
  5. Execute the following:  $serviceapp = Get-SPServiceApplicationProxy -Identity 9b2e386e-ffee-455f-a416-302ff0aed069 (replace identity ID with your value from previous step)
  6. Execute the following command:  Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $serviceapp | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000000 -Default 500000
  7. Restart IIS (iisreset /noforce)

 

May.26

Dragan Todorovic 0 Office365

Office 365 password expiration policy

Office 365 password expiration policy

If you’re a business admin, managing Office 365 may be only one of your functions in a long list of job duties, so keeping the experience simple is key. Fortunately, simplicity and efficiency go hand in hand with new and improved Office 365 admin options. End users don`t like password changes, and very often cannot understand all those security risks behind it. Password expiration policy is a part od service settings like anything else and could be modified in any time. By default, password expiration policy is set to 90 days, with user notification 14 days before expiration date. If you need to change those value, here are the steps:

  1. Log in to Office 365 administration
  2. Select “Service settings” from left menu
  3. Select “Password” page
  4. Update provided fields with new values
  5. Save