Tracking Tech Workflow error

Avatar

Avatar

nagendrar695179

Avatar

nagendrar695179

nagendrar695179

06-09-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

27-09-2019

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

Answers (5)

Answers (5)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

26-09-2019

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

Avatar

Avatar

shrawans3153003

Employee

Avatar

shrawans3153003

Employee

shrawans3153003
Employee

25-09-2019

HI Ram,

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

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

27-09-2019

Moved to Adobe Campaign Classic​.

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

Avatar

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

26-09-2019

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

Avatar

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

26-09-2019

shrawans31530030Adobe Campaign Classic (7.0 18.10 build 8978@5834546)