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) Pl...
"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.
I know that External Lists themselves cannot have Lookup columns, though I'm unsure about a normal List using a lookup to an EL.
- Yes, it does have stack trace but it is not immediately useful either. I will post it later on today. If you've a lab, just testing the scenario would be fast, and I appreciate it if you do. Like I said two completely different farms shown this behavior, so I am hesitant to say something is 'broken' with the farms, but may be something undocumented going on.
- Stack traces are usually where I start bug hunting through reflection, so they can be immensely helpful. I can certainly lab this, though. Stack trace is just a useful pointer :-)
I get it. Here we go;
Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() at Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) at Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) at Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) at Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) at Microsoft.SharePoint.SPFieldCollection.Add(SPField field) at Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() at Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)