Error: Invalid or unsupported credentials. Please contact your administrator or Credentials was not found for the current user within the target application. Please set the credentials for the current user

If you face this error on deploying external content types in SharePoint or if you faced one of below error on creating external lists.

Invalid or unsupported credentials. Please contact your administrator

Credentials was not found for the current user within the target application. Please set the credentials for the current user

Resolution 1 

            At first you have to double check that you set credentials for secured store target application, go to central administration -> application management -> manage service applications -> select your target secure store application, in my case it is SAMAIntranetSSApp.

Figure 1

      Enter database user and password, and credentials manager in case of individual application type.

Figure 2

Resolution 2

This error may be caused from application type, individual type for secure store application works in standalone environment (One server), and if you are working with farms that consists of apps and front-end servers then you have to consider creating secure store application with Group type.

In below figure, the application will be created with “Group” application type instead of Individual to resolve the problem, once you selected group as application type then none will be selected as target application page URL.

Figure 3

You can set hints for type of username and password that should be entered and click Next,

Figure 5

Check your target secure store application and click on set

Figure 6

Enter credentials required to access external data source.

Figure 7

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

Resolution 1

You can set filter parameters to your external content type as below figure.

Figure 8

Resolution 2

By default 2,000 with a maximum of 1,000,000 items if using Visual Studio so you can change the default values using the commands below. In this example we have increase the default limit to 20,000 items and maximum

 $bcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs

Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000