Replacing 21.0.3 projects and project databases when upgrading to 24.0.0 with Automation Document Processing

Steps

1. Complete all steps for upgrading your Cloud Pak for Business Automation 21.0.3 deployment to 24.0.0 as documented at Upgrading from 21.0.3.
2. If you have any existing projects, first back up the associated project databases.  These cannot be restored back into 24.0.0 but will keep a record of what the project contents were.
3. From the BAStudio (Zen) page, delete each Automation Document Processing project.  This will mark the associated project databases for deletion.
4.  To mark all remaining project databases for deletion, connect to your base database and run this command.

   update tenantinfo set DBSTATUS=2;

5. Run the 24.0.0 ProjectDelete.sh script.  All database scripts are located in your case package at ibm-cp-automation\inventory\cp4aOperatorSdk\files\deploy\crs\cert-kubernetes\ACA\configuration-ha\DB2.
6. Create new project databases.
   1. For each project database to be created, run the 24.0.0 AddTenant.sh script.
   2. Edit the custom resource yaml for the Cloud Pak for Business Automation deployment and update the database names in datasource_configuration, dc_ca_datasource, tenant_databases.
   3. Edit the aca-basedb secret with the names and passwords of the new databases.  For more information the aca-basedb secret, see Creating secrets to protect sensitive Document Processing configuration data.
7. Allow about an hour for the changes to propagate through the system, after which you can create new 24.0.0 projects.