locked
CRM 2011 - Goal Recalulate Doesn't Update Fields Every 24 Hours RRS feed

  • Question

  • Hi Forum,

    We have CRM 2011,UR 16 on-premise installation.

    Recently, we started to use Goal management functionality in CRM and hence imported some 100 goals for our sales people through Excel/Import process which was a success.

    For some reason, auto calculation of the goal progress is not working and we have to manually click "Recalculate" ribbon button to see the progress.

    In the System Settings I have checked the roll up frequency setting which is set to 24 hours under "Goals" tab.

    I have also checked the Async services (including maintenance) and they are working fine. (re-started as well).

    In further investigation, I also couldn't find the system job for this purpose. I can see rest of the system job like custom and system workflows but not anything for the goals.

    So just for the testing, I tried to change the roll up frequency to 48 hours from default 24 hours and to my surprise that threw the error and didn't save my change. In the downloaded error log it says:

    asyncoperation With Id = 4d1d25d5-8a71-4e31-bab5-d1866147e5db Does Not Exist

    I googled it but couldn't find any solution to this issue.

    Is there anyone out there who has encountered this type of behaviour.

    I have queried below and that returned 0 records.

    so it seems like that something is not right with Goal Async service but not sure how to fix it.

    Any help would appreciated. Thank you.

    -H.Desai

    SELECT [MessageName]      
          ,[OperationType]
          ,[RecurrencePattern]
          ,[Name]
          ,[PostponeUntil]      
          ,[RecurrenceStartTime]
          ,[StatusCode]
          ,[AsyncOperationId]
          ,[CorrelationUpdatedTime]
      FROM [XXXXXX_MSCRM].[dbo].[AsyncOperationBase]
     
      WHERE OperationType=40 (this is for Goal)


    • Edited by H.Desai Thursday, September 25, 2014 12:02 AM
    Tuesday, September 16, 2014 1:45 AM

All replies

  • Hi All,

    Just wondering if anyone has experienced this issue? I am still clueless.

    Thanks,

    H.Desai

    Thursday, September 18, 2014 1:05 AM
  • Hi All,

    Any expert out there on this issue ?

    Also, curious to know if this is happening due to the imported goal records rather than creating in CRM through UI?

    Thanks,

    H.Desai


    • Edited by H.Desai Friday, September 19, 2014 6:11 AM
    Friday, September 19, 2014 4:41 AM
  • Any one ?
    Thursday, September 25, 2014 12:00 AM