Checked the error encountered error by the user, as per checking of the message, the error is the subquery is returning two records which will return an error as subquery should return 1 record only, executed the parsing on my side to check where it is encountering an error and debugged the application as well to check what it is running, as of now, the parsing still executing and no error encountered.