-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
Affects Version/s: 7.13.6, 7.13.7
-
Component/s: Site - Backup / Import
-
7
-
Severity 2 - Major
-
2
Problem
Oracle Database export and import failed with the below error. If the export is generated from a different DB which has a schema name as XYZ and that DB export import into the new DB which has a different Scheman name, DB import gets failed.
ORA-39083: Object type TABLE:"XYZ"."DENORMALISED_CONTENT_CHANGE_LOG" failed to create with error: ORA-02289: sequence does not exist Failing sql is: CREATE TABLE "XYZ"."DENORMALISED_CONTENT_CHANGE_LOG" ("ID" NUMBER(19,0) DEFAULT "KMS_P"."DENORMALISED_CONTENT_CHANGE_LOG_SEQ"."NEXTVAL" NOT NULL ENABLE, "CONTENT_ID" NUMBER(19,0), "CPS_ID" NUMBER(19,0)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ATEAM_TS" ORA-39083: Object type TABLE:"XYZ"."DENORMALISED_SPACE_CHANGE_LOG" failed to create with error: ORA-02289: sequence does not exist Failing sql is: CREATE TABLE "XYZ"."DENORMALISED_SPACE_CHANGE_LOG" ("ID" NUMBER(19,0) DEFAULT "KMS_P"."DENORMALISED_SPACE_CHANGE_LOG_SEQ"."NEXTVAL" NOT NULL ENABLE, "SPACE_ID" NUMBER(19,0)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ATEAM_TS"
Steps to Reproduce
Steps to Reproduce
- Create two databases test1 and test2 on the 2 other Oracle servers.
- Install Confluence 7.13.7 using the test1 database in one Oracle Database
- Now export the Confluence 7.13.7 Oracle DB where schema name was XYZ
- Import this export file into the other Oracle DB where Schemaname is ABC. This import will get failed. This seems to be an issue with the below tables which have been created for fast permission.
- DENORMALISED_SPACE_CHANGE_LOG
- DENORMALISED_CONTENT_CHANGE_LOG
Expected Results
There would not be any Schema name in the table by default so importing DB export will not get failed because of this.
Actual Results
Import is getting failed with the following error:
ORA-39083: Object type TABLE:"XYZ"."DENORMALISED_CONTENT_CHANGE_LOG" failed to create with error: ORA-02289: sequence does not exist Failing sql is: CREATE TABLE "XYZ"."DENORMALISED_CONTENT_CHANGE_LOG" ("ID" NUMBER(19,0) DEFAULT "KMS_P"."DENORMALISED_CONTENT_CHANGE_LOG_SEQ"."NEXTVAL" NOT NULL ENABLE, "CONTENT_ID" NUMBER(19,0), "CPS_ID" NUMBER(19,0)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ATEAM_TS" ORA-39083: Object type TABLE:"XYZ"."DENORMALISED_SPACE_CHANGE_LOG" failed to create with error: ORA-02289: sequence does not exist Failing sql is: CREATE TABLE "XYZ"."DENORMALISED_SPACE_CHANGE_LOG" ("ID" NUMBER(19,0) DEFAULT "KMS_P"."DENORMALISED_SPACE_CHANGE_LOG_SEQ"."NEXTVAL" NOT NULL ENABLE, "SPACE_ID" NUMBER(19,0)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ATEAM_TS"
Workaround
- Try to replace the old schema name with the new schema name in the dump file before importing it.
- Or Import using the same schema name, run the ALTER TABLE, export a Dump from that new database, and then should be able to import using a new schema name without issues.
- mentioned in
-
Page Loading...