Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1387

export gsh to stem caused exception in oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • gsh
    • None

    Description

      This was the GSH script that caused the problem:

      grouperSession = GrouperSession.startRootSession();
      scriptName = "/opt/appserv/tomcat/apps/grouperWs/loader/bin/exportedPspng.gsh";
      new XmlExportGshScript().assignStemName("etc:pspng").assignFileNameToWriteTo(scriptName).exportGsh();

      2016-10-16 23:41:25,097: [main] ERROR ShellHelper.eval(91) - - Sourced file: inline evaluation of: ``new XmlExportGshScript().assignStemName("etc:pspng").assignFileNameToWriteTo(scr . . . '' : Method Invocation exportGsh
      edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (83cd524): new, readonly, READONLY_NEW, notActiveTransaction, session (25d2a399)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:588)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:710)
      at edu.internet2.middleware.grouper.xml.export.XmlExportMembership.exportMembershipsGsh(XmlExportMembership.java:723)
      at edu.internet2.middleware.grouper.xml.export.XmlExportMain.writeAllTablesGsh(XmlExportMain.java:359)
      at edu.internet2.middleware.grouper.xml.export.XmlExportGshScript.exportGsh(XmlExportGshScript.java:132)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at bsh.Reflect.invokeMethod(Unknown Source)
      at bsh.Reflect.invokeObjectMethod(Unknown Source)
      at bsh.BSHPrimarySuffix.doName(Unknown Source)
      at bsh.BSHPrimarySuffix.doSuffix(Unknown Source)
      at bsh.BSHPrimaryExpression.eval(Unknown Source)
      at bsh.BSHPrimaryExpression.eval(Unknown Source)
      at bsh.Interpreter.eval(Unknown Source)
      at bsh.Interpreter.eval(Unknown Source)
      at bsh.Interpreter.eval(Unknown Source)
      at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:440)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)
      at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2116)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1899)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1875)
      at org.hibernate.loader.Loader.scroll(Loader.java:2687)
      at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:570)
      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:423)
      at org.hibernate.engine.query.spi.HQLQueryPlan.performScroll(HQLQueryPlan.java:346)
      at org.hibernate.internal.SessionImpl.scroll(SessionImpl.java:1362)
      at org.hibernate.internal.QueryImpl.scroll(QueryImpl.java:75)
      at org.hibernate.internal.QueryImpl.scroll(QueryImpl.java:65)
      at edu.internet2.middleware.grouper.xml.export.XmlExportMembership$4.callback(XmlExportMembership.java:747)
      at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)
      ... 21 more
      Caused by: java.sql.SQLSyntaxErrorException: ORA-01791: not a SELECTed expression

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:239)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1246)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1500)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1717)
      at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:8872)
      at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:18136)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4390)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4482)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:6272)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
      ... 33 more
      // Error: unable to evaluate command: Sourced file: inline evaluation of: ``new XmlExportGshScript().assignStemName("etc:pspng").assignFileNameToWriteTo(scr . . . '' : Method Invocation exportGsh
      // See error log for full stacktrace
      // caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
      // Problem in HibernateSession: HibernateSession (83cd524): new, readonly, READONLY_NEW, notActiveTransaction, session (25d2a399)
      // caused by: org.hibernate.exception.SQLGrammarException:
      // could not extract ResultSet
      // caused by: java.sql.SQLSyntaxErrorException:
      // ORA-01791: not a SELECTed expression

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: