Announcement

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

    SQLDataSource bug when updating a column with length=4000

    SmartClient Version: v12.1p_2022-02-13/Enterprise Deployment (built 2022-02-13)

    Oracle (ver. Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0)

    Hello, I've got a SQLDataSource with a field defined as:

    Code:
    <field name="DESCRIZIONE_PAG_SECONDA" length="4000" type="text" customUpdateExpression="#if ($values.INCLUDI_SECONDA_PARTE) #if ($values.DESCRIZIONE_PAG_SECONDA) $values.DESCRIZIONE_PAG_SECONDA #else null #end #else null #end"/>
    This column is a varchar2(4000).

    When updating this field:

    Code:
    RICHIESTE_CLIENTE.updateData({
            PK:1,
            DESCRIZIONE_PAG_SECONDA:null
        })
    I get this error:

    Code:
    2022-02-15T13:58:10,102 [claudio.bosticco@juventus.com 1644927759000] INFO SQLDriver Executing SQL query on 'dbEleven': UPDATE DBELEVEN.RICHIESTE_CLIENTE SET DESCRIZIONE_PAG_SECONDA= null WHERE (RICHIESTE_CLIENTE.ID_REC=2368980)
    2022-02-15T13:58:10,104 [claudio.bosticco@juventus.com 1644927759000] DEBUG DSRequest freeOnExecute is false for request of type update on DataSource RICHIESTE_CLIENTE - not freeing resources!
    2022-02-15T13:58:10,104 [claudio.bosticco@juventus.com 1644927759000] DEBUG DataSourceDMI Invocation threw exception
    java.sql.SQLException: invalid column index
        at oracle.jdbc.driver.OraclePreparedStatement.setFormOfUseInternal(OraclePreparedStatement.java:10470) ~[ojdbc8.jar:12.2.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatement.setFormOfUseInternal(OraclePreparedStatement.java:10451) ~[ojdbc8.jar:12.2.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5240) ~[ojdbc8.jar:12.2.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:255) ~[ojdbc8.jar:12.2.0.1.0]
        at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:142) ~[tomcat-dbcp.jar:8.5.23]
        at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:142) ~[tomcat-dbcp.jar:8.5.23]
        at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:1415) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:1336) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:1511) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:606) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1931) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:449) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.sql.SQLDataSource.executeUpdate(SQLDataSource.java:398) ~[isomorphic-sql-12.1-p20220213.jar:?]
        at com.isomorphic.datasource.DataSource.execute(DataSource.java:2574) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3093) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.juve.eleven.richieste.UpdateRichiestaClienteDMI.update(UpdateRichiestaClienteDMI.java:239) ~[classes/:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_252]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_252]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_252]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_252]
        at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:581) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:896) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3088) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic-core-rpc-12.1-p20220213.jar:?]
        at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-12.1-p20220213.jar:?]
    If I remove the length or the customUpdateExpression (one of them or both), then it works.

    #2
    This error occurs at JDBC level when setting parameters to the prepared SQL statement, specifically when setting too many parameters (more than SQL statement actually expects). That said we failed to create scenario to reproduce this issue, also it is unclear how this can depend on length/customUpdateExpression attributes present or missing.
    Could you please provide a standalone use case or at least more details to help us understand circumstances leading to the issue. These have to be quite specific as regular UPDATE is a very basic operation and if it would be essentially broken we would have more users reporting this.

    Comment


      #3
      Hello, actually I could reproduce it with a test case simple as this:

      dataSource:
      Code:
      <DataSource
                  schema="DBELEVEN"
                  dbName="dbEleven"
                  tableName="TEST_CASE"
                  ID="TEST_CASE"
                  serverType="sql"
              >
          <fields>
              <field primaryKey="true" name="ID_REC" type="sequence"/>
              <field name="DESCRIZIONE_PAG_SECONDA" type="text"
                     customUpdateExpression="#if ($values.INCLUDI_SECONDA_PARTE) #if ($values.DESCRIZIONE_PAG_SECONDA) $values.DESCRIZIONE_PAG_SECONDA #else null #end #else null #end">
              </field>
      
          </fields>
      </DataSource>
      table:
      Code:
      create table TEST_CASE
      (
          ID_REC NUMBER not null
              constraint TEST_CASE_PK
                  primary key,
          DESCRIZIONE_PAG_SECONDA VARCHAR2(4000)
      )
      when I execute:
      Code:
      TEST_CASE.updateData({
              ID_REC:1, DESCRIZIONE_PAG_SECONDA:null
          })
      I get this error (note that I've also updated the ojdbc8.jar file):

      Code:
      2022-02-18T18:27:43,916 DEBUG DSRequest Caching instance 500 of DS 'TEST_CASE' from DSRequest.getDataSource()
      2022-02-18T18:27:43,916 DEBUG DSRequest Caching instance 500 of DS TEST_CASE
      2022-02-18T18:27:43,917 DEBUG RPCManager Request #1 (DSRequest) payload: {
          criteria:{
              ID_REC:1
          },
          values:{
              ID_REC:1,
              DESCRIZIONE_PAG_SECONDA:null
          },
          operationConfig:{
              dataSource:"TEST_CASE",
              repo:null,
              operationType:"update",
              textMatchStyle:"exact"
          },
          appID:"builtinApplication",
          operation:"TEST_CASE_update",
          oldValues:{
              ID_REC:1,
              DESCRIZIONE_PAG_SECONDA:null
          }
      }
      2022-02-18T18:27:43,917 INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36]
      2022-02-18T18:27:43,917 INFO DSRequest Executing TEST_CASE.update with
      criteria: {ID_REC:1}
      values: {ID_REC:1, DESCRIZIONE_PAG_SECONDA:null}
      2022-02-18T18:27:43,917 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
      2022-02-18T18:27:43,917 DEBUG DeclarativeSecurity DataSource TEST_CASE is not in the pre-checked list, processing...
      2022-02-18T18:27:43,918 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
      2022-02-18T18:27:43,918 DEBUG AppBase No public zero-argument method named '_TEST_CASE_update' found, performing generic datasource operation
      2022-02-18T18:27:43,949 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1293466409'
      2022-02-18T18:27:43,949 DEBUG SQLConnectionManager Borrowed connection '1293466409'
      2022-02-18T18:27:43,949 DEBUG SQLTransaction Started new dbEleven transaction "1293466409"
      2022-02-18T18:27:43,950 INFO SQLDriver Executing SQL query on 'dbEleven': UPDATE DBELEVEN.TEST_CASE SET DESCRIZIONE_PAG_SECONDA= null WHERE (TEST_CASE.ID_REC=1)
      2022-02-18T18:27:43,953 DEBUG DSRequest freeOnExecute is false for request of type update on DataSource TEST_CASE - not freeing resources!
      2022-02-18T18:27:43,953 WARN RequestContext dsRequest.execute() failed:
      java.sql.SQLException: Indice di colonna non valido
          at oracle.jdbc.driver.OraclePreparedStatement.setFormOfUseInternal(OraclePreparedStatement.java:10797) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OraclePreparedStatement.setFormOfUseInternal(OraclePreparedStatement.java:10778) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5070) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:248) ~[ojdbc8.jar:21.5.0.0.0]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:142) ~[tomcat-dbcp.jar:8.5.23]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:142) ~[tomcat-dbcp.jar:8.5.23]
          at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:1415) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:1336) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:1511) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:606) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1931) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:449) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeUpdate(SQLDataSource.java:398) ~[isomorphic-sql-12.1-p20220213.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:2574) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3093) ~[isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-12.1-p20220213.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-12.1-p20220213.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.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:85) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-12.1-p20220213.jar:?]
          at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-12.1-p20220213.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:97) [cas-client-core-3.5.1.jar:3.5.1]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) [spring-security-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.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-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.6.RELEASE.jar:5.1.6.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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-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.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-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.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-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.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.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.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          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.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:185) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.23]
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.23]
      2022-02-18T18:27:43,954 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
      2022-02-18T18:27:43,954 DEBUG SQLTransaction Rolling back dbEleven transaction "1293466409"
      2022-02-18T18:27:43,986 DEBUG RPCManager non-DMI response, dropExtraFields: false
      2022-02-18T18:27:43,986 DEBUG DSRequest freeResources called for DSRequest 1401460094
      2022-02-18T18:27:43,987 DEBUG SQLTransaction getConnection() looked for transactional connection for dbEleven: hashcode "1293466409"
      2022-02-18T18:27:43,987 DEBUG SQLTransaction Ending dbEleven transaction "1293466409"
      2022-02-18T18:27:43,995 DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "1293466409"
      2022-02-18T18:27:44,020 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 500 of type 'TEST_CASE' with hashCode '2093617161'
      2022-02-18T18:27:44,020 INFO Compression /Eleven/isomorphic/IDACall: 164 -> 144
      2022-02-18T18:27:44,021 DEBUG ExceptionTranslationFilter Chain processed normally
      2022-02-18T18:27:44,021 DEBUG SecurityContextPersistenceFilter SecurityContextHolder now cleared, as request processing completed
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.23]
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [catalina.jar:8.5.23]
          at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.23]
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_252]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_252]
          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.23]
          at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]
      2022-02-18T18:27:44,102 DEBUG AntPathRequestMatcher Checking match of request : '/isomorphic/skins/Graphite/images/Dialog/warn.png'; against '/isomorphic/RESTHandler/**'
      2022-02-18T18:27:44,102 DEBUG AntPathRequestMatcher Checking match of request : '/isomorphic/skins/Graphite/images/Dialog/warn.png'; against '/isomorphic/skins/**'
      2022-02-18T18:27:44,103 DEBUG FilterChainProxy /isomorphic/skins/Graphite/images/Dialog/warn.png has an empty filter list
      2022-02-18T18:27:44,103 DEBUG AntPathRequestMatcher Checking match of request : '/isomorphic/skins/Graphite/images/headerIcons/close.png'; against '/isomorphic/RESTHandler/**'
      2022-02-18T18:27:44,103 DEBUG AntPathRequestMatcher Checking match of request : '/isomorphic/skins/Graphite/images/headerIcons/close.png'; against '/isomorphic/skins/**'
      2022-02-18T18:27:44,103 DEBUG FilterChainProxy /isomorphic/skins/Graphite/images/headerIcons/close.png has an empty filter list
      please let me know if I may provide more useful details

      Comment


        #4
        Apologies for the delay. Thank you for the details, we've reproduced the issue and will follow up once it is fixed, which will most likely be early next week.

        Comment


          #5
          Thank you for your patience. This is fixed and available for download in latest nightly builds, let us know please how it worked for you.

          Comment


            #6
            SmartClient Version: v12.1p_2022-03-15/Enterprise Deployment (built 2022-03-15)

            Hello, I can confirm it's fixed, thank you very much

            Comment

            Working...
            X