My Oracle Support Banner

Unable to Create a Group Spaces ORA-00942: table or view does not exist (Doc ID 1493847.1)

Last updated on MAY 03, 2016

Applies to:

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

Symptoms

 While creating spaces or listing the spaces to show  within WebCenter, got a popup window error

 

 

 

The Spaces log shows:

[2012-09-04T16:02:15.536-07:00] [WC_Spaces] [WARNING] [] [oracle.webcenter.activitystreaming.internal.model.jpa.JpaActivityElementDAO] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 6ec4df5b09e25abf:6cd88d8c:139937fc0ee:-8000-000000000000001e,0] [APP: webcenter#11.1.1.4.0] Error while retrieving activities due to [[
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Error Code: 942
Call: SELECT ACTIVITY_ID FROM ( SELECT AE.ACTIVITY_ID, AE.ACTIVITY_TIME FROM WC_AS_ACTIVITY_ELEMENT AE JOIN WC_AS_ACTOR A ON AE.ACTIVITY_ID = A.ACTIVITY_ID JOIN WC_AS_ACTOR_DETAIL AD ON A.ACTIVITY_ACTOR_DETAIL_ID = AD.ACTIVITY_ACTOR_DETAIL_ID WHERE (A.PRIORITY = 0 OR (A.PRIORITY = 1 AND (AE.ACTIVITY_TYPE = 'inviteForConnection' or AE.ACTIVITY_TYPE = 'post'))) and (AE.ACTIVITY_TIME >= ? AND AE.ACTIVITY_TIME <= ? )  and AE.APPLICATION_ID = ?  and  ( AE.SCOPE_ID = ? AND AD.ACTOR_ID = ?  )  and AE.SERVICE_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and ( NOT (AE.ACTIVITY_TYPE IN  (? , ? ))) and (AE.STATE IS NULL OR AE.STATE NOT IN ('DELETED', 'HIDDEN'))  UNION SELECT AE.ACTIVITY_ID, AE.ACTIVITY_TIME FROM WC_AS_ACTIVITY_ELEMENT AE JOIN WC_AS_ACTOR A ON AE.ACTIVITY_ID = A.ACTIVITY_ID JOIN WC_AS_ACTOR_DETAIL AD ON A.ACTIVITY_ACTOR_DETAIL_ID = AD.ACTIVITY_ACTOR_DETAIL_ID JOIN WC_AS_CONNECTIONS_PRIVACY_VIEW CV ON AD.ACTOR_ID = CV.CONNECTEE_ID WHERE (A.PRIORITY = 0 OR (A.PRIORITY = 1 AND (AE.ACTIVITY_TYPE = 'inviteForConnection' or AE.ACTIVITY_TYPE = 'post'))) and (AE.ACTIVITY_TIME >= ? AND AE.ACTIVITY_TIME <= ? )  and AE.APPLICATION_ID = ?  and AE.SCOPE_ID = ? AND CV.USER_ID = ? AND ( ( (CV.PRIVACY_SETTING IN ('PUBLIC', 'USERS', 'CONNECTIONS') AND CV.ADMIN_END_USER_CONFIGURABLE = '+' OR CV.ADMIN_PRIVACY_SETTING IN ('PUBLIC', 'USERS', 'CONNECTIONS') AND CV.ADMIN_END_USER_CONFIGURABLE = '-') AND AE.PERMISSION_NAME IN ('SHARED', 'PUBLIC') ) OR ( (CV.PRIVACY_SETTING IN ('SELF') AND CV.ADMIN_END_USER_CONFIGURABLE = '+' OR CV.ADMIN_PRIVACY_SETTING IN ('SELF') AND CV.ADMIN_END_USER_CONFIGURABLE = '-') AND AE.PERMISSION_NAME IN ('PUBLIC') ) )  and AE.SERVICE_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and ( NOT (AE.ACTIVITY_TYPE IN  (? , ? ))) and (AE.STATE IS NULL OR AE.STATE NOT IN ('DELETED', 'HIDDEN'))  UNION SELECT AE.ACTIVITY_ID, AE.ACTIVITY_TIME FROM WC_AS_ACTIVITY_ELEMENT AE JOIN WC_AS_OBJECT O ON AE.ACTIVITY_ID = O.ACTIVITY_ID JOIN WC_AS_FOLLOW F ON O.ACTIVITY_OBJECT_DETAIL_ID = F.TARGET_ID WHERE (O.PRIORITY = 0 OR O.PRIORITY IS NULL)  and (AE.ACTIVITY_TIME >= ? AND AE.ACTIVITY_TIME <= ? )  and AE.APPLICATION_ID = ?  and AE.SCOPE_ID = 'business_scope' AND F.TARGET_TYPE = 'object' AND F.USER_GUID = ? AND (F.STATUS IS NULL OR F.STATUS NOT IN ('deleted'))  and AE.SERVICE_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and (AE.STATE IS NULL OR AE.STATE NOT IN ('DELETED', 'HIDDEN'))  ) A ORDER BY ACTIVITY_TIME DESC
bind => [2012-08-29 00:00:00.193, 2012-09-04 16:02:15.193, webcenter, s8bba98ff_4cbb_40b8_beee_296c916a23ed, 1B003991E7D711E1BFC2DB3F8A282444, oracle.webcenter.tagging, oracle.webcenter.peopleconnections.profile, oracle.webcenter.peopleconnections.kudos, oracle.webcenter.peopleconnections.wall, oracle.webcenter.collab.forum, oracle.webcenter.community, oracle.webcenter.collab.announcement, oracle.webcenter.list, oracle.webcenter.collab.calendar.community, oracle.webcenter.page, oracle.webcenter.doclib, oracle.webcenter.peopleconnections.connections, oracle.webcenter.blog, expressLike, postComment, 2012-08-29 00:00:00.193, 2012-09-04 16:02:15.193, webcenter, s8bba98ff_4cbb_40b8_beee_296c916a23ed, 1B003991E7D711E1BFC2DB3F8A282444, oracle.webcenter.tagging, oracle.webcenter.peopleconnections.profile, oracle.webcenter.peopleconnections.kudos, oracle.webcenter.peopleconnections.wall, oracle.webcenter.collab.forum, oracle.webcenter.community, oracle.webcenter.collab.announcement, oracle.webcenter.list, oracle.webcenter.collab.calendar.community, oracle.webcenter.page, oracle.webcenter.doclib, oracle.webcenter.peopleconnections.connections, oracle.webcenter.blog, expressLike, postComment, 2012-08-29 00:00:00.193, 2012-09-04 16:02:15.193, webcenter, 1B003991E7D711E1BFC2DB3F8A282444, oracle.webcenter.tagging, oracle.webcenter.peopleconnections.profile, oracle.webcenter.peopleconnections.kudos, oracle.webcenter.peopleconnections.wall, oracle.webcenter.collab.forum, oracle.webcenter.community, oracle.webcenter.collab.announcement, oracle.webcenter.list, oracle.webcenter.collab.calendar.community, oracle.webcenter.page, oracle.webcenter.doclib, oracle.webcenter.peopleconnections.connections, oracle.webcenter.blog]
Query: DataReadQuery(sql="SELECT ACTIVITY_ID FROM ( SELECT AE.ACTIVITY_ID, AE.ACTIVITY_TIME FROM WC_AS_ACTIVITY_ELEMENT AE JOIN WC_AS_ACTOR A ON AE.ACTIVITY_ID = A.ACTIVITY_ID JOIN WC_AS_ACTOR_DETAIL AD ON A.ACTIVITY_ACTOR_DETAIL_ID = AD.ACTIVITY_ACTOR_DETAIL_ID WHERE (A.PRIORITY = 0 OR (A.PRIORITY = 1 AND (AE.ACTIVITY_TYPE = 'inviteForConnection' or AE.ACTIVITY_TYPE = 'post'))) and (AE.ACTIVITY_TIME >= ? AND AE.ACTIVITY_TIME <= ? )  and AE.APPLICATION_ID = ?  and  ( AE.SCOPE_ID = ? AND AD.ACTOR_ID = ?  )  and AE.SERVICE_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and ( NOT (AE.ACTIVITY_TYPE IN  (? , ? ))) and (AE.STATE IS NULL OR AE.STATE NOT IN ('DELETED', 'HIDDEN'))  UNION SELECT AE.ACTIVITY_ID, AE.ACTIVITY_TIME FROM WC_AS_ACTIVITY_ELEMENT AE JOIN WC_AS_ACTOR A ON AE.ACTIVITY_ID = A.ACTIVITY_ID JOIN WC_AS_ACTOR_DETAIL AD ON A.ACTIVITY_ACTOR_DETAIL_ID = AD.ACTIVITY_ACTOR_DETAIL_ID JOIN WC_AS_CONNECTIONS_PRIVACY_VIEW CV ON AD.ACTOR_ID = CV.CONNECTEE_ID WHERE (A.PRIORITY = 0 OR (A.PRIORITY = 1 AND (AE.ACTIVITY_TYPE = 'inviteForConnection' or AE.ACTIVITY_TYPE = 'post'))) and (AE.ACTIVITY_TIME >= ? AND AE.ACTIVITY_TIME <= ? )  and AE.APPLICATION_ID = ?  and AE.SCOPE_ID = ? AND CV.USER_ID = ? AND ( ( (CV.PRIVACY_SETTING IN ('PUBLIC', 'USERS', 'CONNECTIONS') AND CV.ADMIN_END_USER_CONFIGURABLE = '+' OR CV.ADMIN_PRIVACY_SETTING IN ('PUBLIC', 'USERS', 'CONNECTIONS') AND CV.ADMIN_END_USER_CONFIGURABLE = '-') AND AE.PERMISSION_NAME IN ('SHARED', 'PUBLIC') ) OR ( (CV.PRIVACY_SETTING IN ('SELF') AND CV.ADMIN_END_USER_CONFIGURABLE = '+' OR CV.ADMIN_PRIVACY_SETTING IN ('SELF') AND CV.ADMIN_END_USER_CONFIGURABLE = '-') AND AE.PERMISSION_NAME IN ('PUBLIC') ) )  and AE.SERVICE_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and ( NOT (AE.ACTIVITY_TYPE IN  (? , ? ))) and (AE.STATE IS NULL OR AE.STATE NOT IN ('DELETED', 'HIDDEN'))  UNION SELECT AE.ACTIVITY_ID, AE.ACTIVITY_TIME FROM WC_AS_ACTIVITY_ELEMENT AE JOIN WC_AS_OBJECT O ON AE.ACTIVITY_ID = O.ACTIVITY_ID JOIN WC_AS_FOLLOW F ON O.ACTIVITY_OBJECT_DETAIL_ID = F.TARGET_ID WHERE (O.PRIORITY = 0 OR O.PRIORITY IS NULL)  and (AE.ACTIVITY_TIME >= ? AND AE.ACTIVITY_TIME <= ? )  and AE.APPLICATION_ID = ?  and AE.SCOPE_ID = 'business_scope' AND F.TARGET_TYPE = 'object' AND F.USER_GUID = ? AND (F.STATUS IS NULL OR F.STATUS NOT IN ('deleted'))  and AE.SERVICE_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and (AE.STATE IS NULL OR AE.STATE NOT IN ('DELETED', 'HIDDEN'))  ) A ORDER BY ACTIVITY_TIME DESC ") Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
[...]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
[...]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.