When you apply the Host Profile settings in a host using the Remediate option, all the enabled policies in the Host Profile are applied to the host. One of the policies is Core Dump Configuration. When Host Profile engine tries to apply this policy, it first tries to query if any core dump partition is configured on the host. If that query fails for any reason, you see this error message and the Remediate task fails.
One of the common reasons for the failure of this query is if the LUN or device on which the coredump partition was configured on the host is no longer available on the host. It can happen if the administrator or user has removed that disk/LUN from the host but forgot to reconfigure a new coredump partition on the host.