How to find internal tablename of running workflow? | Community
Skip to main content
NaiyapornSm
Level 2
Aug 13, 2020 11:37 AM UTC
Solved

How to find internal tablename of running workflow?

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

NaiyapornSmAccepted solution
Level 2
Aug 14, 2020 10:02 AM UTC

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.

View reply

5 replies

NaiyapornSmAuthorAccepted solution
Level 2
Aug 14, 2020 10:02 AM UTC

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.

Translate
    NaiyapornSmAuthor
    Level 2
    Aug 14, 2020 2:17 AM UTC

    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?

    Translate
    amritakedia_epsilon
    Level 3
    Aug 13, 2020 6:47 PM UTC

    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!

    Translate
    akedia
    Level 2
    Aug 13, 2020 6:45 PM UTC

     

     

     

    Translate
    isahore
    isahore
    New Participant
    Aug 13, 2020 6:35 PM UTC

    Hi @naiyapornsm,

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

     

    logInfo(vars.tableName);

     

    Regards,

    Ishan

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...