Performance issues can occur when you use SAS Web Report Studio 4.2 in an OLAP server environment. The problems happen because large-endurance OLAP queries that are executed in SAS Web Report Studio have an adverse effect on the SASServer Java virtual machine (JVM).
In particular, there are two symptoms that you might see as a result of these issues:
"WRSThreadPool 1": at com.sas.apps.citation.model.report.RenderingImpl.getUniqueKey(RenderingImpl.java :506) <---- cause - waiting to lock <0x00002aaad6c54030> (a com.sas.apps.citation.model.user.Locks$RenderLock) at com.sas.apps.citation.model.report.QueryConnectorManager.getRendererKey(QueryCon nectorManager.java:423) at com.sas.apps.citation.model.report.QueryConnectorManager.cleanupPendingClients(Q ueryConnectorManager.java:266)
6,240,587,528 (72.63%) [72] 24 class com/sas/storage/olap/sasmdx/RemoteMetadata 0xffffffff3d943710 |- 6,231,965,368 (72.53%) [88] 3 com/sas/storage/olap/sasmdx/MembersCache 0xfffffff551236380 |- 6,231,965,200 (72.53%) [128] 6 array of java/util/HashMap$Entry 0xfffffff552320b28 |- 5,855,680,224 (68.15%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff558a8c330 |- 5,845,288,576 (68.03%) [72] 4 java/util/LinkedHashMap 0xfffffff5512a3b20 |- 5,845,288,400 (68.03%) [262,144] 14,371 array of java/util/HashMap$Entry 0xfffffff6bc622660 |- 274,908,776 (3.2%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff5825ee360 |- 216,406,824 (2.52%) [56] 5 java/util/LinkedHashMap$Entry 0xfffffff6ee3bd2a8 |- 199,266,936 (2.32%) [56] 5 java/util/LinkedHashMap$Entry 0xfffffff66e8b8c90 |- 189,018,840 (2.2%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff6d45d68c8 |- 188,985,688 (2.2%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff652cab4c0 |- 122,428,720 (1.42%) [56] 5 java/util/LinkedHashMap$Entry 0xfffffff670037f78 |- 121,255,552 (1.41%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff5604a5e68 |- 103,604,416 (1.21%) [56] 5 java/util/LinkedHashMap$Entry 0xfffffff792516180 |- 103,470,816 (1.2%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff560480f98 |- 100,326,672 (1.17%) [56] 5 java/util/LinkedHashMap$Entry 0xfffffff743acb5d0 |- 98,161,944 (1.14%) [56] 4 java/util/LinkedHashMap$Entry 0xfffffff66774a2a8
These problems are fixed in the second maintenance release for SAS Web Report Studio 4.31 (M2). The only resolution for the problems is to upgrade to that release of SAS Web Report Studio.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Web Report Studio | Microsoft® Windows® for x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 for x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 R2 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 for x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Microsoft Windows XP Professional | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Enterprise 32 bit | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Enterprise x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Home Premium 32 bit | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Home Premium x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Professional 32 bit | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Professional x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Ultimate 32 bit | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows 7 Ultimate x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows Vista | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Windows Vista for x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
64-bit Enabled AIX | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
64-bit Enabled Solaris | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
HP-UX IPF | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Linux for x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 | |||
Solaris for x64 | 4.2 | 4.31_M2 | 9.3 TS1M0 |
A fix for this issue for SAS Web Report Studio 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D26.html#53237A fix for this issue for SAS Web Report Viewer 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D27.html#53237A fix for this issue for SAS Web Report Studio 4.31_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G28.html#53237A fix for this issue for SAS Web Report Viewer 4.31_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G29.html#53237Type: | Problem Note |
Priority: | alert |
Date Modified: | 2014-06-17 15:21:18 |
Date Created: | 2014-06-17 11:51:42 |