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