My Oracle Support Banner

Data Is Deleted Automatically From OSB Reporting Tables WLI_QS_REPORT_ATTRIBUTE & WLI_QS_REPORT_DATA (Doc ID 2387721.1)

Last updated on MAY 11, 2018

Applies to:

Oracle Service Bus - Version and later
Information in this document applies to any platform.


Inserts done into OSB Reporting tables WLI_QS_REPORT_DATA and WLI_QS_REPORT_ATTRIBUTE are being deleted within seconds of insert. The DELETE statements below are seen continuously running against the DB:

DELETE FROM WLI_QS_REPORT_ATTRIBUTE WHERE MSG_GUID IN (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21,:22 ,:23 ,:24 ,:25 ,:26 ,:27 ,:28 ,:29 ,:30 ...


There was an attempt to kill the DB sessions associated with these statements, but they re-appeared immediately after.

Analysis of the DB V$SESSION view identified that this was originating from the OSB Domain.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.