Question Status

Suggested Answer
Diane Kelley asked a question on 12 Jan 2012 7:12 AM

After selecting Settings & Templates,  I click on Email Templates and receive Error Message - Try Again.  All the other templates work but Email.  Can anyone help?

Reply
Matthew Martin responded on 27 Feb 2012 8:31 AM

I have exactly the same issue. No idea what the cause is. No one on teh system can access email templates.

Reply
Gus Gonzalez responded on 27 Feb 2012 1:07 PM

Diane,

Is this on CRM 2011?

Online or OnPrem?

Gus Gonzalez

Dad, Husband, Engineer, 3-time Microsoft MVP, Solution Architect,  Subject Matter Expert, Speaker, Columnist  Georgia Chapter Chairman. Follow me @GusGonzalez2.

Reply
Matthew Martin responded on 28 Feb 2012 8:17 AM

It is on OnPrem.

Reply
Christ Lee responded on 18 Mar 2012 9:49 PM

I have the exactly same errors, is there no one know what's going wrong ?

Reply
Gus Gonzalez responded on 18 Mar 2012 10:14 PM

What UR do you have installed Matthew?

Gus Gonzalez

Dad, Husband, Engineer, 3-time Microsoft MVP, Solution Architect,  Subject Matter Expert, Speaker, Columnist  Georgia Chapter Chairman. Follow me @GusGonzalez2.

Reply
Matthew Martin responded on 20 Mar 2012 2:01 AM

We have recently installed UR 6, but this did not solve the issue.

It is a big problem. No one can use e-mail templates.

Reply
Suggested Answer
Jebin T. Blessed responded on 4 Nov 2013 2:51 AM

Use this below stored procedure & delete query to solve this issue, picked from below link.

dynamicsuser.net/.../47282.aspx

Reply
Suggested Answer
Jebin T. Blessed responded on 4 Nov 2013 2:52 AM

sp_executesql

N'select

top 5001 "savedquery0".IsDefault as "isdefault"

, "savedquery0".IsQuickFindQuery as "isquickfindquery"

, "savedquery0".SavedQueryId as "savedqueryid"

, coalesce("LL0".Label,"savedquery0".Name ) as "name"

from

SavedQuery as "savedquery0"

left outer join LocalizedLabelView as "LL0" on ("LL0".ObjectId = "savedquery0".SavedQueryId and "LL0".LanguageId = 1033 and "LL0".ObjectColumnName=''Name'' )

where

(("savedquery0".StateCode = @StateCode0 and "savedquery0".ReturnedTypeCode = @ReturnedTypeCode0 and ("savedquery0".QueryType in (@QueryType0

, @QueryType1)))) order by

name asc

, "savedquery0".SavedQueryId asc'

,N'@StateCode0 int,@ReturnedTypeCode0 int,@QueryType0 int,@QueryType1 int',@StateCode0=0,@ReturnedTypeCode0=2010,@QueryType0=0,@QueryType1=

4

-- delete from SavedQueryBase where SavedQueryId='ENTER THE SAVED QUERY ID HERE'

Reply
AFTAB HUSSAIN responded on 2 Jan 2014 3:28 PM

Hello Diane,

Are you still facing this issue. Which update rollup are you on.

I would suggest you to be on latest update rollup if possible and see if this issue occurs.

Also if there is any more information regarding the issue then please share with us.

Thank You !

Reply
Suggested Answer
Jebin T. Blessed responded on 4 Nov 2013 2:51 AM

Use this below stored procedure & delete query to solve this issue, picked from below link.

dynamicsuser.net/.../47282.aspx

Reply
Suggested Answer
Jebin T. Blessed responded on 4 Nov 2013 2:52 AM

sp_executesql

N'select

top 5001 "savedquery0".IsDefault as "isdefault"

, "savedquery0".IsQuickFindQuery as "isquickfindquery"

, "savedquery0".SavedQueryId as "savedqueryid"

, coalesce("LL0".Label,"savedquery0".Name ) as "name"

from

SavedQuery as "savedquery0"

left outer join LocalizedLabelView as "LL0" on ("LL0".ObjectId = "savedquery0".SavedQueryId and "LL0".LanguageId = 1033 and "LL0".ObjectColumnName=''Name'' )

where

(("savedquery0".StateCode = @StateCode0 and "savedquery0".ReturnedTypeCode = @ReturnedTypeCode0 and ("savedquery0".QueryType in (@QueryType0

, @QueryType1)))) order by

name asc

, "savedquery0".SavedQueryId asc'

,N'@StateCode0 int,@ReturnedTypeCode0 int,@QueryType0 int,@QueryType1 int',@StateCode0=0,@ReturnedTypeCode0=2010,@QueryType0=0,@QueryType1=

4

-- delete from SavedQueryBase where SavedQueryId='ENTER THE SAVED QUERY ID HERE'

Reply