Tracking workflow fails with broadlogRcp and Oracle error

Last update: Thu Apr 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Correct these target mappings to use a tracking log schema for the schema where tracking logs are stored and save the modification.

Description description

Environment

Adobe Campaign Classic v7 (ACC v7)

Issue

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

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.

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.

recommendation-more-help

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