Dynamics Community Forum Thread Details

Goals not calculating

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

Quick Links