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'

Oracle Community | 648781 | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Webcenter 10.3 and Oracle 11

    Oracle Community | 8 years ago | 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'

    Root Cause Analysis

    1. 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()
    2. com.plumtree.openkernel
      DBCursor.Open
      1. com.plumtree.openkernel.impl.db.DBCursor.DoQuery(DBCursor.java:460)
      2. com.plumtree.openkernel.impl.db.DBCursor.Open(DBCursor.java:71)
      2 frames
    3. com.plumtree.server
      ConfigVerify.main
      1. com.plumtree.server.impl.community.PTCommunity.QueryUserMembershipInfo(PTCommunity.java:1523)
      2. com.plumtree.server.impl.core.PTSessionInfo.GetCurrentCommunityMembership(PTSessionInfo.java:651)
      3. com.plumtree.server.impl.core.InternalSessionCache.PrimeClonedSession(InternalSessionCache.java:177)
      4. com.plumtree.server.impl.core.InternalSessionCache.CacheSessionIfAppropriate(InternalSessionCache.java:152)
      5. com.plumtree.server.impl.core.PTSession.Connect(PTSession.java:406)
      6. com.plumtree.server.impl.core.PTSession.GetGuestReadOnlySession(PTSession.java:2200)
      7. com.plumtree.server.impl.condition.ExpressionEngine.GetExpressions(ExpressionEngine.java:203)
      8. com.plumtree.server.impl.condition.ExpressionEngine.LoadExpressions(ExpressionEngine.java:124)
      9. com.plumtree.server.impl.condition.ExpressionEngine.InitSingleton(ExpressionEngine.java:106)
      10. com.plumtree.server.PortalObjectsFactory.Init(PortalObjectsFactory.java:63)
      11. com.plumtree.server.impl.test.ConfigVerify.sessionConnect(ConfigVerify.java:110)
      12. com.plumtree.server.impl.test.ConfigVerify.main(ConfigVerify.java:50)
      12 frames