Workflow Table Name logic understanding | Community
Skip to main content
N
nitesh_anwani
Level 2
August 6, 2021
Solved

Workflow Table Name logic understanding

  • August 6, 2021
  • 3 replies
  • 1886 views

Hi Folks,

 

Can we figure out the logic of table name which gets created in the backend database when we run a workflow from a frontend console?

 

Previously, we were able to identify the table name using the workflow primary key id. Table name follows the below pattern

"WKF<Primary Key ID>%"

 

But, recently our auto sequence has exhausted, and our DBA changed the sequence range to the negative number. so, now whenever we create the new workflow, the primary key of workflow gets generated as negative number. and table name is not matching with the primary key of the workflow.

 

Regards,

Nitesh Anwani

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Kishore_Padamata

Hello Nitesh,

Please try below:

Add 4294967296 to your workflow primary key and see, if it matches the WKF<xxxxxx>

For example: If your workflow primary key is -11111
Workflow table name would be WKF4283856185
4294967296 + (-11111111) -> 4283856185

In case, you see a different table name please share with us

1. your DB engine

2. two pairs of Workflow Primary Key; ACC generated Workflow Table Name.

Hope this helps!

 

3 replies

Krishnanunni
Krishnanunni
Level 4
August 6, 2021

Hi @nitesh_anwani ,

 

There are some default variables set while executing the workflow. Have you tried using the variable vars.tableName which hold the name of the worktable?

N
nitesh_anwaniAuthor
Level 2
August 6, 2021

Hi @krishnanunni ,

 

We have more than direct access to the backend databased, because it hybrid solution. and In database, we can see there are more than 2500 tables starting with table name "WKF". In our campaign, we have more than 10000 workflows. and It is very difficult to check each workflow instance variables.

 

That's why we are trying to figure out the logic of table name generation against the workflow.

 

Infact, we have checked by creating few new workflows, and by comparing the table name and with the workflow primary key. but, didn't got any luck, there is no consistent pattern.

 

Regards,

Nitesh Anwani

Krishnanunni
Krishnanunni
Level 4
August 6, 2021
Hi @nitesh_anwani, I am not much familiar with hybrid solution. Does writing the value of vars.tableName and workflow internal name to a csv file or a JSON file during workflow execution helps?
Kishore_Padamata
Adobe Employee
Kishore_PadamataAdobe EmployeeAccepted solution
Adobe Employee
August 13, 2021

Hello Nitesh,

Please try below:

Add 4294967296 to your workflow primary key and see, if it matches the WKF<xxxxxx>

For example: If your workflow primary key is -11111
Workflow table name would be WKF4283856185
4294967296 + (-11111111) -> 4283856185

In case, you see a different table name please share with us

1. your DB engine

2. two pairs of Workflow Primary Key; ACC generated Workflow Table Name.

Hope this helps!

 

    Terms & ConditionsAccessibility statement

    Loading footer...