Question

Photo of Brandon Gamache

0

Certain Records are throwing Exceptions when trying to view

I have only noticed this with two so far but when trying to view the Profile page for a couple people I am getting this error. Any idea what value or field may be null so I can correct it in the database?

 

- NullReferenceException in App_Web_jkgko3ys

Message
Object reference not set to an instance of an object.

Stack Trace

   at ASP.blocks_crm_persondetail_bio_ascx.__DataBind__control5(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
   at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
   at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
   at System.Web.UI.WebControls.Repeater.DataBind()
   at RockWeb.Blocks.Crm.PersonDetail.Bio.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  • Photo of Rock RMS

    0

    This it appear likely to be when the profile page is trying to display the phone numbers for the person. If it happens again,can you confirm that each of the person's phone numbers is a valid phone number type ( from the 'Phone Type' defined type ). And, we'll update Rock to handle this without causing an exception.

     

    • Brandon Gamache

      Thanks. I did look at the phone type and there are only three mobile home and work. I accessed the edit page for one of the records that is having difficulty and the record has a mobile and work phone. Both are in the format of (555) 555-5555.

    • Brandon Gamache

      I got to looking at this again and it is an issue with the Phone Number Type. For the person records in the database that are having issues, there is a phone number record that has a null Phone Number Type (this happened during F1 conversion). Adding a new Defined Value of Other and applying it to the records that have the null field corrected the issue.

  • Photo of Jim Michael

    0

    Shooting from the hip, here, but it looks like the problem is in the bio section for a person, based on this

    at ASP.blocks_crm_persondetail_bio_ascx.__DataBind__control5(Object sender, EventArgs e)

    Have you done anything "custom" to that section?

    • Brandon Gamache

      Nothing custom to the bio section. I've added attributes and a liquid badge but that's it. I noticed it was in the bio section as well so I compared the person table to my own person record and the records look the same (just different person info). There has only been a couple records that have run into this issue so it isn't something that is affecting all person records. I have found that I can create a duplicate record and merge the error record into the new record and it loads fine after that.