Add '[in-proc] Return metadata provider task whether it is successful or not (#10599)'

[v-selvarajbh]

Issue describing the changes in this PR

Cherry picked '[in-proc] Return metadata provider task whether it is successful or not (#10599)' from in-proc to 'release/in-proc/4.37.0'

Pull request checklist

IMPORTANT: Currently, changes must be backported to the in-proc branch to be included in Core Tools and non-Flex deployments.

• Backporting to the in-proc branch is not required
  • Otherwise: Link to backporting PR
• My changes do not require documentation changes
  • Otherwise: Documentation issue linked to PR
• My changes should not be added to the release notes for the next release
  • Otherwise: I've added my notes to release_notes.md
• My changes do not need to be backported to a previous version
  • Otherwise: Backport tracked by issue/PR #issue_or_pr
• My changes do not require diagnostic events changes
  • Otherwise: I have added/updated all related diagnostic events and their documentation (Documentation issue linked to PR)
• I have added all required tests (Unit tests, E2E tests)

Additional information

Additional PR information

[v-selvarajbh]

/azp run

[azure-pipelines]

Azure Pipelines could not run because the pipeline triggers exclude this branch/path.

[v-selvarajbh]

/azp run host.public

[azure-pipelines]

Azure Pipelines could not run because the pipeline triggers exclude this branch/path.