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

SOLVED

Workflow Table Name logic understanding

nitesh_anwani
Level 2
Level 2

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

1 Accepted Solution
kishorep
Correct answer by
Employee
Employee

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!

 

View solution in original post

4 Replies
Krishnanunni
Level 3
Level 3

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?

nitesh_anwani
Level 2
Level 2

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
Level 3
Level 3
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?
kishorep
Correct answer by
Employee
Employee

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!

 

View solution in original post