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

Improve this question
7
  • Please copy/paste the full error message
    – Jacob Nielsen
    Oct 26, 2018 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, 2018 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, 2018 at 0:12
  • What happens when you open up Experience Analytics?
    – Pete Navarra ♦
    Nov 29, 2018 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, 2018 at 7:56

3 Answers 3

Reset to default
1

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

Email Campaign

Improve this answer
8
  • It is published after i run campaign
    – Cuong Nguyen
    Oct 29, 2018 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, 2018 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, 2018 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, 2018 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, 2018 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.

Improve this answer
-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

Improve this answer
1
  • 1
    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, 2019 at 19:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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