[Backport 2.x] Fix returns 500 error for AI agent APIs when OpenSearch returns 4xx error with json format error message

[Backport 2.x] Fix returns 500 error for AI agent APIs when OpenSearch returns 4xx error with json format error message #1458