In my case the error was due an error in the Security group configuration.
RDS cluster security group must accept inbound connections from your proxy security group.
Your proxy security group must accept inbound connections from your instances.
https://repost.aws/questions/QUAAbHAAI_SmWN2pwWr_32dw/aws-rds-proxy-stuck-with-pending-proxy-capacity