I must be missing something obvious. But I am not able to get the details of the error.
There is no way to know exact error returned by lambda.
Per this AWS blog post you should be able to use the "CloudWatch console, utilize Logs Insights to query platform logs that Lambda sends for each function execution."