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
  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'
  2. 0

    LDAP AWS Job failing

    Oracle Community | 1 decade ago | 3004
    com.plumtree.openkernel.exceptions.OKSQLException: Error in function PTBaseObject.Store (): Error in function PTServerContext.Store (baseObject == com.plumtree.server.impl.users.PTUserGroup@1dddba): Exception: [plumtree][Oracle JDBC Driver][Oracle]ORA-04098: trigger 'PLUMTREE.UPDATE_PTGG_RESET' is invalid and failed re-validation, Txn id: 6, SQL: '/* INSERT_GROUP_SELF_LINK:ANSI */ INSERT INTO PTGROUPSINGROUPS(CHILDID, PARENTID) VALUES (?, ?)'

    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