Defects
Application Engen: Notification history contains only one recipient if item is in Auxiliary table
ID: | D28004 | |
Published: | 08 August 2023 |
Defect Id
DEF348692
Originally Reported Against
SBM 12.1
Also Affects
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM SBM 12.1 Hotfix
Status
Submitted
Description
Need to implement Auxiliary table case for "Notification History" section.
Here is info from ns.log:
INFO 08-08-2023 01:09:30 [Events] -- Starting EventEvaluation task.
INFO 08-08-2023 01:09:30 [Events] -- Initial send for event 5, Tbl:ItemId 1007:2, sending notification 'Aux notification1'
INFO 08-08-2023 01:09:30 [Events] -- Added Message id 6; notification='Aux notification1'; user = 'admin', userid = 8, event = 5, Tbl:ItemId 1007:2
INFO 08-08-2023 01:09:30 [Events] -- Added Message id 7; notification='Aux notification1'; user = 'admin2', userid = 31, event = 5, Tbl:ItemId 1007:2
INFO 08-08-2023 01:09:30 [Events] -- Removing event 5, Tbl:ItemId 1007:2, from Events Table because there's no escalation conditions
INFO 08-08-2023 01:09:50 [Messages] -- Message with id = 7 successfully sent to recipient(admin2 <sergey2@sbmmail.com>) with userid = 31 [tableId=1007, itemId=2]
INFO 08-08-2023 01:09:50 [Messages] -- Message with id = 6 successfully sent to recipient(Administrator <sergey1@sbmmail.com>) with userid = 8 [tableId=1007, itemId=2]
INFO 08-08-2023 01:10:00 [DeleteFinishedEventProcess] -- 1 marked as finished events were physically deleted.
Both recipients got email notifications but item has only one recipient reported.
After restart IIS & Tomcat, reopening same aux item got one recipient so it is not a cache issue.
Sql query select * from TS_VIEWSTATUSNOTIFICATION return both recipients.
Resolution
Planned to be resolved in SBM 12.2