Issue when trying to merge an account

(0) Share

Report

Posted on by Community Member

Hi,

I need some help regarding merging an account on Dynamics CRM.

I'm keep getting a SQL Server timeout only when I tried to merge this one account whereas other account does not have the similar problem. I'm using an on premise version of CRM.

I've did noticed that everytime I've tried to merge this one account, I see multiple warning generated on the event viewer with some sql query inside which it seems not related to the account that I've tried to merge.

Maybe some expert advice would help as I'm still new to this Dynamics CRM.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

PS 23,577 on at

Like (2)

Report

Try this:

msdynamicscrmblog.wordpress.com/.../sql-generic-error-in-accounts-merge-and-contacts-merge-in-dynamics-crm-2011

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

Hi,

See the links below.

community.dynamics.com/.../190049

nishantrana.me/.../sql-server-timeout-expired-in-crm

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[quote user="Prashant Shukla"]

Prashant Shukla responded on 6 Feb 2017 9:09 PM

Try this:

msdynamicscrmblog.wordpress.com/.../sql-generic-error-in-accounts-merge-and-contacts-merge-in-dynamics-crm-2011

[/quote]

Hi Prashant,

thanks for your reply.

I've gone through the article and tried the SQL Profiler.

From there, I could see multiple lines of captured transaction happen pointed to CRM.

Any specific item that I should looked at which can pinpoint me to the right direction.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Prashant,

thanks for your reply.

I've gone through the article and tried the SQL Profiler.

From there, I could see multiple lines of captured transaction happen pointed to CRM.

Any specific item that I should looked at which can pinpoint me to the right direction.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply.

I think this is maybe an issue. The corporate account that I've tried to merge is having 99+ child account which all is a valid sub-company account that belong to this parent.

If this is the case, any work around to merge the duplicate. I'm thinking of deactivate the duplicate account if the master account is having all the information needed by the account owner.

regards

Was this reply helpful? Yes No