Versions Compared

Old Version 6

changes.mady.by.user Luis Sousa

Saved on

compared with

New Version Current

changes.mady.by.user Luis Sousa

Saved on

Key

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

...


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";  

...

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";  

...