How to find internal tablename of running workflow?

Avatar

Avatar

NaiyapornS

Avatar

NaiyapornS

NaiyapornS

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

NaiyapornS

Avatar

NaiyapornS

NaiyapornS

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

NaiyapornS

Avatar

NaiyapornS

NaiyapornS

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

amritakedia_epsilon

Avatar

amritakedia_epsilon

amritakedia_epsilon

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

akedia

Avatar

akedia

akedia

13-08-2020

 

 

 

Avatar

Avatar

isahore

Avatar

isahore

isahore

13-08-2020

Hi @NaiyapornS,

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

 

logInfo(vars.tableName);

 

Regards,

Ishan