Tracking Tech Workflow error

[#1]

On ACC V7, I see an error on the technical workflow for tracking.

09/06/2019 4:00:06 AM    nlmodule    WDB-200011 The requested database record does not exist.

09/06/2019 4:00:06 AM    nlmodule    WDB-200001 SQL statement 'SELECT iDeliveryId FROM NmsBroadLogRcp WHERE iBroadLogId=:#(1)#' could not be executed.   Param(0)=1390003

09/06/2019 4:00:03 AM    nlmodule    Application server for Adobe Campaign Classic (7.0 18.10 build 8978@5834546) of 12/06/2018

09/06/2019 4:00:03 AM        Workflow 'tracking' is being run

From the error, it looks like the tracking workflow is looking for a iBroadlogid = 1390003, which is non existing in nmsBroadlogRCP. Wonder how could this mismatch occur and how to rectify the same.

Please share any thoughts.

Thanks

Ram

[#2 · Accepted solution]

Hi David,

If you have a hybrid setup (on-prem MKT and Hosted Mid ) then yes. The file entry needs to be deleted from the Mid server in this case.

Do raise a support ticket referring to this forum in this case for us to action this.

Also , since this is a Regression bug in this build the long term solution is to upgrade the build to avoid future recurrences.

Regards,

Adhiyan

[#3]

Hi Nagendra, David,

This looks to be already reported and fixed bug in the product . Fixed in versions 8981 and above.

The problem here is that the tracking workflow is trying to update a tacking entry for a recipient who might have clicked on a link after the broadLogs are purged for the delivery (say after 6 months ) . The tracking workflow tries to insert this record in the trackingLogRcp table and fails as it does not find a corresponding delivery Log.

What I can think of as a remediation step is to look into the tracking log files (0X0000000 log files) present in the app server under var/redir/logs directory and search for the hex value of 1390003 prefixed with h (h1535b3) .

It should give you the tracking log entry the tracking workflow is trying to read. You can delete that line and save the logs and restart tracking workflow after that. Be sure to stop the tracking workflow when making the change and restart the trackingLogd service after deleting the line and then start the tracking workflow.

Alternately , the same tracking log line would also have the delivery ID in hex format . Convert that into decimal and look for the delivery ID in the delivery table. Probably someone deleted the delivery while being active and it caused the problem.

If the delivery is deleted , you need to delete all the lines corresponding to that delivery from the tracking log files else the first solution should be good enough.

--
Adhiyan

[#4]

HI Ram,

Could you please let me know build version of your marketing instance ?

[#5]

Moved to Adobe Campaign Classic​.

Please post here directly in the future for Campaign Classic questions and topics

[#6]

Thanks Adhiyan C for your reply.

But as the instance is on-premise, i'm thinking it's better to have Adobe techOps to delete the delivery on the mid-sourcing instance.The when the tracking wkf will run, it will not try to update the delete deliveries.

Thoughts?

Thanks

David

[#7]

shrawans31530030​ Adobe Campaign Classic (7.0 18.10 build 8978@5834546)