Forum Discussion
Is this a bug? Look up column to External List error - SP2016
Hello folks - I am trying to find out if this is a bug with the product, or an issue with my farm. So, I wanted to reach out to the community to get help on something tested. (SharePoint 2016)
Please consider this scenario. I've this tested on both on-premise farms and results are same.
Prerequisites:
- Make sure to have a BCS External Content Type to a SQL database of your choice
- Make sure to create an External List using this ECT to the said SQL database
Steps:
- Browse to Site Columns on a site collection (Same site collection that external list is on)
- Create a new site column, select type Lookup - Give a good name that you can remember
- Select "Get information from: " drop down to the External List you've already created, and select a column
- Hit "OK"
Questions:
- Do you get an error?
- If you browse back to Site Columns do you see the column actually created but type is listed as "External Data" ?
Please let me know your findings here. Thanks!
Ali
9 Replies
- What error are you seeing (in ULS logs if applicable)?
- "Object reference not set to an instance of an object" - What I see. Nothing helpful, as always.
- You should have a complete stack trace with that. Would be happy to t-shoot it but it'll take me some time to replicate the whole BCS/ECT/etc stuff.
I know that External Lists themselves cannot have Lookup columns, though I'm unsure about a normal List using a lookup to an EL.
