This is a strange hadith.

149 – Chapter

3925 – Yahya ibn Musa narrated to us, saying: Abu Mu‘awiyah narrated to us, saying: al-Layth – meaning Ibn Abi Sulaym – narrated to us, from Ziyad, from Abu Hurayrah, who said: The Messenger of Allah, peace and blessings be upon him, said: "There is no man who supplicates with a supplication but that it is answered for him – either it is hastened for him in this world, or it is stored up for him in the Hereafter, or expiation is made for him of his sins to the extent of what he supplicated – as long as he does not supplicate for something sinful, or for the severing of family ties, or does not seek to hasten it." They said: "O Messenger of Allah, how does one seek to hasten it?" He said: "He says: 'I supplicated to my Lord, but He did not answer me.'"

--------------------------------------------
= It is also in al-Musnad (8101).

(1) The hadith is authentic by virtue of its multiple chains and supporting witnesses, but this chain is weak due to the poor memory of Layth ibn Abi Sulaym. There is disagreement regarding the identification of his shaykh Ziyad, as recorded in al-Bukhari's al-Tarikh al-Kabir 3/367.

It was also recorded in a more concise form than what is here, within a hadith by Abu Ya‘la (6134), via the path of ‘Ubaydullah ibn ‘Amr al-Raqqi, from Layth ibn Abi Sulaym, with this chain.

It was also recorded in similar form, in segments, by Ahmad (9148) and (9785), al-Bukhari (6340), Muslim (2735), Abu Dawud (1484), Ibn Majah (3853), and Ibn Hibban (881), (975), and (976), via other paths from Abu Hurayrah.

On this topic, there is also a hadith from ‘Ubadah ibn al-Samit, which preceded with the author under number (3890), and its chain is good.

And from Abu Sa‘id al-Khudri, in Ahmad (11133), and its chain is sound.

See what follows it.