Direct links to fixes
8.0.0.3-WS-WSRR-ZOS-IFIV65487_IV79085_IV87422_IV87429_IV89477
8.0.0.3-WS-WSRR-MultiOS-IFIV65487_IV79085_IV87422_IV87429_IV89477
WebSphere Service Registry and Repository V8.5.0 Fix Pack 1
WebSphere Service Registry and Repository V8.0.0 Fix Pack 3
WebSphere Service Registry and Repository V8.5 Refresh Pack 1
WebSphere Service Registry and Repository V8.5 Refresh Pack 2
WebSphere Service Registry and Repository V8.5.6 Fix Pack 1
APAR status
Closed as program error.
Error description
WebUI responds with ("The user is not authorized to perform the requested operation" and we observe a long SQL error. 000000f0 AtheneAccessI E com.ibm.sr.athene.access.impl.AtheneAccessImpl executeTripleStoreQuery GSR5000I: Captured exception [1116]: com.ibm. athene.exception.TripleStoreException: ATN0203E: An Exception occurred whilst executing SQL Query representation of Triple Query [...] [05-03-14 15:20:17:701 CET] 00000117 AtheneAccessI E com.ibm.sr.athene. access.impl.AtheneAccessImpl executeTripleStoreQuery GSR5001I: Captured exception [1116] ends
Local fix
NA
Problem summary
**************************************************************** USERS AFFECTED: All users of the WebSphere Service Registry and Repository V8.0 and V8.5 Web UI. **************************************************************** PROBLEM DESCRIPTION: The following error is seen in the WSRR Web UI when attempting View->Concepts and the registry contains a large number of WSDLs: "The user is not authorized to perform the requested operation" The SystemOut.log shows: 000000f0 AtheneAccessI E com.ibm.sr.athene.access.impl.AtheneAccessImpl executeTripleStoreQuery GSR5000I: Captured exception [1116]: com.ibm.athene.exception.TripleStoreException: ATN0203E: An Exception occurred whilst executing SQL Query representation of Triple Query [...] [05-03-14 15:20:17:701 CET] 00000117 AtheneAccessI E com.ibm.sr.athene.access.impl.AtheneAccessImpl executeTripleStoreQuery GSR5001I: The FFDC shows an SQL statement containing a long list of hashes and the following exception: Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: DB2 SQL Error: SQLCODE=-101, SQLSTATE=54001, SQLERRMC=null, DRIVER=3.61.65
Problem conclusion
The issue was due to the large single SQL query used by the Web UI being rejected by DB2 because of its size. This has been fixed by splitting the query into smaller chunks. This fix is targeted at WSRR V8.0.0.3 and V8.5.0.1.
Temporary fix
Comments
APAR Information
APAR number
IV57399
Reported component name
SERVICE REGISTR
Reported component ID
5724N7200
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-03-25
Closed date
2014-07-30
Last modified date
2014-07-30
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
SERVICE REGISTR
Fixed component ID
5724N7200
Applicable component levels
R800 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
30 July 2014