A SQL Server error occurred.

(0) Share

Report

Posted on by Community Member

This week we started to get this exception when we Workflow tries to send email. When I looked at the Event Log on CRM Server I found this type of errors

However, I am not sure what might be the problem and how I can resolve it. I am new to CRM troubleshooting.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Can you check what happens if you run the query inside of SQL Server Management Studio?

Does it still take that long?

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

Hi,

You can troubleshoot sql error using sql profiler, that should help you fine what causing this, check this for detailed steps: blogs.msdn.microsoft.com/.../create-a-crm-profiler-template-and-trace-for-crm-issues

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For some reason, I cannot run this query as is. The problem is that there is where condition that had constant variables instead of the real value. For instance, Closed instead 3 and so on.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have narrowed down the problem. Here what I have found out:

We have workflow that run 4 child workflows depend on the condition.

Each child workflow is the same

At the end of the process workflow sends email using template. Although the email templates for each workflow are different but main structure is the same.

One of the field is used to present the data is Invoice.Desctription which is multiline text.

This field's result is 2 tables and it works for 3 child templates. It doesn't work only for one of them. Once I removed this field from the email template, workflow started to work without problem.

Logically it looks like this field is filled up on the fly when value is used by email template. I am not sure how and why it works for other emails.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I found the issue. It is not related to the database or workflow.

So, the ticket can be closed.

Thanks everyone who helped me.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report

Hi Pavel,

Can you share the resolution so that it can help other community members in the future?

Thank you.

Was this reply helpful? Yes No