Grouping the errors in broadlogMsg table

Forum|Forum|4 years ago
January 21, 2022
1 reply
960 views

Hi Team,

Please help me understand how can we group the similar kind of error entries in broadlogMsg table in one record, for example, in below screenshot, which will help in reducing the number of error entries in this table or please let me know if this should not be tried as it might lead to some unseen problems in future or if its recommended to delete the extreme old entries from broadlogMsg table?

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Jyoti_Yadav

Hi @poonam_dogra ,

No, you should not alter the table records. These are with respect to each recipient delivery. If you delete them, you will not be able to see error message with respect to each recipient.

If you want to group them and see what are different types of error that exist in the database, then use query activity. Use Group by functionality of query activity. Group the result by 'Reasons'.

Thanks,

Jyoti

Jyoti_YadavAccepted solution

Level 8

Hi @poonam_dogra ,

No, you should not alter the table records. These are with respect to each recipient delivery. If you delete them, you will not be able to see error message with respect to each recipient.

If you want to group them and see what are different types of error that exist in the database, then use query activity. Use Group by functionality of query activity. Group the result by 'Reasons'.

Thanks,

Jyoti

P

Poonam_DograAuthor

Level 4

Thank you @jyoti_yadav for response!

Point taken, the broadlogmsg entries should not be altered. Actually I was thinking to re-group in the table itself to reduce the number of entries in it but since its not recommended to alter this table we will go some other route.

Thanks once again!

Cheers!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded