How to find internal tablename of running workflow?

Avatar

Avatar
Validate 1
Level 1
XyNaiz
Level 1

Likes

0 likes

Total Posts

12 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
XyNaiz
Level 1

Likes

0 likes

Total Posts

12 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
XyNaiz
Level 1

13-08-2020

Hi Everyone,

I'm new to Adobe Campaign Classic.

Currently, I have a hard time to map the internal table name that running workflow using.

I found some workflow consume a very high transaction log due to some un-experienced users.

There is one INSERT statement that I saw in the database which insert into wkf18471480_381_2 which I need to map back to it's workflow.

 

Is there any dataschema or SQL query that I can easily map back?

Please help.

Thank you in advanced. 🙂

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
XyNaiz
Level 1

Likes

0 likes

Total Posts

12 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
XyNaiz
Level 1

Likes

0 likes

Total Posts

12 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
XyNaiz
Level 1

14-08-2020

Hi Everyone,

I finally found it.

We can find the internal tablename that workflow are using by filter in column 'Visual Status' in dataschema xtk:workflow using contains mapping.

Or you can directly query at the database level by

 

select * from <schama>.XtkWorkflow where mVisualState like '%wkf12345678%';

 

Hope this can help you to easily track back from the SQL statement to workflow name.

Thanks to all again.

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 1
XyNaiz
Level 1

Likes

0 likes

Total Posts

12 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
XyNaiz
Level 1

Likes

0 likes

Total Posts

12 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
XyNaiz
Level 1

13-08-2020

Hi All,

Thanks for all comments but those are not for my objective.

Currently, I saw the table name at the database server.

I need to map that name back to workflow name.

How can I do?

Avatar

Avatar
Validate 1
Level 2
amritakedia_epsilon
Level 2

Likes

5 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 2
amritakedia_epsilon
Level 2

Likes

5 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
amritakedia_epsilon
Level 2

13-08-2020

Click on Workflow Properties - > Execution Tab -> Check "Log SQL queries in journal" .

 

Then whenever you execute the workflow you can see the exact SQL queries that are running behind the scene .

 

Hope this helps!

Avatar

Avatar
Boost 3
Level 1
akedia
Level 1

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Level 1
akedia
Level 1

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
akedia
Level 1

13-08-2020

 

 

 

Avatar

Avatar
Boost 5
Level 2
isahore
Level 2

Likes

8 likes

Total Posts

36 posts

Correct reply

11 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Level 2
isahore
Level 2

Likes

8 likes

Total Posts

36 posts

Correct reply

11 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
isahore
Level 2

13-08-2020

Hi @XyNaiz,

In the workflow, you can log the interim table name by the variable vars.tableName:

 

logInfo(vars.tableName);

 

Regards,

Ishan