Uthman bin Abu As reported,

The Prophet ﷺ said, "The gates of heaven are opened at midnight, and a caller calls out, 'Is there anyone supplicating, that his prayer may be answered? Is there anyone asking, that he may be granted? Is there anyone distressed, that his distress may be relieved?' No Muslim makes a supplication except that Allah عز وجل answers him, except for a prostitute who trades with her body, or a tax collector."

Azami 10947

Hasan

عن عثمان بن أبي العاص الثقفي

عن النبي ﷺ قال: تفتح أبواب السماء نصف الليل، فينادي مناد: هل من داع فيستجاب له، هل من سائل فيعطى، هل من مكروب فيفرج عنه، فلا يبقى مسلم يدعو بدعوة إلا استجاب الله عز وجل له، إلا زانية تسعى بفرجها، أو عشارا.

الأعظمي 10947حسن
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Supplications, remembrances, and prayer upon the chosen Prophet ﷺ
Chapter
Rulings on supplication
Section
Those whose supplication is not answered
Numbering
Jami al-Kamil 10947 (2nd edition)
Azami 10947