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
