nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Deleting rows on messages and message_handles

slk

Hi,

Could any one let me know whether it is OK to empty the messages and message_handdles tables on eventsubsystem database (Oracle). Does this affect the Report Center later on when we install it. Currently only search is using eventsubsystem.

Thanks!

Find more posts tagged with

Comments

Migrateduser

In my experience with RC, yes it will be affected if you delete those rows.

The RC process reads the messages, parses the blobs, and then does appropriate inserts into the tables in the RC DB.

So, if you delete the messages, RC will not have anything to process when you install it. However, that may not be a bad thing for you, if you want to call that day "day zero" and ignore anything that may have happened before.

slk

In my experience with RC, yes it will be affected if you delete those rows.

The RC process reads the messages, parses the blobs, and then does appropriate inserts into the tables in the RC DB.

So, if you delete the messages, RC will not have anything to process when you install it. However, that may not be a bad thing for you, if you want to call that day "day zero" and ignore anything that may have happened before.

Thanks for your answer!

At the same time I heard these tables get cleaned up when subscribers such as search consumed them. For example, I have noticed that row count has gone down to 80,000 from two million.

Does this mean it stores data somewhere else? or just cleared the rows?

Thanks!

Migrateduser

Thanks for your answer!

At the same time I heard these tables get cleaned up when subscribers such as search consumed them. For example, I have noticed that row count has gone down to 80,000 from two million.

Does this mean it stores data somewhere else? or just cleared the rows?

Thanks!

Yes, they do. Report Center is a subscriber and will remove rows as it parses them and inserts the information into the reporting database's tables. However, since I believe you said you hadn't installed RC yet, I don't know where your rows are going.

slk

Thanks for your reply! Can search remove the rows after consumed them?

Migrateduser

Thanks for your reply! Can search remove the rows after consumed them?

I don't know. We haven't been able to get search up and running.

buddha1

Hi,
we can remove the rows regardless the rows are consumed by RC or not. Anyways, you arent using the RC.
Try, iw-home\httpd\webapps\eventsubsystem\WEB-INF\
iw_bridge_cfg.xml

configure iw_bridge_cfg.xml, in this we have expiryTimeInDays = "2", that means the Eventsub sytem DB rows would be wiped out when the rows are 2 days old.

Regards,
Kishore