1

I am working with Sitecore 9.0 update 2 on Azure.

Server is scale out : 1CM and 3CD.

After email campaign is run, we can receive email but reporting is not working. It doesn't have any data is as shown.

I checked in Campaigns table in database, data isn't stored.

enter image description here

In addition, I saw an error when I open email that is sent by EXM 
1724 11:57:37 ERROR Failed to get a registration result
Exception: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: Sitecore.EmailCampaign.Cd

Any suggestion for this issues ?

More info:

Open and click rates show after i open email but report is not updated

enter image description here

  • Please copy/paste the full error message – Jacob Nielsen Oct 26 '18 at 9:50
  • 2018-10-25T11:52:10 PID[4852] Error 7144 11:52:10 ERROR Failed to get a registration result Exception: System.NullReferenceException Message: Object reference not set to an instance of an object. Source: Sitecore.EmailCampaign.Cd at Sitecore.EmailCampaign.Cd.sitecore_modules.Web.EXM.RegisterEmailOpened.ProcessRequest(HttpContextBase context) – Cuong Nguyen Oct 26 '18 at 10:55
  • I think you are having an issue with xConnect. I suspect that Collection Service and Reference Data are not working correctly. Or there is a connection string issue. – Pete Navarra Nov 29 '18 at 0:12
  • What happens when you open up Experience Analytics? – Pete Navarra Nov 29 '18 at 0:13
  • It showed report but it isn't updated after i migrate xdb from v8 (using mongo) to v9. I see the data is not auto collect and update to reporting. Any suggest to fix this ? – Cuong Nguyen Nov 29 '18 at 7:56
1

Check if the campaign attached to this email is published and if it is available in all languages.

Email Campaign

  • It is published after i run campaign – Cuong Nguyen Oct 29 '18 at 4:09
  • It is so strength cause after the campaign is completed. Total sent still show none value although i received emails – Cuong Nguyen Oct 29 '18 at 4:11
  • Unfortunatly, this fix doesn't work retro-active. You need to do this before sending out the campaign... – Bart Verdonck Oct 29 '18 at 9:11
  • thanks @Bart Verdonck but i meam after i run a exm campaign, those campaigns is published automatically and i don't need publish anything – Cuong Nguyen Oct 29 '18 at 10:20
  • The campaign get's published when you activate the message. However, there is a bug that it only creates an en-version of the campaign. When visitors click or open the mail, sitecore tries to fetch that campaign in their language. Since the language doesn't exist, this fails. So workarround is to manually create the language versions of this campaign and deploy an publish them. – Bart Verdonck Oct 29 '18 at 13:23
0

After long time to investigate, I fixed it. In my case. Because i migrated big analytic data from mongo to xdb. Then a lot of query is processing. We need to scale up environment , rebuild xdb then wait all done.

-1

Solution, which worked for me in similar issue (empty "total sent" statistics in EXM on scaled environment), but in Sitecore 8.2 was to enable on CM server:

  • Sitecore.Analytics.Tracking.Database.ScaledCM.config
  • Sitecore.Analytics.Tracking.Aggregation.config

according to https://doc.sitecore.com/developers/82/sitecore-experience-platform/en/enable-the-interaction-registry-on-a-content-management-server.html

  • This is ONLY a solution for a Sitecore 8.2 implementation, and not valid for the question being asked since the asker has specified Sitecore 9. – Pete Navarra Mar 21 at 19:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.