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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web2

  • via Oracle Community by 3004, 10 months ago
    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
  • via Oracle Community by 648781, 1 year ago
    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
  • Stack trace

    • 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(XPException.java:371) at com.plumtree.server.impl.core.PTBaseObject.Store(PTBaseObject.java:192) at com.plumtree.automationserver.agents.PTAuthSourceAgent.CreateEveryoneGroup(PTAuthSourceAgent.java:625) at com.plumtree.automationserver.agents.PTAuthSourceAgent.CheckForEveryoneGroup(PTAuthSourceAgent.java:538) at com.plumtree.automationserver.agents.PTAuthSourceAgent.PerformOperation(PTAuthSourceAgent.java:244) at com.plumtree.automationserver.shell.PTJobShell.perform(PTJobShell.java:628) at com.plumtree.automationserver.shell.PTJobShell.runJob(PTJobShell.java:210) at com.plumtree.automationserver.shell.PTJobShell.run(PTJobShell.java:100)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.