Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Tracking Tech Workflow error

Avatar

Avatar
Validate 1
Level 2
nagendrar695179
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
nagendrar695179
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
nagendrar695179
Level 2

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
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
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
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
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
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct Reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct Reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
shrawans3153003
Employee

25-09-2019

HI Ram,

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

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

27-09-2019

Moved to Adobe Campaign Classic​.

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

Avatar

Avatar
Validate 1
MVP
DavidKangni
MVP

Likes

248 likes

Total Posts

359 posts

Correct Reply

142 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
DavidKangni
MVP

Likes

248 likes

Total Posts

359 posts

Correct Reply

142 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
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
Validate 1
MVP
DavidKangni
MVP

Likes

248 likes

Total Posts

359 posts

Correct Reply

142 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
DavidKangni
MVP

Likes

248 likes

Total Posts

359 posts

Correct Reply

142 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
DavidKangni
MVP

26-09-2019

shrawans31530030Adobe Campaign Classic (7.0 18.10 build 8978@5834546)