JCP/CP table creation assumes default tablespace names

Document ID : KB000126471
Last Modified Date : 11/02/2019
Show Technical Document Details
Issue:
On Automation Engines using an Oracle DB, when trying to start an additional CP or JCP a new table should be created. However, if the tablespace names of the AE DB are other than UC4_DATA and UC4_INDEX this fails.

The following error appears in the CP log:
U00003590 UCUDB - DB error: '42000', 'ORA-00959: tablespace 'UC4_DATA' does not exist 
U00045142 Cannot create table 'MQ1CP<xxx>'. 

where <xxx> corresponds to the number of the CP to be created.
Environment:
Oracle
Cause:
The Automation Engine assumes the standard tablespace names UC4_DATA and UC4_INDEX. These names are the recommended ones.
Resolution:
If you need to use other tablespace names than the standard, you need to replace UC4_DATA and UC4_INDEX.

Except for UC_DDL.SQL, necessary for the DB load, also a modification in the AE DB is necessary for the automatic creation of additional CP tables.

The following field needs to be edited:
select DBSYN_CONTENT from UC_DBSYN where DBSYN_TYPE= 'CREATE_MQCP' and DBSYN_DB = 'ORACLE';

Alternatively, you may create the additional CP table manually as describes here:
https://comm.support.ca.com/kb/sql-statements-to-create-additional-cpa/KB000112281