Technical workflow visibility issue in Adobe Campaign Standard

If technical workflows disappear after changes are made to the organizational unit, verify any recent changes made to workflow organization units, and attempt reassigning them back to their previous state, if they disappear post-change.

Description description

Environment

Adobe Campaign Standard (ACS)

Issue

A change to the organizational unit of technical workflows, resulted in these workflows no longer appearing.

After this change, none of the technical workflows were visible on the designated page.

The issue caused significant operational disruptions, including:

Resolution resolution

To resolve this issue, follow these steps:

By following these guidelines, you can ensure minimal disruption and maintain the smooth operation of your Adobe Campaign Standard environment when dealing with workflow visibility issues related to organizational unit changes.

Example

For example, the organizational unit for 29 technical workflows was updated to France via a workflow named WKF2210.

In this example, the organization unit of the workflows was changed from ALL to a different organization unit due to which the technical workflows were not visible.

Before Fix:

select iorgunitid,igeounitid, count(*) from xtkworkflow where ibuiltin=1 group by 1,2 order by 1,2;

iorgunitid | igeounitid | count

------------±-----------±------

1  |             1  |       5

138700212 |             1  |     29

Query used to update:

update xtkworkflow set iorgunitid=1 where iorgunitid=138700212; UPDATE 29

After Fix:

select iorgunitid,igeounitid, count(*) from xtkworkflow where ibuiltin=1 group by 1,2 order by 1,2;

iorgunitid | igeounitid | count

------------±-----------±------

1  |             1  |      34

After performing these steps in this example, all previously invisible technical workflows should become visible again and resume normal operations.