Email statistics don't show for one email in email marketing

Mannon Wekking

Posted on 30/08/2017 16:47:24

Hi,

On 18 august KWPN did send an email to a group of customers. But they email still don't show the statistics of the email (see attachment). What can be the problem?

It shows an error 'Conversion failed when converting the nvarchar value '138746/img/favicon/apple-touch-icon.png' to data type int." Can that maybe be the problem, and if yess, how can we fix it then?

Hope to hear soon.

Kind regards,

Manon Wekking

Replies

Imar Spaanjaars

Posted on 30/08/2017 17:10:40

You probably have bad data in your OMCLinkClick table. I think this comes from a bug that I thought was fixed a long time ago, but it may still occur?

On a copy of production, take a look at the results of this query:

SELECT TOP 1000 [LinkClickId]
,[LinkClickLinkId]
,[LinkClickClickerKey]
,[LinkClickClickTime]
,[LinkClickSessionId]
FROM OMCLinkClick
where ISNUMERIC (LinkClickClickerKey) <> 1

and then see if deleting that data fixes your issue. If that's the case you may need to upgrade, or it may be that the bug still exists in recent versions. I remember running into this a few years ago and back then we created a SQL script that would delete this data from time to time. Not an ideal solution, but it worked for us...

Imar

Imar Spaanjaars

Posted on 30/08/2017 17:12:08

Also, instead of deleting the data entirely, it could be that sanitizing this:

138746/img/favicon/apple-touch-icon.png

to to just the number 138746 might also do the trick.

Imar

Manon Wekking

Posted on 07/09/2017 16:57:25

Hi Imar,

You were right, we fixed the entries and now it works correctly. thanks.

Where are using version 8.9.2.6. @DW has this bug returned?

Kind regards,

Manon Wekking

You must be logged in to post in the forum

Developer forum

Email statistics don't show for one email in email marketing

Replies