Tracking workflow fails with broadlogRcp and Oracle error

Last update: Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

This article addresses an issue where the tracking workflow fails with errors like Attribute 'broadLog-id unknown and ORA-00904: “ITRACKINGLOGID”: invalid identifier.

Description description

Environment

Adobe Campaign Classic v7 (ACC v7)

Issue/Symptoms

The tracking workflow fails with the following errors:

Attribute 'broadLog-id' unknown (see definition of schema 'Delivery recipient logs (nms:broadLogRcp)').

ORA-210000 Oracle Error: ORA-00904: "ITRACKINGLOGID": invalid identifier

Steps to reproduce

The tracking workflow is in a paused state.

When checking the audit logs of the workflow, the following errors are displayed:

code language-none
`Attribute 'broadLog-id' unknown (see definition of schema 'Recipient delivery log (nms:broadLogRcp)'). ORA-210000 Oracle Error: ORA-00904: "ITRACKINGLOGID": invalid identifier`

Resolution resolution

Display all the target mappings defined on the instance.
Add the column storage/@trackingLogSchema, and check which of the target mappings use nms:broadLogRcp as the tracking log schema storage/@trackingLogSchema.
Correct these target mappings to use a tracking log schema (Example: nms:trackingLogRcp schema) for the schema where tracking logs are stored, and save the modification.
Restart the tracking log workflow.

Cause

One or more target mappings use the schema nms:broadLogRcp as the tracking log schema storage/@trackingLogSchema in their definition.

This is incorrect, making the tracking workflow fail.

recommendation-more-help

3d58f420-19b5-47a0-a122-5c9dab55ec7f