Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

  • claudiobosticco
    replied
    I can confirm it's fixed, thank you very much!

    Leave a comment:


  • Isomorphic
    replied
    This is fixed and will be available for download in nightly builds since Nov 11 (tomorrow).

    Leave a comment:


  • error when using both groupBy with summaryFunctions and groupClause

    Version v12.1p_2021-11-02/Enterprise Deployment (2021-11-02)

    Hello, I've got a sql dataSource where in an operation binding I use both groupBy with summaryFunctions and customSQL with groupClause:

    Code:
    <DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
                ID="JOFC_V_POSTI_E_RICHIESTE_EV_BO"
                tableName="JOFC_V_POSTI_E_RICHIESTE_EV"
                schema="DBJOFC"
                dbName="DBJOFC"
                serverType="sql"
                requiresAuthentication="true"
    >
        <fmt:bundle basename="i18nMessages" encoding="utf-8"/>
        <fields>
            <field name="ID_CLUB_FK" type="integer" foreignKey="JOFC_CLUB.ID_REC"/>
            <field name="ID_EVENTO_FK" type="integer" foreignKey="JPC_LISTINI.ID_REC"/>
            <field name="ID_SETTORE_VENDITA_FK" type="integer" foreignKey="JTK_SETTORI_VENDITA.ID_REC"/>
            <field name="ID_PARENT_FK" type="integer" includeFrom="JTK_SETTORI_VENDITA.ID_PARENT_FK"/>
            <field name="NVL_ID_PARENT" type="integer" customSelectExpression="NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC)" />
            <field name="NOME_FAN_CLUB" type="text" includeFrom="JOFC_CLUB.NOME_FAN_CLUB"/>
            <field name="SETTORE_VENDITA" type="text" includeFrom="JTK_SETTORI_VENDITA.DESCRIZIONE"/>
            <field name="SETTORE_VENDITA_PARENT" type="text" includeFrom="JTK_SETTORI_VENDITA.SETTORE_VENDITA_PARENT"/>
            <field name="SETTORE_VENDITA_COMPLETO" type="text" includeFrom="JTK_SETTORI_VENDITA.SETTORE_VENDITA_COMPLETO"/>
            <field name="POSTI_ASSEGNATI" type="integer"/>
            <field name="POSTI_RICHIESTI" type="integer"/>
            <field name="POSTI_UTILIZZATI" type="integer"/>
            <field name="POSTI_IMA_UTILIZZATI" type="integer"/>
            <field name="POSTI_DA_ATTRIBUIRE" type="integer"/>
            <field name="POSTI_CONFERMATI" type="integer"/>
            <field name="TOT_POSTI_IMA_UTILIZZATI" type="integer"/>
        </fields>
        <operationBindings>
            <operationBinding operationType="fetch" requires="true"/>
            <operationBinding operationType="fetch"
                              requires="true"
                              operationId="fetchRaggruppatoMacroarea"
                              customFields="NVL_ID_PARENT"
                              groupBy="ID_CLUB_FK,ID_EVENTO_FK,NVL_ID_PARENT,NOME_FAN_CLUB">
                <summaryFunctions>
                    <POSTI_ASSEGNATI>sum</POSTI_ASSEGNATI>
                    <POSTI_RICHIESTI>sum</POSTI_RICHIESTI>
                    <POSTI_UTILIZZATI>sum</POSTI_UTILIZZATI>
                    <POSTI_IMA_UTILIZZATI>sum</POSTI_IMA_UTILIZZATI>
                    <POSTI_DA_ATTRIBUIRE>sum</POSTI_DA_ATTRIBUIRE>
                    <POSTI_CONFERMATI>sum</POSTI_CONFERMATI>
                    <TOT_POSTI_IMA_UTILIZZATI>sum</TOT_POSTI_IMA_UTILIZZATI>
                </summaryFunctions>
                <selectClause>
                    $defaultSelectClause,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
                </selectClause>
                <tableClause>
                    $defaultTableClause
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
                </tableClause>
                <groupClause>
                    $defaultGroupClause,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
                    SETT_VEN_PARENT.DESCRIZIONE)
                </groupClause>
            </operationBinding>
            <operationBinding operationType="add" requires="false"/>
            <operationBinding operationType="update" requires="true"/>
            <operationBinding operationType="remove" requires="false"/>
        </operationBindings>
    </DataSource>
    it seems to work in the generated select count(*), but when it generates the actual select it seems that the groupClause is ignored, so I get an error.
    I wonder if it's actually supported or is a bug?
    Here's the log:

    Code:
    2021-11-03T12:29:49,024 DEBUG PoolableDataSourceFactory Activated DataSource 2876 of type 'JOFC_V_POSTI_E_RICHIESTE_EV_BO'
    2021-11-03T12:29:49,031 DEBUG DSRequest Caching instance 2876 of DS 'JOFC_V_POSTI_E_RICHIESTE_EV_BO' from DSRequest.getDataSource()
    2021-11-03T12:29:49,031 DEBUG DSRequest Caching instance 2876 of DS JOFC_V_POSTI_E_RICHIESTE_EV_BO
    2021-11-03T12:29:49,032 DEBUG RPCManager Request #1 (DSRequest) payload: {
        criteria:{
            operator:"and",
            _constructor:"AdvancedCriteria",
            criteria:[
                {
                    fieldName:"ID_EVENTO_FK",
                    operator:"equals",
                    value:7370908
                },
                {
                    fieldName:"ID_EVENTO_FK",
                    operator:"notNull"
                }
            ]
        },
        operationConfig:{
            dataSource:"JOFC_V_POSTI_E_RICHIESTE_EV_BO",
            repo:null,
            operationType:"fetch",
            textMatchStyle:"exact"
        },
        startRow:0,
        endRow:74,
        componentId:"gestioneBigliettiBOListGridRichieste",
        appID:"builtinApplication",
        operation:"fetchRaggruppatoMacroarea",
        oldValues:{
            operator:"and",
            _constructor:"AdvancedCriteria",
            criteria:[
                {
                    fieldName:"ID_EVENTO_FK",
                    operator:"equals",
                    value:7370908
                },
                {
                    fieldName:"ID_EVENTO_FK",
                    operator:"notNull"
                }
            ]
        }
    }
    2021-11-03T12:29:49,032 INFO SecureIDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36]
    2021-11-03T12:29:49,034 INFO DSRequest Executing gestioneBigliettiBOListGridRichieste->JOFC_V_POSTI_E_RICHIESTE_EV_BO.fetch[fetchRaggruppatoMacroarea] rows: 0->74 with
    criteria: {
        operator:"and",
        _constructor:"AdvancedCriteria",
        criteria:[
            {fieldName:"ID_EVENTO_FK", operator:"equals", value:7370908},
            {fieldName:"ID_EVENTO_FK", operator:"notNull"}
        ]
    }
    2021-11-03T12:29:49,034 DEBUG PoolableDataSourceFactory Activated DataSource 1544 of type 'JOFC_CLUB'
    2021-11-03T12:29:49,034 DEBUG Relation Caching instance of toDS 'JOFC_CLUB' in the DSRequest map
    2021-11-03T12:29:49,034 DEBUG BasicDataSource Looking up superDS of DataSource JOFC_CLUB: 'JOFC_CLUB_BASE'
    2021-11-03T12:29:49,034 DEBUG PoolableDataSourceFactory Activated DataSource 2878 of type 'JOFC_CLUB_BASE'
    2021-11-03T12:29:49,034 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
    2021-11-03T12:29:49,034 DEBUG DeclarativeSecurity DataSource JOFC_V_POSTI_E_RICHIESTE_EV_BO is not in the pre-checked list, processing...
    2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity Processing security checks for DataSource JOFC_CLUB, field ID_REC
    2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity DataSource JOFC_CLUB is not in the pre-checked list, processing...
    2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity Processing security checks for DataSource JOFC_CLUB, field NOME_FAN_CLUB
    2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity DataSource JOFC_CLUB is not in the pre-checked list, processing...
    2021-11-03T12:29:49,035 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
    2021-11-03T12:29:49,036 DEBUG AppBase No public zero-argument method named '_fetchRaggruppatoMacroarea' found, performing generic datasource operation
    2021-11-03T12:29:49,041 INFO SQLDataSource derived query: SELECT
                    $defaultSelectClause,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
                 FROM
                    $defaultTableClause
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
                 $defaultAnsiJoinClause WHERE $defaultWhereClause GROUP BY JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB
    2021-11-03T12:29:49,042 DEBUG SQLDataSource Executing row count query: SELECT COUNT(*) FROM (SELECT
                    $defaultSelectClause,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
                 FROM
                    $defaultTableClause
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
                $defaultAnsiJoinClause WHERE $defaultWhereClause GROUP BY
                    $defaultGroupClause,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
                    SETT_VEN_PARENT.DESCRIZIONE)
                ) work
    2021-11-03T12:29:49,043 DEBUG SQLDataSource Eval'd row count query: SELECT COUNT(*) FROM (SELECT
                    JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC) AS NVL_ID_PARENT, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_ASSEGNATI) AS POSTI_ASSEGNATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_RICHIESTI) AS POSTI_RICHIESTI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_UTILIZZATI) AS POSTI_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_IMA_UTILIZZATI) AS POSTI_IMA_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_DA_ATTRIBUIRE) AS POSTI_DA_ATTRIBUIRE, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_CONFERMATI) AS POSTI_CONFERMATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.TOT_POSTI_IMA_UTILIZZATI) AS TOT_POSTI_IMA_UTILIZZATI, JOFC_CLUB.NOME_FAN_CLUB,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
                 FROM
                    DBJOFC.JOFC_V_POSTI_E_RICHIESTE_EV
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
                 JOIN DBJOFC.JOFC_CLUB ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK = JOFC_CLUB.ID_REC WHERE ((JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK = 7370908 AND JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL) AND (JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL)) GROUP BY
                    JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
                    SETT_VEN_PARENT.DESCRIZIONE)
                ) work
    2021-11-03T12:29:49,065 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1349159953'
    2021-11-03T12:29:49,065 DEBUG SQLConnectionManager Borrowed connection '1349159953'
    2021-11-03T12:29:49,065 DEBUG SQLTransaction Started new DBJOFC transaction "1349159953"
    2021-11-03T12:29:49,065 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2021-11-03T12:29:49,065 INFO SQLDriver Executing SQL query on 'DBJOFC' using connection '1349159953': SELECT COUNT(*) FROM (SELECT
                    JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC) AS NVL_ID_PARENT, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_ASSEGNATI) AS POSTI_ASSEGNATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_RICHIESTI) AS POSTI_RICHIESTI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_UTILIZZATI) AS POSTI_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_IMA_UTILIZZATI) AS POSTI_IMA_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_DA_ATTRIBUIRE) AS POSTI_DA_ATTRIBUIRE, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_CONFERMATI) AS POSTI_CONFERMATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.TOT_POSTI_IMA_UTILIZZATI) AS TOT_POSTI_IMA_UTILIZZATI, JOFC_CLUB.NOME_FAN_CLUB,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
                 FROM
                    DBJOFC.JOFC_V_POSTI_E_RICHIESTE_EV
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
                 JOIN DBJOFC.JOFC_CLUB ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK = JOFC_CLUB.ID_REC WHERE ((JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK = 7370908 AND JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL) AND (JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL)) GROUP BY
                    JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
                    SETT_VEN_PARENT.DESCRIZIONE)
                ) work
    2021-11-03T12:29:49,126 DEBUG SQLDataSource JDBC driver windowed select rows 0->74, result size 74. Query: SELECT
                    JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC) AS NVL_ID_PARENT, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_ASSEGNATI) AS POSTI_ASSEGNATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_RICHIESTI) AS POSTI_RICHIESTI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_UTILIZZATI) AS POSTI_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_IMA_UTILIZZATI) AS POSTI_IMA_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_DA_ATTRIBUIRE) AS POSTI_DA_ATTRIBUIRE, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_CONFERMATI) AS POSTI_CONFERMATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.TOT_POSTI_IMA_UTILIZZATI) AS TOT_POSTI_IMA_UTILIZZATI, JOFC_CLUB.NOME_FAN_CLUB,
                    DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
                 FROM
                    DBJOFC.JOFC_V_POSTI_E_RICHIESTE_EV
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
                    LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
                  JOIN DBJOFC.JOFC_CLUB ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK = JOFC_CLUB.ID_REC WHERE ((JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK = 7370908 AND JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL) AND (JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL)) GROUP BY JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB
    2021-11-03T12:29:49,126 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2021-11-03T12:29:49,168 DEBUG DSRequest freeOnExecute is false for request of type fetch on DataSource JOFC_V_POSTI_E_RICHIESTE_EV_BO - not freeing resources!
    03-Nov-2021 12:29:49.166 SEVERE [https-jsse-nio-8443-exec-2] oracle.jdbc.driver.T4CTTIoer.processError 46F3B210 Throwing SQLException: ORA-00979: not a GROUP BY expression
    979
    2021-11-03T12:29:49,168 WARN RequestContext dsRequest.execute() failed:
    java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
    
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:199) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:1216) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1500) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1717) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:8872) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:9090) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:2020) ~[ojdbc6_g.jar:11.2.0.3.0]
        at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:1709) ~[ojdbc6_g.jar:11.2.0.3.0]
        at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
        at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
        at com.sun.proxy.$Proxy81.executeQuery(Unknown Source) ~[?:?]
        at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2770) ~[isomorphic_sql.jar:?]
        at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1817) ~[isomorphic_sql.jar:?]
        at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:441) ~[isomorphic_sql.jar:?]
        at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:386) ~[isomorphic_sql.jar:?]
        at com.isomorphic.datasource.DataSource.execute(DataSource.java:2499) ~[isomorphic_core_rpc.jar:?]
        at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic_core_rpc.jar:?]
        at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic_core_rpc.jar:?]
        at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic_core_rpc.jar:?]
        at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3071) ~[isomorphic_core_rpc.jar:?]
        at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic_core_rpc.jar:?]
        at com.juve.jofc.SecureIDACall.handleDSRequest(SecureIDACall.java:95) [classes/:?]
        at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic_core_rpc.jar:?]
        at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic_core_rpc.jar:?]
        at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic_core_rpc.jar:?]
        at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic_core_rpc.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [servlet-api.jar:?]
        at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:178) [isomorphic_core_rpc.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:200) [javamelody-1.58.0.jar:?]
        at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:178) [javamelody-1.58.0.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic_core_rpc.jar:?]
        at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic_core_rpc.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at com.juve.jofc.auth.FrameOriginFilter.doFilter(FrameOriginFilter.java:35) [classes/:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at com.juve.utils.Log4jSessionFilter.doFilter(Log4jSessionFilter.java:85) [classes/:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:97) [cas-client-core-3.5.1.jar:3.5.1]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:124) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.39]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.39]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [catalina.jar:8.5.39]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [catalina.jar:8.5.39]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.39]
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) [catalina.jar:8.5.39]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.39]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.39]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) [tomcat-coyote.jar:8.5.39]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.39]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) [tomcat-coyote.jar:8.5.39]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat-coyote.jar:8.5.39]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.39]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_281]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_281]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.39]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Working...
X