Rollback the LQE rs Data Warehouse for Engineering Lifecycle Management 7.1 interim fix 008 or earlier

Prerequisites

Before you run the DDL scripts, ensure that the following conditions are met:

  • All ELM applications are shut down and there are no active database connections.

  • The data warehouse is backed up.

  • You have DBA privileges to run DDL statements.

  • No Data Warehouse jobs or report queries are running.

  • LQE rs and related services are stopped.

When this update applies

This DDL update is required only if:

  • You are performing rollback to ELM 7.1 interim fix 008 or earlier

  • Your current version is interim fix 009 or later than interim fix 009

 

Steps

  1. Connect to the Data warehouse database.

  2. Run the appropriate DDL script for your vendor.

    Db2 Database : 

    -- =========================================
-- ROLLBACK SCRIPT
-- =========================================


SET CURRENT SCHEMA = RITRS;
COMMIT;


DROP INDEX CACHED_CONFIG_IDX3;

DROP INDEX CACHED_CONFIG_ALL_SELECTS_IDX1;
DROP INDEX CACHED_CONFIG_ALL_SELECTS_IDX2;
DROP INDEX CACHED_CONFIG_ALL_SELECTS_IDX3;

DROP INDEX F_TEST_RESULT_TOTALS_IDX6;

DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX1;
DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX2;
DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX3;
DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX4;

COMMIT;


ALTER TABLE CACHED_CONFIG_ALL_SELECTS
    DROP CONSTRAINT CACHED_CONFIG_ALL_SELECTS_FK1;

COMMIT;


DROP TABLE CACHED_CONFIG_ALL_SELECTS;

DROP TABLE F_ARCHITECTURE_ELEMENT_TOTALS;

COMMIT;


ALTER TABLE CACHED_CONFIG DROP COLUMN LAST_USED;
ALTER TABLE CACHED_CONFIG DROP COLUMN EXPIRED;

ALTER TABLE F_WORK_ITEM_TOTALS DROP COLUMN TOTAL_STORY_POINTS;
ALTER TABLE F_WORK_ITEM_CREATION DROP COLUMN TOTAL_STORY_POINTS;
ALTER TABLE F_WORK_ITEM_CLOSURE DROP COLUMN TOTAL_STORY_POINTS;

ALTER TABLE F_TEST_RESULT_TOTALS DROP COLUMN TEST_CASE_STATE_ID;

COMMIT;


SET CURRENT SCHEMA = CONFIG;

UPDATE SYSCONFIG_INFO
SET INT_VALUE = 74,
    CHAR_VALUE = '74.0'
WHERE INFO_ID = 17;

COMMIT;


DROP TABLESPACE USERTEMPSPACE32K;

COMMIT;

-- =========================================
-- END OF ROLLBACK
-- =========================================


    Oracle Database  :

    
-- =========================================
-- ROLLBACK SCRIPT
-- =========================================


ALTER SESSION SET CURRENT_SCHEMA = CONFIG;


UPDATE SYSCONFIG_INFO SET INT_VALUE=74, CHAR_VALUE='74.0' WHERE INFO_ID=17;
COMMIT;

ALTER SESSION SET CURRENT_SCHEMA = RITRS;

DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX4;
DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX3;
DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX2;
DROP INDEX F_ARCHITECTURE_ELEMENT_TOTALS_IDX1;
DROP TABLE F_ARCHITECTURE_ELEMENT_TOTALS;
COMMIT;

DROP INDEX F_TEST_RESULT_TOTALS_IDX6;
COMMIT;

ALTER TABLE F_TEST_RESULT_TOTALS DROP COLUMN TEST_CASE_STATE_ID;
COMMIT;

ALTER TABLE F_WORK_ITEM_CLOSURE DROP COLUMN TOTAL_STORY_POINTS;
COMMIT;

ALTER TABLE F_WORK_ITEM_CREATION DROP COLUMN TOTAL_STORY_POINTS;
COMMIT;

ALTER TABLE F_WORK_ITEM_TOTALS DROP COLUMN TOTAL_STORY_POINTS;
COMMIT;

DROP INDEX CACHED_CONFIG_ALL_SELECTS_IDX3;
DROP INDEX CACHED_CONFIG_ALL_SELECTS_IDX2;
DROP INDEX CACHED_CONFIG_ALL_SELECTS_IDX1;
ALTER TABLE CACHED_CONFIG_ALL_SELECTS DROP CONSTRAINT CACHED_CONFIG_ALL_SELECTS_FK1;
DROP TABLE CACHED_CONFIG_ALL_SELECTS;
COMMIT;

ALTER TABLE CACHED_CONFIG DROP COLUMN EXPIRED;
COMMIT;

DROP INDEX CACHED_CONFIG_IDX3;
COMMIT;

ALTER TABLE CACHED_CONFIG DROP COLUMN LAST_USED;
COMMIT;

SELECT 'Rollback completed successfully' AS STATUS FROM DUAL;

     

Important: If you do not run the DDL scripts during the rollback:

  • A warning message appears on the LQE Data Provider page.

    Image displaying the LQE Data Provider page:
     
     

  • LQE indexing stops and does not progress.
  • This warning message appears in lqe.log: [ lqe.PgsIndexer-thread-0] WARN ion.lqe.lib.dataset.pgs.sql5.SqlGraphStoreProvider [TID: 3ED56D8D] - The data warehouse version 76 is not compatible with LQE which requires version 74. The SQL graph store provider cannot initialize but will keep retrying.

Page Feedback