Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Goals not calculating

Posted on by 70

Hello!

I have a problem with my goals calculating. Previously everything was good and golas calculated during night every day. But 4 days ago this mechanism stoped. In system tasks view I had one stucked goal task so I canceled it. Inside I can see an error:

<OrganizationServiceFault xmlns:i="">www.w3.org/.../XMLSchema-instance" xmlns="">schemas.microsoft.com/.../Contracts">
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:d2p1="">schemas.datacontract.org/.../System.Collections.Generic" />
  <Message>Generic SQL error.</Message>
  <Timestamp>2020-06-17T23:05:33.5149642Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147220970</ErrorCode>
    <ErrorDetails xmlns:d3p1="">schemas.datacontract.org/.../System.Collections.Generic" />
    <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #704913FF</Message>
    <Timestamp>2020-06-17T23:05:33.5149642Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>

After this one I don't see any other errors but my goals not calculating automaticly. I calculated all of them manualy and everything was fine so seems is not a problem with data or goals config but some system problem.

Also I checked logs on app server and sql server but I found nothing disturbing.

So I have a questions:

1. Which mechanism is responsible of goals calculation? Is there any sql job or stored procedure or task or service?

2. How can I calculate all goals? Actually I can do it only clicking one by one.

3. Where should I start analysis of this problem?

I use CRM 2015 on-premise.

Thank you for your help, best regards

Pawel

  • Verified answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Goals not calculating

    Hi,

    Try restarting asyn service on the server.

    Calculating Goal is a background task and it will be processed by Async service.

    If found helpful, Please mark my answer verified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans