Identify workflow based on name of wkf tables

Avatar

Avatar

WesleyXP

Avatar

WesleyXP

WesleyXP

16-09-2020

Hi everyone,

 

Our system engineer sometimes provides us with the names of the wkf-tables created by workflows causing trouble on the system.

Usually it's possible to derive the workflow directly from these id's, but not always.

 

Example 1

The table with name wkf539349321_11438_1 is created by the workflow with primary key 539.349.321.

This key is directly derived from the name.

 

Example 2

When we derive the primary key using the same method out of wkf3312884954_218_1 we get 3.312.884.954.

However, the primary key cannot be greater than 2.147.483.647, so you will never get a result for this key.

 

Remark: A lot of our workflows currently get negative primary keys.

 

We assume these out of range id's might be created by workflows with a negative primary key. However, until now we haven't found a way to translate those id's back to the primary keys, if this is even possible.

 

Our question:

  • Is there indeed a link between the primary key and the name used for wkf tables?
  • And if so, is there a way to find the workflow responsible for creating this wkf table just by looking at the name and using the Adobe Campaign client? Is there maybe a formula which we can apply on the id? Or a place in AC where we can look up which workflow created id ...

 

Any help would be welcome!

Wesley
  

 

workflow

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

20-09-2020

Hi,

 

  • Is there indeed a link between the primary key and the name used for wkf tables?

Yes.

 

  • And if so, is there a way to find the workflow responsible for creating this wkf table just by looking at the name and using the Adobe Campaign client? Is there maybe a formula which we can apply on the id? Or a place in AC where we can look up which workflow created id ...

Working tables are named wkf<workflow id>_<task id><optional placeholder set to _1 usually>.

 

Thanks,

-Jon