SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have external lists connected to a sql server database. Since the last day, some of the lists do not display data; the lists are empty, only headers are shown. (Some lists still display data, though.) But the database tables contain data. I have changed nothing about connection properties or permissions. Has anyone encountered this problem before?

share|improve this question
Does SQL Server Profiler show the requests being made to the database? Does ULS show any errors? – TZHX Dec 11 '12 at 15:45
And does running the command that the BCS sends give results? – TZHX Dec 11 '12 at 16:11
sql server profiler shows requests in all cases. – AGuyCalledGerald Dec 11 '12 at 16:22
Try refreshing their External Content Types, go through the steps of making External Content Type and data source again... This usually happens when a column is missing from the view/table! – Arsalan Adam Khatri Dec 11 '12 at 17:49

I had the same issue.

My first try was to create an additional Read List operation without the Wildcard filter.

I set that as default Read List operation, and created a list based on this. That worked, but my picker in for instance External Columns no longer had my wildcard filter.

I then sat my first Read List operation (with the wildcard filter) back to beeing default Read List op. Now they both worked ok.

In the end I found out I could just use default value of % on my wildcard filter. (This is for SQL Server)

share|improve this answer
up vote 0 down vote accepted

The problem was that I had a wildcard filter in the readlist operation of the external content type. Although it had "ignore filter" checked with null value and default value was "none". I am not sure why this does not work.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.