Error Message :
When adding a new CP (i.e. CP006 and only CP tables up to CP005 exist) and the alternative MS-SQL Schema is in use the communication processes are only created in the Main-DB without any Synonym for the MQ-DB (Message Queue Database).
The added tables are also not renamed and there is no link between the Main-DB and the splitted MQ-DB for the new process.
Root Cause: With Automation Engine Version 12.1.2 there will be a new message "Cannot create a new MQCP (&01) table because you are using an alternative DB schema for MS-SQL. Please create the table manually."
Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
A CP/WP has no information about a split schema and therefore cannot create tables in the split DB.
In V12.1 four Communication Processes (CPs) will handle approximately 400000 connections. Therefore, it might not be necessary to add additional CPs. Just add them if necessary - this approach is more resource-conserving.
Steps to create additional CPs in the database manually when the alternative MS SQL Server Schema is in use:
All the following SQL-Queries can be found in our Documentation:
Step 1 (optional: must only be considered if additional CP tables have already been created in the Main-DB):
If there were already tables added for new Communication Processes in the Main-DB (because additional processes were started before) these need to be renamed to e.g.: _ucorig.
With the following script you can select all server processes to rename them afterwards (on the Main-DB)