Tracking Tech Workflow error | Community
Skip to main content
A
Anonymous
September 6, 2019
Solved

Tracking Tech Workflow error

  • September 6, 2019
  • 6 replies
  • 7676 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Adhiyan

    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

    6 replies

    ShrawanSaxena-1
    Adobe Employee
    ShrawanSaxena-1Adobe Employee
    Adobe Employee
    September 26, 2019

    HI Ram,

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

      DavidKangni
      Community Advisor
      DavidKangniCommunity Advisor
      Community Advisor
      September 26, 2019

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

      David Kangni
      Adhiyan
      Adobe Employee
      AdhiyanAdobe Employee
      Adobe Employee
      September 26, 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

        DavidKangni
        Community Advisor
        DavidKangniCommunity Advisor
        Community Advisor
        September 26, 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

        David Kangni
        Adhiyan
        Adobe Employee
        AdhiyanAdobe EmployeeAccepted solution
        Adobe Employee
        September 27, 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

          pablo_rosero1
          pablo_rosero1
          Level 9
          September 27, 2019

          Moved to Adobe Campaign Classic​.

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

          Terms & ConditionsAccessibility statement

          Loading footer...