BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

User Notification Events - CAUTION


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
Macroman
Principal Member
Principal Member



Joined: 13 Nov 2002

Posts: 263


flag
PostPosted: Mon Jul 08, 2019 2:23 am 
Post subject: User Notification Events - CAUTION

For about 3-4 months now and intermittently our server was slow to respond to queries both CMC and BI Launchpad and we often had to stop SIA , clean tomcat cache and restart to bring it back to life. We are on Windows server 2016 , 64Gb RAM and BI 4.2 Sp5. Both CPU and RAM resources, disk and network were all fine. Eventually we engaged various different IT teams to assist us as Administrators of the environment to find the cause. And our DBA's came up trumps and found it. If you have a lot of customers and we do, over 15k , 4k of which have been using BI and approx.150 different users per day each day. DO NOT use Events and User Notification Events , it will query a particular table which stores the event notification in a BLOB column for each user that exists in any groups you subscribe to the User Notification Event. We have 3 primary user groups, Writers, Guests and Consumers totally , 4800 plus users. each time a person logs onto BI Launchpad the table is queried fetching 4800 rows for each user notification that is active, we had 3, so any time a person logs on the table is queried fetching all those rows with a blob column type bringing our environment to a grinding halt. The table in question is CMS_RELATIONS7 and column is DATA which is a BLOB column type. We also found that when a user goes back to BI Launchpad homepage the table is queried again. We had at one point 32,800 row selects from this table. I have now deleted all User Notification Events and advised my colleagues not to use it, instead I have written my own message system in which message will appear on BI Launchpad logon page.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19316
Location: Bratislava


flag
PostPosted: Mon Jul 08, 2019 5:00 pm 
Post subject: Re: User Notification Events - CAUTION

Hi,

This is a known problem and is fixed in particular patches. More details in the KBA 2328524 here:
https://launchpad.support.sap.com/#/notes/2328524

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Macroman
Principal Member
Principal Member



Joined: 13 Nov 2002

Posts: 263


flag
PostPosted: Tue Jul 09, 2019 2:57 am 
Post subject: Re: User Notification Events - CAUTION

Thank you Marek alas as we have terminated support contract with SAP we no longer can patch beyond what we have which is Sp5. Guess we will stick with my workaround, although be interesting to know from others if they can confirm the issue is actually resolved. Thank you once again icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0273 seconds using 18 queries. (SQL 0.0021 Parse 0.0008 Other 0.0243)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo