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

Ankush Agrawal · ‎11-14-2018

Hi Waleed

Does the new instance also have the same table? If not, then the behavior observed is correct. ATF has captured the values but it cannot render on the screen since the actual table and respective fields are not present.

--
Best regards
Ankush

P.S. Please mark helpful/correct as appropriate to help fellow Community user in identifying useful answers.

Waleed2 · ‎11-15-2018

I believe the tables aren't exactly the same in Dev and Test which is why I am having this issue. Do you think there there is a workaround for that since I cannot have the exact same environments in both Dev and Test because of a security issue.

Waleed2 · ‎11-15-2018

Actually I think I found it. I need to export the records from sys_variable_value.list that use the the sys_atf_step table.

Ankush Agrawal · ‎11-15-2018

Hi Waleed

That means your update sets are not capturing the records from sys_variable_value. which would be very weird.