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

Last updated on MARCH 08, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms