Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Can't send Bulk Emails to more then one receipient RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    we are currently running crm 4.0 with rollup 11 (maybe the rollup is the problem).
    this month we wanted to send a bulkmail to all of our customers.

    after first try sending the mail with bulkmail assistent, everything went fine like it always did. but after
    half an hour i noticed, that there was no email created to any contact that belongs to my marketinglist.

    next, i tested directly from "contacts" list. i selected two employees from our company, clicked on bulkmail and created
    the mail from my email-template. same problem, there are no new entrys in my history list.

    now i only selected one contact and started bulkmail from assistent and -> it worked fine.

    the problem seems to be, that more than one selected item makes the bulkmail function fail.

    a similar problem is when i try to add contacts to for example a marketinglist with advanced search. if i select "all from all pages" or "all from this page",
    i get a crm error and my search closes. when i manually select all contacts in the list, they are added to my marketing list.

    How to fix this problems?

    Tuesday, July 27, 2010 10:27 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Oliver,

    you can down CRM diagnostics tool from this link http://jianwang.blogspot.com/2010/03/download-crm-40-diagnostics-tool.html

    run this tool on crm application server and this tool will allow you to enable/dsiable tracing for CRM..

    so do following steps..

    1. Run this tool on CRM server, enable tracing

    2. log on to CRM and reproduce your error

    3. disable tracing

    3. Now go to Microsoft Dynamics CRM\Trace folder and open the trace file and find out the log related to your actions and paste the details over here..

     

     

    MayankP My Blog My twitter
    • Marked as answer by Jim Glass Jr Tuesday, August 3, 2010 2:40 PM
    Thursday, July 29, 2010 12:42 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Oliver, if the Microsoft CRM Asynchronous service is not started and won't start, then you will have some problems sending direct e-mail (and lots of other features). What method did you use to move the database and reports to another database server? The only supported method that I'm aware of is this one: http://support.microsoft.com/kb/952934; if you didn't follow this KBA, that might explain why the async service won't start.

    Neil

    Neil Benson, CRM Addict and MVP at Customery Ltd.You can reach me on LinkedIn or Twitter.

    • Marked as answer by Jim Glass Jr Tuesday, August 3, 2010 2:39 PM
    Tuesday, August 3, 2010 9:54 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Do you have any record counter plug-ins enabled? Did you see the error message to contact your local systemadministrator? Then you should enable tracing to see the error. I´ve seen this error on customer site and we did some research and found out that it was a timeout issue when selecting all records. So we had to edit the registry on server site and the error was gone...
    Gruß Carsten Groth http://carstengroth.spaces.live.com
    Tuesday, July 27, 2010 5:32 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    check server log or enable trace and see what actual error you are getting over here...once you provide actual error details we can help you furhter on this..
    MayankP My Blog
    Tuesday, July 27, 2010 8:33 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for your reply. in MS KB i found this article http://support.microsoft.com/kb/907490/

    to enable trace for crm. which settings do i have to make on my server that you get the information you need?

     

    Thursday, July 29, 2010 11:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Oliver,

    you can down CRM diagnostics tool from this link http://jianwang.blogspot.com/2010/03/download-crm-40-diagnostics-tool.html

    run this tool on crm application server and this tool will allow you to enable/dsiable tracing for CRM..

    so do following steps..

    1. Run this tool on CRM server, enable tracing

    2. log on to CRM and reproduce your error

    3. disable tracing

    3. Now go to Microsoft Dynamics CRM\Trace folder and open the trace file and find out the log related to your actions and paste the details over here..

     

     

    MayankP My Blog My twitter
    • Marked as answer by Jim Glass Jr Tuesday, August 3, 2010 2:40 PM
    Thursday, July 29, 2010 12:42 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for that tool. It was very helpfull to activate the tracelogs. But now i have absolutly no idea what
    you need out of these files. crm creates about 10mb files in two minutes.

     

    Thursday, July 29, 2010 1:02 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    if you go through the trace file and then you try to track down the log related to your action ..

    foe e.g. if you sending email then search for word email and then find lines which have actual log/exception related to your problem and then paste that details over here and some one can help you further with this..

    MayankP My Blog My twitter
    Thursday, July 29, 2010 2:46 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    H

    mm. not so easy to read information out of this information overload. i think it starts at this point

    >MapOrgEngine: Retreived the OrgId[{F7AD7550-0EA1-40FD-9052-D1A92F75674C}] for URL[http://crmserver/XXXGmbH/_grid/cmds/dlg_bulkemail.aspx?bulkemail=true&multiPage=false&objectTypeCode=2].
    [2010-07-29 17:23:33.5] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    1 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute

    It auths to the server etc. then a template seems to be selected

    >select top 5001 template0.TemplateId as 'templateid', template0.TemplateTypeCode as 'templatetypecode', template0.Title as 'title', template0.Subject as 'subject', template0.SubjectPresentationXml as 'subjectpresentationxml', template0.Description as 'description', template0.CreatedBy as 'createdby', template0.CreatedOn as 'createdon', template0.CreatedByYomiName as 'createdbyyominame', template0.CreatedByName as 'createdbyname', template0.CreatedByDsc as 'createdbydsc' from Template as template0 join BusinessUnit as businessunit0 on (template0.OwningBusinessUnit  =  businessunit0.BusinessUnitId and (businessunit0.OrganizationId = 'f7ad7550-0ea1-40fd-9052-d1a92f75674c')) where ((template0.DeletionStateCode in (0)) and (template0.IsPersonal = 0 or template0.OwnerId = '03d73d4f-f7ef-da11-a36d-0013723d3470') and (template0.LanguageCode = 1031) and (template0.TemplateTypeCode = 2 or template0.TemplateTypeCode = 8) and (template0.OwningUser = '03d73d4f-f7ef-da11-a36d-0013723d3470' or (template0.IsPersonal = 0) or (template0.IsPersonal = 1 and template0.TemplateId in (select POA.ObjectId from PrincipalObjectAccess POA join SystemUserPrincipals sup on POA.PrincipalId = sup.PrincipalId where sup.SystemUserId = '03d73d4f-f7ef-da11-a36d-0013723d3470' and POA.ObjectTypeCode = 2010 and ((POA.AccessRightsMask|POA.InheritedAccessRightsMask) & 1) = 1)))) and ((businessunit0.DeletionStateCode in (0))) order by template0.Title asc, template0.TemplateId asc
    [2010-07-29 17:23:33.5] Process: w3wp |Organization:f7ad7550-0ea1-40fd-9052-d1a92f75674c |Thread:    1 |Category: Platform.Sql |User: 4eedccca-3dc5-45bc-ab7e-421f82fbfdde |Level: Info | CrmDbConnection.InternalExecuteReader

    >MessageProcessor finish processing message 'Execute' for 'none'.
    [2010-07-29 17:23:33.5] Process: w3wp |Organization:f7ad7550-0ea1-40fd-9052-d1a92f75674c |Thread:    1 |Category: Platform |User: 4eedccca-3dc5-45bc-ab7e-421f82fbfdde |Level: Verbose | ExecutionContext.OnEndRequest

    >InProcessCrmService finished processing request ExecuteFetchRequest for user {4EEDCCCA-3DC5-45BC-AB7E-421F82FBFDDE} as user {03D73D4F-F7EF-DA11-A36D-0013723D3470}.
    [2010-07-29 17:23:33.5] Process: w3wp |Organization:f7ad7550-0ea1-40fd-9052-d1a92f75674c |Thread:    1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | PlatformCommand.ExecuteInternal

    Here seems to be an error

    >Cache item with key RequestBuilderProxyCache{f7ad7550-0ea1-40fd-9052-d1a92f75674c}http://schemas.microsoft.com/crm/2007/WebServices,RetrieveAvailableLanguagesRequest was not found in cache RequestBuilderProxyCache
    [2010-07-29 17:23:33.5] Process: w3wp |Organization:f7ad7550-0ea1-40fd-9052-d1a92f75674c |Thread:    1 |Category: Platform |User: 4eedccca-3dc5-45bc-ab7e-421f82fbfdde |Level: Verbose | ExecutionContext.OnBeginRequest

    ...

    >MessageProcessor finish processing message 'Send' for 'template'.
    [2010-07-29 17:23:43.0] Process: w3wp |Organization:f7ad7550-0ea1-40fd-9052-d1a92f75674c |Thread:    1 |Category: Platform |User: 4eedccca-3dc5-45bc-ab7e-421f82fbfdde |Level: Verbose | ExecutionContext.OnEndRequest

    ... last entry in logifle to bulkmail

    >InProcessCrmService finished processing request SendTemplateRequest for user {4EEDCCCA-3DC5-45BC-AB7E-421F82FBFDDE} as user {03D73D4F-F7EF-DA11-A36D-0013723D3470}.
    [2010-07-29 17:23:43.0] Process: w3wp |Organization:f7ad7550-0ea1-40fd-9052-d1a92f75674c |Thread:    1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | PlatformCommand.ExecuteInternal

     

     

     

     

    Thursday, July 29, 2010 3:44 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    What is this " bulkmail assistent" or "Bulk Mail" you are referring to?  I see "Mail Merge", Direct E-mail" and Quick Campaign as options.  Which one of these are you using?

    Regards, Donna

            Windows Live Blog

    Monday, August 2, 2010 7:03 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I don't know how it is named in english version of crm. in german it is "Serien-Email".

    next problem we are having now is workflows do not start in crm. i look in system services and saw the crm async service
    is set to "manual". i can't start it, because there are dependencies to local sql server, which is no longer existing because
    we moved database and reports to another sql server.

    Tuesday, August 3, 2010 9:13 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Oliver, if the Microsoft CRM Asynchronous service is not started and won't start, then you will have some problems sending direct e-mail (and lots of other features). What method did you use to move the database and reports to another database server? The only supported method that I'm aware of is this one: http://support.microsoft.com/kb/952934; if you didn't follow this KBA, that might explain why the async service won't start.

    Neil

    Neil Benson, CRM Addict and MVP at Customery Ltd.You can reach me on LinkedIn or Twitter.

    • Marked as answer by Jim Glass Jr Tuesday, August 3, 2010 2:39 PM
    Tuesday, August 3, 2010 9:54 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, this is the method i used to move the database and reports to another server.

    there is cmrserver and srvsql. this is our reg-config:

    "HelpCatalog"="Microsoft CRM Help"
    "SQMEnabled"=dword:00000000
    "SQMQueueLocation"="C:\\WINDOWS\\system32\\..\\temp\\MSCRMSQM"
    "SQMMaxQueueSize"=dword:0000001e
    "emailAddress"="crm@XXX.de"
    "configdb"="Data Source=SRVSQL;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI"
    "database"="Provider=SQLOLEDB;Data Source=SRVSQL;Initial Catalog=XXX_GmbH_MSCRM;Integrated Security=SSPI"
    "metabase"="Provider=SQLOLEDB;Data Source=SRVSQL;Initial Catalog=XXX_GmbH_MSCRM;Integrated Security=SSPI"
    "LanguageID"="1031"
    "roles"=dword:0024802b
    "website"="/LM/W3SVC/1"
    "WebSitePath"="c:\\inetpub\\wwwroot"
    "UninstallData"="<SOAP-ENV:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:clr=\"http://schemas.microsoft.com/soap/encoding/clr/1.0\" SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\">

    <SOAP-ENV:Body>

    <a1:UninstallData id=\"ref-1\" xmlns:a1=\"http://schemas.microsoft.com/clr/nsassem/Microsoft.Crm.Setup.Server/Microsoft.Crm.Setup.Server%2C%20Version%3D4.0.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3D31bf3856ad364e35\">

    <removeWebSite>false</removeWebSite>

    <appPoolOfExistingWebSite id=\"ref-3\">CRMAppPool</appPoolOfExistingWebSite>

    </a1:UninstallData>

    </SOAP-ENV:Body>

    </SOAP-ENV:Envelope>

    "
    "AnonymousAccessToHelpVDir"="false"
    "Database Version"="4.0.7219.0"
    "CRM_Server_Version"="4.0.7333.113"
    "CRM_Server_InstallDir"="C:\\Programme\\Microsoft CRM"
    "ServerUrl"="http://CRMSERVER/MSCRMServices"
    "SQLRSServerURL"="http://CRMSERVER/ReportServer"
    "RSInstalled"=dword:00000001
    "RSUseSSL"=dword:00000000
    "AutoGroupManagementOff"=dword:00000000
    "WebStoreEnabled"=dword:00000000
    "ConfigDbWebStoreEnabled"=dword:00000000
    "StatsDbWebStoreEnabled"=dword:00000000
    "ConfigSku"="OnPremise"
    "RoleNames"=""
    "LocalSdkPort"=dword:00000050
    "testlatestinsert"="0x00000001"
    "EmailTemplateBodyHTMLNoEncode "=dword:00000001
    "CRM_Server_Serviceability_Revision"="2862"
    "WebConfigUpdateSuccessful"=dword:00000000
    "TraceEnabled"=dword:00000000
    "TraceCallStack"=dword:00000000
    "TraceRefresh"=dword:00000005


    Tuesday, August 3, 2010 10:14 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Please open the Deployment Manager on the CRM server and ensure your Organization is enabled.  To open the Deployment Manager on the CRM server, go to Start, Programs, Microsoft Dynamics CRM, Deployment Manager.  If the Organization is enabled, ensured you have the correct listing for your SQL Server.  You should see one listing for the CRM Server and one for the SQL Server.  Ensure both are enabled.

    Regards, Donna

            Windows Live Blog

    Tuesday, August 3, 2010 12:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, organisation is activated.

    SQl Server points to srvsql and reportserver to https://srvsql.local.XXX.de/Reportserver

    But under "Server" i can see CRMSERVER is listed as "deactivated". When i try to activate it, it says "Not all services could be started". That seems to be
    async service...Event log has this entry "Enable Server" failed to complete.

    should i enable old sql server service on my CRMSERVER?

    Tuesday, August 3, 2010 12:47 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    You shouldn't need to enable the old sql server service but you do need to ensure that the SQL Server in the deployment manager is pointing to the new SQL Server

    Is your Report Server and SQL Server on the new box or do you have your Report Server on the CRM box and SQL Server on a new box?  I'm trying to understand why you have a listing for the Report Server.  If your Report Server is on the CRM box, then enable the SQL Services on that box.

    Regards, Donna

            Windows Live Blog

    Tuesday, August 3, 2010 1:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As i can see in the deployment manager, everything is like i wanted:

    Computer with SQL Server: SRVSQL
    Reportservice :https://srvsql...

    IIS is hosted on server CRMSERVER

    Reports and other crm functions are working fine, mass emails and workflows are not working (async service)
    the only reg key that looks not ok is "SQLRSServerURL"="http://CRMSERVER/ReportServer". Is it a leftover from crm 3.0 upgrade?

    is there now the crm sql connector from crm install disk required on CRMSERVER?

    Tuesday, August 3, 2010 2:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, install the SRSS Data Connector.  However since reports and other features are working, it doesn't seem that is the issue.  I'm not sure what is going on in your environment that is causing problems with the async service.  It is challenging to identify without having a look. 

    At this point, it is not going to hurt to start the SQL services and see if that corrects the issue.  It wouldn't hurt to reboot your CRM and SQL box as well. 

    Regards, Donna

            Windows Live Blog

    Tuesday, August 3, 2010 2:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I' ve started the sql service localy on sql server and now async service runs , it is sending
    masses of mails to our customers they have received two weeks ago...
    where is the config error on my server?

    Tuesday, August 3, 2010 4:14 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If you moved only the SQL database to a new server but left the Report Server on the CRM server then SQL services need to be running on the CRM server.

    I don't know that there is a Config error.  Any e-mails that were in Pending Send status will get sent when the async service starts.

    Regards, Donna

            Windows Live Blog

    Tuesday, August 3, 2010 4:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I moved both, sql and reportserver. since yesterday, only sql service without active databases is running on old CRMSERVER. all other services from sql server are set to "deactivated".
    something went wrong when moving the services, but i don't know where to look on my server. is it the registry? should i
    use the deploymentmanager again?
    Wednesday, August 4, 2010 8:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Try this

    • Install the SRSS Data Connector on the SQL machine.
    • Remove all incorrect references to CRM Servers or Report Servers from the Deployment Manager. 
    • Ensure the CRM Server and SQL Server in the Deployment Manager are referencing the correct machines.
    • Reboot your SQL & CRM machines

    If you don't need SQL on your CRM server, then I recommend you completely uninstall it if you are comfortable with that approach.

     

    Regards, Donna

    Wednesday, August 4, 2010 2:32 PM