SharePoint 2010 BDC Error: The system of the external content type cannot be accessed.
Recently, after importing some bdcm files, I was unable to create new forms based off of my new External Content Types. The error I received was;
The system of the external content type cannot be accessed. It is either removed from the Business Data Connectivity Metadata Store or you do not have the necessary permissions on that system.
I thought this was actually a permissions issue, so I went and Set Permissions to about as lenient as they could be but it was a no go. As it turns out, had modified the following namespaces:
- Entity Namespace
- SourceEntity Namespace
- DestinationEntity Namespace
- IdentifierEntityNamespace
- ForeignIdentifierEntityNamespace
to a malformed namespace. I replaced all the instances of my dev server's subsite with my production server's site collection but apparently, I needed to place a forward slash on the end: "https://sharepoint/" instead of just "https://sharepoint"
And really, this may be a newb error; I honestly don't know much about namespace syntax/formatting.