An error occurred while creating data warehouse tables. Please try again.ID CRJAZ1745E
Accepted answer
This issue was solved by the PMR John had opened.
In the jts data warehouse connected successfully. When testing connection in the ccm data warehouse in setup, it connected successfully and mentioned that they needed to create tables for the data warehouse. Once the customer created tables, it gave the error "Caused by: java.sql.SQLException: ORA-01543: tablespace 'VNF_IDX' already exists".
The cause of this error was that the schema prefix not being set for the CCM data warehouse, as it was set for the JTS database. After adding the schema prefix, they were able to proceed with the ccm data warehouse configuration.
In the jts data warehouse connected successfully. When testing connection in the ccm data warehouse in setup, it connected successfully and mentioned that they needed to create tables for the data warehouse. Once the customer created tables, it gave the error "Caused by: java.sql.SQLException: ORA-01543: tablespace 'VNF_IDX' already exists".
The cause of this error was that the schema prefix not being set for the CCM data warehouse, as it was set for the JTS database. After adding the schema prefix, they were able to proceed with the ccm data warehouse configuration.
2 other answers
Hi John,
The error message indicates that tablespace 'VNF_IDX' already exists. So, it is possible that the data warehouse database was created before. If you do not expect any data warehouse database to exist (for this CLM and any other CLMs using this same Oracle) and would like to drop/clean data files that were incorrectly created before, you can review the steps the 'Dropping the data warehouse' section in
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup
Only one data warehouse database is needed per JTS. All the applications registered with the JTS will be using the same data warehouse database. So, when you step thru the jts/setup, you will need to enter the DW database connection information and create tables for the DW database only in the JTS's configure data warehouse section. The 'configure data warehouse' page of the other application (CCM, QM) will reuse the same information you entered previously.
The error message indicates that tablespace 'VNF_IDX' already exists. So, it is possible that the data warehouse database was created before. If you do not expect any data warehouse database to exist (for this CLM and any other CLMs using this same Oracle) and would like to drop/clean data files that were incorrectly created before, you can review the steps the 'Dropping the data warehouse' section in
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup
Only one data warehouse database is needed per JTS. All the applications registered with the JTS will be using the same data warehouse database. So, when you step thru the jts/setup, you will need to enter the DW database connection information and create tables for the DW database only in the JTS's configure data warehouse section. The 'configure data warehouse' page of the other application (CCM, QM) will reuse the same information you entered previously.