data not getting cleared from buffer table

, ,
1

Hi,
I am using Insert notification and it was performing well but suddenly it has stooped working,
the data from buffer table is not cleared.
also restarted the IS but the same problem exists.
how we can fix it

Thanks in Advance

2

Check if your notification is enabled and monitor the service usages for any hung thread.

Please confirm how you are inserting the data in to table. I have often seen ppl manually inserting the data in to table and forgetting to commit it. Please note the insert notification can pick data once its commited in the db.