Home

Column 'ItemChildCount' does not exist on an External List

Highlighted
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
Highlighted
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
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
9 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
How to count multiple values in a cell
Ugarte335 in Excel on
7 Replies
Count until
MBelshaw in Excel on
1 Replies