Direct links to fixes
APAR status
Closed as program error.
Error description
A cache entry that contains user details is found only when the user name exactly matches the user name used during the first cache access. Subsequent cache accesses with different capitalization do not find the cache. As a result, the system tries repeatedly to access the IBM Business Process Manager (BPM) database to get the user details and performance degrades. The following SQL which appears in BPM database traces or from long running or high fequency SQL calls on a database report is improved by this fix. select t0.USER_ID,t0.USER_NAME,t0.FULL_NAME,t0.PROVIDER from LSW_USR_XREF t0 where UPPER(USER_NAME) = ? There may also be hung thread messages like this [11/22/16 14:37:38:917 CST] 00000082 ThreadMonitor W WSVR0605W: Thread "WebContainer : 15" (000003be) has been active for 645,731 milliseconds and may be hung. There is/are 1 thread(s) in total in the server that may be hung. at java.net.SocketInputStream.socketRead0(Nat ... at com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO .executeQuery(UnversionedPODAO.java:233) at com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO .findOrdered(UnversionedPODAO.java:222) at com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO .findOrdered(UnversionedPODAO.java:207) at com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO .find(UnversionedPODAO.java:203) at com.lombardisoftware.server.ejb.persistence.dao.UserDAO.findByFi lter(UserDAO.java:74) at com.lombardisoftware.server.core.UserCore.findByFilter(UserCore. java:652) at com.lombardisoftware.server.core.cache.UserInfoCache.getUserInfo (UserInfoCache.java:134) at com.lombardisoftware.server.core.cache.UserInfoCache.loadCacheDa ta(UserInfoCache.java:78) at com.lombardisoftware.server.core.cache.UserInfoCache.loadCacheDa ta(UserInfoCache.java:27) ... at com.ibm.bpm.pal.util.RepositoryDelegate.getSnapshot(RepositoryDe legate.java:149) at com.ibm.bpm.pal.util.RepositoryDelegate.getSnapshot(RepositoryDe legate.java:72)
Local fix
Problem summary
No additional information is available.
Problem conclusion
A fix is available for IBM BPM V8.5.5.0 that ensures the user details cache can be read by using any user name that the user registry accepts, without imposing additional restrictions on the capitalization of the user name. This is a continuation of JR51631 which fixes a similar are of the code. On Fix Central (http://www.ibm.com/support/fixcentral), search for JR56655: 1.Select IBM Business Process Manager with your edition from the product selector, the installed version to the fix pack level, and your platform, and then click Continue. 2.Select APAR or SPR, enter JR56655, and click Continue. When you download fix packages, ensure that you also download the readme file for each fix. Review each readme file for additional installation instructions and information about the fix.
Temporary fix
Comments
APAR Information
APAR number
JR56655
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
855
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-09-14
Closed date
2016-12-01
Last modified date
2017-02-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM STANDARD
Fixed component ID
5725C9500
Applicable component levels
R855 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
15 October 2021