Account form :: All Activities in Social Control Error RRS feed

  • Question

  • Maybe it's not the social control -- the one that hold activities and notes.

    Anyway, when an Account is opened I get a System.NullReferenceException (message in the downloaded ErrorDetails.)  Then when I change the Activities view to "In Progress" or "Overdue" it is fine, but upon changing it back to "All" the error pops again.

    A little more background:  This instance was just raised by importing a 2011 instance database in the deployment manager -- the Microsoft preferred method for upgrading.

    Is there some known solution?

    Wednesday, June 11, 2014 6:34 PM

All replies

  • some more information.  In another thread about Generic SQL Error I discussed a thread that directed me to the ActivityPointerBase table and fields ismapiprivate and leftvoicemail.  I mentioned that we found them renamed ismapiprivate_wrong and leftvoicemail_wrong.  Once we corrected them back the Generic SQL Error went away and we were able to complete the upgrade to 2013.

    On a hunch I'm looking at the contents of these fields:

    select ismapiprivate, leftvoicemail, count(*) k, min(createdon) earliest, max(createdon) latest
      FROM [CRM_MSCRM].[dbo].[ActivityPointerBase] group by ismapiprivate, leftvoicemail

    And I see

    ismapiprivate leftvoicemail k earliest latest
    NULL NULL 49264 2006-08-23 14:18:40.000 2014-01-31 17:49:19.000
    0 0 1626 2014-02-03 14:39:15.000 2014-06-11 19:22:11.000

    Is there anyone out there who can check their system to see if they have nulls, please.  I'm not liking the null values and the fact that they all end at once is suspicious.


    Wednesday, June 11, 2014 7:34 PM
  • I set them all to false and it made no difference.
    Thursday, June 12, 2014 2:52 PM