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 (?, ?)'

Oracle Community | 3004 | 1 decade ago
  1. 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 (?, ?)'
  2. 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 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 (?, ?)'

      at com.plumtree.openfoundation.util.XPException.GetInstance()
    2. com.plumtree.openfoundation
      XPException.GetInstance
      1. com.plumtree.openfoundation.util.XPException.GetInstance(XPException.java:371)
      1 frame
    3. com.plumtree.server
      PTBaseObject.Store
      1. com.plumtree.server.impl.core.PTBaseObject.Store(PTBaseObject.java:192)
      1 frame
    4. com.plumtree.automationserver
      PTJobShell.run
      1. com.plumtree.automationserver.agents.PTAuthSourceAgent.CreateEveryoneGroup(PTAuthSourceAgent.java:625)
      2. com.plumtree.automationserver.agents.PTAuthSourceAgent.CheckForEveryoneGroup(PTAuthSourceAgent.java:538)
      3. com.plumtree.automationserver.agents.PTAuthSourceAgent.PerformOperation(PTAuthSourceAgent.java:244)
      4. com.plumtree.automationserver.shell.PTJobShell.perform(PTJobShell.java:628)
      5. com.plumtree.automationserver.shell.PTJobShell.runJob(PTJobShell.java:210)
      6. com.plumtree.automationserver.shell.PTJobShell.run(PTJobShell.java:100)
      6 frames