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. 🙂

View Entire Topic

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