About Dragan Todorovic

Senior Consultant for SharePoint & O365 services with more than 8 years of experience. Fan of web technologies and cloud services.

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)

 

How to connect to SharePoint Online from Power Shell?

Install-Module -Name Microsoft.Online.SharePoint.PowerShell

$adminUPN=”dragan@company.onmicrosoft.com”

$orgName=”company”

$userCredential = Get-Credential -UserName $adminUPN -Message “Type the password.”

Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential

How to setup Shared mailbox from Exchange Online on Android mail client?

First of all, it will be IMAP connection, don`t try to use wizards for Exchange or Office 365, simply it won`t work.

  1. Open you mail client and select IMAP as account type
  2. For “E-mail adress” field use you shared e-mail address. Username should be you main address\shared (eg. info@company.com\dragan.todorovic). For Password simply enter you main address password.
  3. IMAP server: outlook.office365.com, Port: 993, Type: SSL\TLS (Accept all certificates)
  4. SMTP: smtp.office365.com, Port: 587, Type: STARTTLS (Accept all certificates)
  5. Check “Require Sign-In
  6. For username set your main email account (eg. info@company.com) and password for this account
  7. Confirm!

Push declined due to email privacy restrictions error for GitHub sync in Visual Studio Code

If you have experienced Visual Studio Code at least for simple script editing and tried to connect to GitHub as source control, probably you had a problem with sync because of this error in log output:

remote rejected] master -> master (push declined due to email privacy restrictions)

Fix: Simply uncheck “Block command line pushes that expose my email” box in your email settings and then pushing again.

“Save as site template” option is missing in SharePoint Online

As you probably know, once the publishing feature is activated the ‘Save site as a template‘ option will be unavailable in Site Settings. If you try to disable the feture it won`t resolve the problem, since onlu one activation will change the settings for all sites. However, there is a workaround as described below:

First ty to navigate directly to http://yoursite/_layouts/15/savetmpl.aspx  and you will get the form for creating template. Simply fill in the form and you`re done.

If you get some error, then you need to connect to SharePoint Online via powershell first, and execute the following commands:

 

$web = Get-SPWeb http://your_ site
$web.AllProperties[“SaveSiteAsTemplateEnabled”] = “true”
$web.Update()

 

then try to access above URL again!

SharePoint Designer 2010 cannot display the item

If you face the problem with “SharePoint Designer cannot display the item” in SharePoint Designer 2010, proceed with the following steps;

  1. On the local computer, browse to the following folder:
    • C:\Users\<Replace Your User Name>\AppData\Local\Microsoft\WebsiteCache
    • Example: C:\Users\mark.lee.contoso\AppData\Local\Microsoft\WebsiteCache
  2. Delete everything in WebsiteCache folder.
  3. On the local computer, browse to the following folder:
    • C:\Users\<Replace Your User Name>\AppData\Roaming\Microsoft\SharePoint Designer\ProxyAssemblyCache
    • Example: C:\Users\mark.lee.contoso\AppData\Roaming\Microsoft\SharePoint Designer\ProxyAssemblyCache
  4. Delete everything in ProxyAssemblyCache folder.
  5. Done.
  6. Open SharePoint Designer 2013

Save Sent Items in Shared Mailbox Sent Items folder on Exchange Online

When you send a message from the shared mailbox, the sent message goes into your own Sent Items folder. By default, sent messages are stored in your own mailbox, not the shared mailbox. Previously, the solution was to edit DelegateSentItemsStyle registry value but most of end-users cannot complete this request or even create more problems. Now, there is an update, allowing customers to setup this option very easily.

You should access Office 365 tenant area and select the shared mailbox you wish to edit. Simply enable the following options: