After reviewing the certificates using the BOSH API endpoint, there are bosh_dns client and server certificates listed as expired:
"/bosh_dns_health_server_tls" "/bosh_dns_health_client_tls" "/dns_api_server_tls" "/dns_api_client_tls"
After checking the credhub using How to login and access Credhub in Tanzu Application Service (TAS), it looks like all these certificates are already rotated and have a valid expiry dates.
This is issue is caused by the on-demand service-instance not being properly recreated after the rotation of certificates.
bosh manifest download <service-instance-deployment> > <service-instance-deployment>.yaml
bosh deploy <service-instance-deployment>.yaml --recreate