Expand my Community achievements bar.

Identify workflow based on name of wkf tables

Avatar

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
  

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

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

Avatar

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