How To
Summary
In some scenarios, a configuration push may get stuck in a pending state. To clear such stuck configuration pushes in your Cloud Pak for Security (CP4S) environment, follow these steps using oc commands.
Steps
1. Extract Database Credentials from OpenShift Secrets
DBOPORT=$(oc extract secret/mondbo-postgres-user --to - --keys port)
DBOHOST=$(oc extract secret/mondbo-postgres-user --to - --keys host)
DBODB=co3
DBOUSER=$(oc extract secret/mondbo-postgres-user --to - --keys user)
DBOPWD=$(oc extract secret/mondbo-postgres-user --to - --keys password)
2. Check for Pending Configuration Push Entries
Run the following command to identify entries with
cph_status = 0, which indicates a pending status:
QUERY="select cph_id, cph_description from monapp.configuration_push_histories where cph_status = 0 order by cph_id desc;"
oc exec -it deploy/cp-serviceability -- psql "postgresql://$DBOUSER:$DBOPWD@$DBOHOST:$DBOPORT/$DBODB" -P pager=off -c "$QUERY"
Note: Identify the
cph_id from the output that corresponds to the stuck configuration push.3. Manually Clear the Stuck Push
Once you have the
cph_id value, run the command below to update the status from pending (0) to completed (2). Replace xx with the actual cph_id.
QUERY1="update monapp.configuration_push_histories set cph_status = 2 where cph_status = 0 and cph_id = xx;"
oc exec -it deploy/cp-serviceability -- psql "postgresql://$DBOUSER:$DBOPWD@$DBOHOST:$DBOPORT/$DBODB" -P pager=off -c "$QUERY1"
After the above command runs successfully, the stuck configuration push should be cleared, and the system can proceed with future pushes.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTDPP","label":"IBM Cloud Pak for Security"},"ARM Category":[{"code":"a8m0z0000001h8pAAA","label":"Support-\u003ECases"}],"ARM Case Number":"TS019539537","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.10.0;1.11.0"}]
Was this topic helpful?
Document Information
Modified date:
10 July 2025
UID
ibm17238346