Which table has Automated Test Framework Step Data? Cloning Down

Waleed2 · ‎11-14-2018

Hi Everyone,

So we recently implemented Automated Test Framework in our Dev and Test environment. I built out all the tests in Dev and used an Update Set to push it to Test environment, For some reason, the Tests, Steps and the Suites got copied down in the the Update Set and when it was committed in the Test environment, none of the Steps data came with it. For example, when a Field Value Validation was created, the description, name, etc., came except the actual values of the Step.

As you can see, the Table field is empty and there aren't any conditions listed. Not sure why the Update Set didnt capture it. My question is which table needs to be exported manually to have the steps field filled in when the tests are moved from Dev to Test?

Chris Sanford1 · ‎11-14-2018

sys_variable_value is the table you are looking for. It should automatically capture in an update set, like Nitesh said. But if you manually import the sys_atf_step XML, it won't copy the values without the corresponding sys_variable_value records. So you need to export sys_variable_value records where table is sys_atf_step.

This link should take you there:

https://<instance-name>.service-now.com/nav_to.do?uri=%2Fsys_variable_value_list.do%3Fsysparm_offset%3D%26sysparm_query%3D%255Edocument%253Dsys_atf_step%26sysparm_list_mode%3Dgrid

View solution in original post

SanjivMeher · ‎11-14-2018

You can export and import sys_atf_step table.

Please mark this response as correct or helpful if it assisted you with your question.

Nitesh Balusu · ‎11-14-2018

Hi Waleed,

Everything while performing ATF's does get captured in an update set, so please make you have a new update set in progress while creating ATF Tests/Suites instead of performing them in Global. To get your test steps now, like Sanjiv mentioned just import and export your sys_atf_step table.

Waleed2 · ‎11-14-2018

So I tried that too and created an Update Set and created a new Test from scratch. Everything about it got captured in the Update Set, except the actual values in each step. For example, if I impersonated myself in Dev for the test step, when the update set was moved to Test instance, I had to go into the 'impersonate' test step and pick my name again. The sys_atf_step includes the steps of the Test but not the actual values in each steps.

Nitesh Balusu · ‎11-14-2018

I am guessing you missed something, it should capture data in the test step as well. I just replicated what you had told me and it works fine.

Below screenshots are from different instances, and everything is captured perfectly. Do you have the same roles for yourself in dev and test?