Troubleshooting OpenPages backup and restore

Important: IBM Cloud Pak® for Data Version 4.8 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.

When you back up and restore your OpenPages instance in Cloud Pak for Data, you might encounter the following issues.

URL_PREFIX attribute points to source cluster

After you restore Cloud Pak for Data and an OpenPages tethered namespace to a new cluster by using the cpd-cli oadp command, the URL_PREFIX attribute of the product-configmap for the tethered namespace might still point to the source cluster.

To fix this problem, manually update the URL_PREFIX attribute of the product-configmap.

Because the CPD route gets updated during Zen reconciliation, you must restart the openpages-sts pods after the restore by running the following command:

for i in `oc get pods | grep openpages-<instancename>-sts |  cut -f1 -d\ `; do oc delete po ${i}; done

Db2 error: write operations for the database are suspended

When you are backing up or restoring an OpenPages environment, a Db2® pod might report the following error:

[db2inst1@c-db2oltp-1621935580993371-db2u-0 - Db2U db2inst1]$ db2 connect to OPX
SQL1552N  The command failed because write operations for the database are suspended 
or are being suspended.

If this Db2 error appears after a backup, run the following command:

./cpd-cli oadp backup posthooks --include-namespaces <namespace>

If this Db2 error appears after a restore, run the following command:

./cpd-cli oadp restore posthooks --include-namespaces <namespace>

Time out error during a restore

When you are doing an offline restore of Cloud Pak for Data and an OpenPages instance into a different cluster, you might see the following error in the cpd-cli log:
time=2023-09-06T13:33:36.145727Z level=error 
msg=failed to wait for statefulset openpages-openpagesinstance-with-25-sts in 
namespace zen-ns: timed out waiting for the condition
To resolve the issue, do the following steps:
  1. Manually scale OpenPages down to 0 replicas.
    oc scale --replicas=0 sts/openpages-<instance_name>-sts
  2. Rerun the restore posthooks step from Restoring an offline backup to a different cluster with the Cloud Pak for Data OADP backup and restore utility. 
    cpd-cli oadp restore create <restore_name6> \
--from-backup=<backup_name1> \
--include-resources='namespaces,clusters.postgresql.k8s.enterprisedb.io' \
--include-cluster-resources=true \
--posthooks=true \
--log-level=debug \
--verbose
  3. Scale back up to the number of replicas that you want to use for OpenPages.
    oc scale --replicas=<n> sts/openpages-<instance_name>-sts

    Replace <n> with the number of replicas.