Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    thanks

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