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