com.plumtree.openkernel.exceptions.OKSQLException: Error in function PTSession.Connect (iUserID == 2, SecurityProviderInfo == null): Error in function PTSessionInfo.GetCurrentCommunityMembership (): Exception: [plumtree][Oracle JDBC Driver][Oracle]ORA-00979: not a GROUP BY expression SQL: '/* USER_COMMUNITY_MEMBERSHIPS:ANSI */ SELECT MAX(CS.ACCESSLEVEL) AS ACCESSLEVEL, C.NAME, C.ISLOCALIZED, C.OBJECTID, MC2.MEMBERSHIPTYPE FROM PTCOMMUNITIES C, PTCOMMSECURITY CS, PTVGROUPMEMBERSHIP GM, (SELECT MAX(MC.MEMBERSHIPTYPE) AS MEMBERSHIPTYPE, MC.COMMUNITYID FROM PTMYCOMMUNITIES MC, PTVGROUPMEMBERSHIP GM WHERE GM.GROUPID=MC.GROUPID AND GM.USERID=? GROUP BY MC.COMMUNITYID) MC2 WHERE GM.GROUPID=CS.GROUPID AND GM.USERID=? AND C.OBJECTID=CS.OBJECTID AND C.OBJECTID=MC2.COMMUNITYID GROUP BY C.NAME, C.ISLOCALIZED, C.OBJECTID, MC2.MEMBERSHIPTYPE ORDER BY LOWER(C.NAME) ASC'

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Webcenter 10.3 and Oracle 11
    via by 648781,
    • com.plumtree.openkernel.exceptions.OKSQLException: Error in function PTSession.Connect (iUserID == 2, SecurityProviderInfo == null): Error in function PTSessionInfo.GetCurrentCommunityMembership (): Exception: [plumtree][Oracle JDBC Driver][Oracle]ORA-00979: not a GROUP BY expression SQL: '/* USER_COMMUNITY_MEMBERSHIPS:ANSI */ SELECT MAX(CS.ACCESSLEVEL) AS ACCESSLEVEL, C.NAME, C.ISLOCALIZED, C.OBJECTID, MC2.MEMBERSHIPTYPE FROM PTCOMMUNITIES C, PTCOMMSECURITY CS, PTVGROUPMEMBERSHIP GM, (SELECT MAX(MC.MEMBERSHIPTYPE) AS MEMBERSHIPTYPE, MC.COMMUNITYID FROM PTMYCOMMUNITIES MC, PTVGROUPMEMBERSHIP GM WHERE GM.GROUPID=MC.GROUPID AND GM.USERID=? GROUP BY MC.COMMUNITYID) MC2 WHERE GM.GROUPID=CS.GROUPID AND GM.USERID=? AND C.OBJECTID=CS.OBJECTID AND C.OBJECTID=MC2.COMMUNITYID GROUP BY C.NAME, C.ISLOCALIZED, C.OBJECTID, MC2.MEMBERSHIPTYPE ORDER BY LOWER(C.NAME) ASC' at com.plumtree.openkernel.impl.db.DBCursor.DoQuery(DBCursor.java:460) at com.plumtree.openkernel.impl.db.DBCursor.Open(DBCursor.java:71) at com.plumtree.server.impl.community.PTCommunity.QueryUserMembershipInfo(PTCommunity.java:1523) at com.plumtree.server.impl.core.PTSessionInfo.GetCurrentCommunityMembership(PTSessionInfo.java:651) at com.plumtree.server.impl.core.InternalSessionCache.PrimeClonedSession(InternalSessionCache.java:177) at com.plumtree.server.impl.core.InternalSessionCache.CacheSessionIfAppropriate(InternalSessionCache.java:152) at com.plumtree.server.impl.core.PTSession.Connect(PTSession.java:406) at com.plumtree.server.impl.core.PTSession.GetGuestReadOnlySession(PTSession.java:2200) at com.plumtree.server.impl.condition.ExpressionEngine.GetExpressions(ExpressionEngine.java:203) at com.plumtree.server.impl.condition.ExpressionEngine.LoadExpressions(ExpressionEngine.java:124) at com.plumtree.server.impl.condition.ExpressionEngine.InitSingleton(ExpressionEngine.java:106) at com.plumtree.server.PortalObjectsFactory.Init(PortalObjectsFactory.java:63) at com.plumtree.server.impl.test.ConfigVerify.sessionConnect(ConfigVerify.java:110) at com.plumtree.server.impl.test.ConfigVerify.main(ConfigVerify.java:50)
    No Bugmate found.