Page History
Problem
Xray 7.X introduces a series of data structure changes. Every relation pointing to a Test now points to a Test version. This data transformation is done using an Upgrade Task that runs once.
...
And data related to versions; please look into Xray 7.0.0 Release Notes.
| Panel | ||
|---|---|---|
| ||
If you are on Xray Enterprise and using Test Case Versioning, do not proceed and reach out to the Xray Support Team, first. |
There can be two cases,
A)The first one is where Xray is upgraded from 6.X to 7.X and
B)The second one would be when you have upgraded to 7.X but also downgraded to 6.X
In both cases, the error appears on Test cases like the below:
A) For the first case, when Xray is upgraded from 6.X to 7.X. Follow the steps in the exact sequence as mentioned below:
1) Create a backup of your instance.
2) Disable the Xray plugin.
3) Run the following queries (Note: the following queries should only be done when asked by the Xray team)
Note 2: the following queries have been made for PostgreSQL. When using Oracle, please change the queries:
truncate "AO_8B1069_GENERIC_DEFINITION";
truncate "AO_8B1069_CUCUMBER_DEFINITION";
to:
TRUNCATE TABLE "AO_8B1069_GENERIC_DEFINITION";
TRUNCATE TABLE "AO_8B1069_CUCUMBER_DEFINITION";
| 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
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);
...
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 |
|---|
select ps.* from propertystring ps join propertyentry pe on pe.id=ps.id where property_key like ' |
...
%xray%'; |
...
|
4) Once all the steps are completed, please enable the Xray plugin and check if you still are getting the errors. If yes, then reach out to the Xray support team.
B)Now, for the second case, when Xray is upgraded to 7.X and then downgraded to 6.X
1) Create a backup of your instance.
2) Uninstall the Xray plugin.
3) Run the following queries (Note: the following queries should only be done when asked by the Xray team)
Note 2: the following queries have been made for PostgreSQL. When using Oracle, please change the queries:
truncate "AO_8B1069_GENERIC_DEFINITION";
truncate "AO_8B1069_CUCUMBER_DEFINITION";
to:
TRUNCATE TABLE "AO_8B1069_GENERIC_DEFINITION";
TRUNCATE TABLE "AO_8B1069_CUCUMBER_DEFINITION";
| 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
Get upgrade 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);
...
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.
...