Versions Compared

Old Version 2

changes.mady.by.user Ana Teixeira

Saved on

compared with

New Version Current

changes.mady.by.user Ana Teixeira

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Preconditions validation: Check for the unlikely case of having the same precondition linked more than once to the same test 
 


Code Block
select count(*), "TARGET_ISSUE", "SOURCE_ISSUE" from "AO_8B1069_TEST_PRE_COND_LINK" group by "TARGET_ISSUE", "SOURCE_ISSUE" HAVING count(*)>1 

  

Preconditions validation: If the previous query returned results, then delete the duplicated occurrences using the query of your choice 

  


Get upgrade number number IDs 


Code Block
select ps.* from propertystring ps join propertyentry pe on pe.id=ps.id where property_key like '%xray%'; 

  

update propertystring set propertyvalue = 2007000000 where ID in (<ids from the previous query that has the value greater than 2007000001); 

...

 


Re-run this select query to validatethat the values have been changed. 

...

Code Block
delete from "AO_8B1069_TEST_CHANGE";   
truncate "AO_8B1069_GENERIC_DEFINITION"; 
truncate "AO_8B1069_CUCUMBER_DEFINITION"; 
UPDATE "AO_8B1069_TEST_PRE_COND_LINK" SET "TEST_VERSION_ID" = null; 
UPDATE "AO_8B1069_PARAM" SET "SUB_ENTITY_ID" = null; 
UPDATE "AO_8B1069_TEST_STEP" SET "TEST_VERSION_ID" = null; 
UPDATE "AO_8B1069_AUTOMATED_STEP_ISSUE" SET "TEST_VERSION_ID" = null; 
UPDATE "AO_8B1069_ENTITY_DATASET_SIZE" SET "SUB_ENTITY_ID" = null; 
UPDATE "AO_8B1069_TEST_RUN" SET "TEST_VERSION_ID" = null; 
delete from "AO_8B1069_TEST_VERSION";  


  

  

Preconditions validation: Check for the unlikely case of having the same precondition linked more than once to the same test 
 

Code Block
select count(*), "TARGET_ISSUE", "SOURCE_ISSUE" from "AO_8B1069_TEST_PRE_COND_LINK" group by "TARGET_ISSUE", "SOURCE_ISSUE" HAVING count(*)>1 

...

Preconditions validation: If the previous query returned results, then delete the duplicated occurrences using the query of your choice 
...
 Code Block
select ps.* from propertystring ps join propertyentry pe on pe.id=ps.id where property_key like '%xray%'; 

  

update propertystring set propertyvalue = 2007000000 where ID in (<ids from the previous query that has the value greater than 2007000001); 
...
 

Re-run this select query to validate that the values have been changed. 
  
 Code Block
select ps.* from propertystring ps join propertyentry pe on pe.id=ps.id where property_key like '%xray%';   
...

 
4) Once that is done, please try to install the latest version (7.X). If you still are getting the error, please reach out to the Xray support team. 
...