My Oracle Support Banner

User Gets Stuck In Webcenter Spaces After Going To Connections; (Doc ID 1346650.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle WebCenter Portal - Version 11.1.1.4.0 to 11.1.1.6.4 [Release 11g]
Information in this document applies to any platform.

Symptoms

When attempting to get the connections from the user Profile, the following error occurs:

Error

WCS#2011.03.28.16.28.31 : Unexpected error retrieving connections for user 'testuser1'
WCS#2011.03.28.16.28.33 : Unexpected error retrieving connections for user 'testuser1'


This issue happens only for some users.

The WC_Spaces-diagnostic.log shows the following errors:

[2011-03-31T13:41:09.813-04:00] [WC_Spaces] [ERROR] [] [oracle.webcenter.webcenterapp] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: testuser1] [ecid: 004bwf98p26AhKcULiQ5SQ0005hj000VDG,0:1] [APP: webcenter#11.1.1.4.0] [URI: /webcenter/faces/oracle/webcenter/page/scopedMD/s8bba98ff_4cbb_40b8_beee_296c916a23ed/businessRolePages/MyProfileMainView.jspx] Current Reference = WCS#2011.03.31.13.41.09

[2011-03-31T13:41:09.814-04:00] [WC_Spaces] [ERROR] [] [oracle.webcenter.webcenterapp] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: testuser1] [ecid: 004bwf98p26AhKcULiQ5SQ0005hj000VDG,0:1] [APP: webcenter#11.1.1.4.0] [URI: /webcenter/faces/oracle/webcenter/page/scopedMD/s8bba98ff_4cbb_40b8_beee_296c916a23ed/businessRolePages/MyProfileMainView.jspx] getDisplayMessage Called=oracle.jbo.JboException[[
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.webcenter.peopleconnections.connections.ConnectionsException, msg=Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []

Error Code: 600
Call: SELECT CONNECTEE_ID, LIST_MEMBERSHIP, AC.ACTOR_NAME, COALESCE(XAC.RESOURCE_VALUE, XAL.RESOURCE_VALUE, XAS.RESOURCE_VALUE, AC.DISPLAY_NAME) AS AC_DISPLAY_NAME, AC.EMAIL, AC.JOB_TITLE, AC.DEPARTMENT FROM (SELECT CO.USER_ID AS CONNECTEE_ID, GROUP_CONCAT(REPLACE(REPLACE(LM.LIST_LOCALIZED_NAME, '&', '&'), ',', ',')) AS LIST_MEMBERSHIP FROM ((SELECT CONNECTEE_ID AS USER_ID FROM WC_PEOPLE_CONN_CONNECTION WHERE OWNER_ID = ?) UNION ALL (SELECT OWNER_ID AS USER_ID FROM WC_PEOPLE_CONN_CONNECTION WHERE CONNECTEE_ID = ?)) CO LEFT JOIN (SELECT M.MEMBER_ID, COALESCE(XLC.RESOURCE_VALUE, XLL.RESOURCE_VALUE, XLS.RESOURCE_VALUE, L.LIST_NAME) AS LIST_LOCALIZED_NAME FROM WC_PEOPLE_CONN_LIST_MEMBER M INNER JOIN WC_PEOPLE_CONN_LIST L ON M.LIST_ID = L.LIST_ID LEFT JOIN WC_COMMON_TRANSLATION XLS ON L.LIST_NAME = XLS.RESOURCE_KEY AND XLS.LOCALE = '*' AND L.LIST_NAME LIKE 'CONNECTIONS.LIST.%.NAME' AND XLS.SCOPE_ID = ? AND XLS.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XLL ON L.LIST_NAME = XLL.RESOURCE_KEY AND XLL.LOCALE = ? AND L.LIST_NAME LIKE 'CONNECTIONS.LIST.%.NAME' AND XLL.SCOPE_ID = ? AND XLL.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XLC ON L.LIST_NAME = XLC.RESOURCE_KEY AND XLC.LOCALE = ? AND L.LIST_NAME LIKE 'CONNECTIONS.LIST.%.NAME' AND XLC.SCOPE_ID = ? AND XLC.APPLICATION_ID = ? WHERE L.OWNER_ID = ?) LM ON CO.USER_ID = LM.MEMBER_ID GROUP BY CO.USER_ID) CO2 LEFT JOIN WC_AS_ACTOR_DETAIL AC ON CO2.CONNECTEE_ID = AC.ACTOR_ID LEFT JOIN WC_COMMON_TRANSLATION XAS ON AC.DISPLAY_NAME = XAS.RESOURCE_KEY AND XAS.LOCALE = '*' AND AC.DISPLAY_NAME LIKE 'PROFILE.%.DISPLAY_NAME' AND XAS.SCOPE_ID = ? AND XAS.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XAL ON AC.DISPLAY_NAME = XAL.RESOURCE_KEY AND XAL.LOCALE = ? AND AC.DISPLAY_NAME LIKE 'PROFILE.%.DISPLAY_NAME' AND XAL.SCOPE_ID = ? AND XAL.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XAC ON AC.DISPLAY_NAME = XAC.RESOURCE_KEY AND XAC.LOCALE = ? AND AC.DISPLAY_NAME LIKE 'PROFILE.%.DISPLAY_NAME' AND XAC.SCOPE_ID = ? AND XAC.APPLICATION_ID = ? WHERE ? IS NULL OR UPPER(COALESCE(XAC.RESOURCE_VALUE, XAL.RESOURCE_VALUE, XAS.RESOURCE_VALUE, AC.DISPLAY_NAME)) LIKE ? OR UPPER(AC.EMAIL) LIKE ? OR UPPER(AC.ACTOR_NAME) LIKE ? OR UPPER(AC.JOB_TITLE) LIKE ? OR UPPER(AC.DEPARTMENT) LIKE ? ORDER BY AC.DISPLAY_NAME
bind => [813BEAF484CA6907E0408A92C7DC14E6, 813BEAF484CA6907E0408A92C7DC14E6, s8bba98ff_4cbb_40b8_beee_296c916a23ed, webcenter, en, s8bba98ff_4cbb_40b8_beee_296c916a23ed, webcenter, en_US, s8bba98ff_4cbb_40b8_beee_296c916a23ed, webcenter, 813BEAF484CA6907E0408A92C7DC14E6, s8bba98ff_4cbb_40b8_beee_296c916a23ed, webcenter, en, s8bba98ff_4cbb_40b8_beee_296c916a23ed, webcenter, en_US, s8bba98ff_4cbb_40b8_beee_296c916a23ed, webcenter, null, null, null, null, null, null]

Query: ResultSetMappingQuery(name="WcPeopleConnConnection.FIND_ALL_BY_USERID.withListMembership" sql="SELECT CONNECTEE_ID, LIST_MEMBERSHIP, AC.ACTOR_NAME, COALESCE(XAC.RESOURCE_VALUE, XAL.RESOURCE_VALUE, XAS.RESOURCE_VALUE, AC.DISPLAY_NAME) AS AC_DISPLAY_NAME, AC.EMAIL, AC.JOB_TITLE, AC.DEPARTMENT FROM (SELECT CO.USER_ID AS CONNECTEE_ID, GROUP_CONCAT(REPLACE(REPLACE(LM.LIST_LOCALIZED_NAME, '&', '&'), ',', ',')) AS LIST_MEMBERSHIP FROM ((SELECT CONNECTEE_ID AS USER_ID FROM WC_PEOPLE_CONN_CONNECTION WHERE OWNER_ID = ?) UNION ALL (SELECT OWNER_ID AS USER_ID FROM WC_PEOPLE_CONN_CONNECTION WHERE CONNECTEE_ID = ?)) CO LEFT JOIN (SELECT M.MEMBER_ID, COALESCE(XLC.RESOURCE_VALUE, XLL.RESOURCE_VALUE, XLS.RESOURCE_VALUE, L.LIST_NAME) AS LIST_LOCALIZED_NAME FROM WC_PEOPLE_CONN_LIST_MEMBER M INNER JOIN WC_PEOPLE_CONN_LIST L ON M.LIST_ID = L.LIST_ID LEFT JOIN WC_COMMON_TRANSLATION XLS ON L.LIST_NAME = XLS.RESOURCE_KEY AND XLS.LOCALE = '*' AND L.LIST_NAME LIKE 'CONNECTIONS.LIST.%.NAME' AND XLS.SCOPE_ID = ? AND XLS.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XLL ON L.LIST_NAME = XLL.RESOURCE_KEY AND XLL.LOCALE = ? AND L.LIST_NAME LIKE 'CONNECTIONS.LIST.%.NAME' AND XLL.SCOPE_ID = ? AND XLL.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XLC ON L.LIST_NAME = XLC.RESOURCE_KEY AND XLC.LOCALE = ? AND L.LIST_NAME LIKE 'CONNECTIONS.LIST.%.NAME' AND XLC.SCOPE_ID = ? AND XLC.APPLICATION_ID = ? WHERE L.OWNER_ID = ?) LM ON CO.USER_ID = LM.MEMBER_ID GROUP BY CO.USER_ID) CO2 LEFT JOIN WC_AS_ACTOR_DETAIL AC ON CO2.CONNECTEE_ID = AC.ACTOR_ID LEFT JOIN WC_COMMON_TRANSLATION XAS ON AC.DISPLAY_NAME = XAS.RESOURCE_KEY AND XAS.LOCALE = '*' AND AC.DISPLAY_NAME LIKE 'PROFILE.%.DISPLAY_NAME' AND XAS.SCOPE_ID = ? AND XAS.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XAL ON AC.DISPLAY_NAME = XAL.RESOURCE_KEY AND XAL.LOCALE = ? AND AC.DISPLAY_NAME LIKE 'PROFILE.%.DISPLAY_NAME' AND XAL.SCOPE_ID = ? AND XAL.APPLICATION_ID = ? LEFT JOIN WC_COMMON_TRANSLATION XAC ON AC.DISPLAY_NAME = XAC.RESOURCE_KEY AND XAC.LOCALE = ? AND AC.DISPLAY_NAME LIKE 'PROFILE.%.DISPLAY_NAME' AND XAC.SCOPE_ID = ? AND XAC.APPLICATION_ID = ? WHERE ? IS NULL OR UPPER(COALESCE(XAC.RESOURCE_VALUE, XAL.RESOURCE_VALUE, XAS.RESOURCE_VALUE, AC.DISPLAY_NAME)) LIKE ? OR UPPER(AC.EMAIL) LIKE ? OR UPPER(AC.ACTOR_NAME) LIKE ? OR UPPER(AC.JOB_TITLE) LIKE ? OR UPPER(AC.DEPARTMENT) LIKE ? ORDER BY AC.DISPLAY_NAME")
at oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:680)
at oracle.adf.model.binding.DCDataControl.invokeMethod(DCDataControl.java:2136)
...

Caused by: oracle.webcenter.peopleconnections.connections.ConnectionsException: Unexpected error retrieving connections for user 'testuser1'
at oracle.webcenter.peopleconnections.connections.internal.model.ConnectionsManagerImpl.getConnections(ConnectionsManagerImpl.java:380)
at oracle.webcenter.peopleconnections.connections.model.dc.ConnectionsManagementDC.getConnections(ConnectionsManagementDC.java:162)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:638)
... 346 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []


STEPS

The issue can be reproduced at will with the following steps:

  1. Connect to WebCenter Spaces.
  2. Go the My Profile.
  3. Click on Connections.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.