Home

Column 'ItemChildCount' does not exist on an External List

davidcopp
Occasional Visitor

A rather strange change has occurred within one tenancy in SharePoint Online. All external lists connected to an Azure SQL database are returning the same error message "Column 'ItemChildCount' does not exist. It may have been deleted by another user."

 

The same external content type is set up in another tenancy and is being consumed without any problems. I've tried recreating the content type and the list in both the current site and another site within the tenancy, but the problem reoccurs.

 

All of these lists where previously working and no changes have been made to either the content types, connection, secure store or underlying data structure within SQL.

 

Any ideas?

1 Reply
Best you can do here is to open a support ticket. It seems something is wrong with that tenant and the BCS Service
Related Conversations
How to count multiple values in a cell
Ugarte335 in Excel on
7 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies