Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Identify workflow based on name of wkf tables

WesleyXP
Level 2
Level 2

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
3 Replies
wodnicki
Community Advisor
Community Advisor

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

WesleyXP
Level 2
Level 2
Hi Jon, Thank you for your reply and the confirmation. Do you know how Adobe Campaign handles negative workflow id's? As shown in the example, we cannot derive the workflow id from the wkf table name when it's - this is an assumption - negative. Is there a way how AC translates a negative id? Kind regards, Wesley