APAR status
Closed as program error.
Error description
The following SQL query performs poorly on Oracle databases: SELECT COUNT(*) FROM jcr.PROT_RES WHERE ( OWNER_UID = :1 AND RES_TYPE = :2 ) The reason is the asterisk inside the COUNT aggregation function.
Local fix
Problem summary
The following SQL query performs poorly on Oracle databases: SELECT COUNT(*) FROM jcr.PROT_RES WHERE ( OWNER_UID = :1 AND RES_TYPE = :2 ) The reason is the asterisk inside the COUNT aggregation function.
Problem conclusion
The asterisk inside COUNT has been replaced with the name of the primary key column 'OID'. Manual Steps: None Failing Module(s): Database Affected Users: All users Version Information: Portal Version(s): 6.0.1.1 Pre-Requisite(s): PK48716 Co-Requisite(s): --- Portal Version(s): 6.0.1.5 Pre-Requisite(s): PK88425 Co-Requisite(s): --- Portal Version(s): 6.1.0.1 Pre-Requisite(s): PK88425 Co-Requisite(s): --- Portal Version(s): 6.1.0.2 Pre-Requisite(s): PK88425 Co-Requisite(s): --- Platform Specific: This fix applies to all platforms. A fix is available from Fix Central: http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?apar=PK89946&productid=WebSphere%20Portal&brandid=5 You may need to type or paste the complete address into your Web browser.
Temporary fix
Comments
APAR Information
APAR number
PK89946
Reported component name
WEBSPHERE PORTA
Reported component ID
5724E7600
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-26
Closed date
2009-07-28
Last modified date
2009-07-28
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
WEBSPHERE PORTA
Fixed component ID
5724E7600
Applicable component levels
R60E PSY
UP
R60J PSY
UP
R61A PSY
UP
R61B PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
21 December 2021