Page History
...
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)
| 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.
...
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)
| 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); |
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.
...