NullPointerException in SQLDataSource.getSQLClause with customSQL field

claudiobosticco · May 1, 2026, 9:30pm

SmartClient Version: v13.1p_2026-04-24/Enterprise Deployment (built 2026-04-24)

I’m encountering an intermittent NullPointerException in my custom server dataSource when working with SQLDataSource.getSQLClause:

Caused by: java.lang.NullPointerException
    at com.isomorphic.datasource.IncludeFromDefinition.create(IncludeFromDefinition.java:118)
    at com.isomorphic.datasource.DSRequest.buildIncludeFromDefinitions(DSRequest.java:8527)
    at com.isomorphic.datasource.DSRequest.buildFieldData(DSRequest.java:5947)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5707)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5671)

The exception occurs when executing:

SQLDataSource.getSQLClause(SQLClauseType.Values, dsRequest)

where dsRequest is built server-side, of type update, with criteria composed of a single primary key and some dynamic fields.
In some cases, these values contain only one field to update, but that field may be customSQL, so it will not appear in the generated SQL (and that’s exactly what I want to detect, to avoid executing a useless update).

Normally everything works, but I’d say I can frequently reproduce this error if I trigger two requests close together. The dataSource uses my custom serverConstructor via Spring.

Do you happen to have any idea what could be causing the problem? I’m not really sure how to debug this further.

claudiobosticco · May 1, 2026, 9:41pm

I forgot to mention that these update requests are created (under certain conditions) as a result of a fetch- one for each record in the dataList returned by the fetch. In this case, there are 75 records, so 75 DSRequests of type update are created.

I want to discard the unnecessary ones using that check, which occasionally fails, and then execute the remaining ones using SQLDataSource.executeAsBatch.

In practice, I’m able to reproduce the issue with two fetches triggered close together, and it seems that the error always occurs on the 75th DSRequest of type update.

Isomorphic · May 1, 2026, 11:35pm

The problem is earlier in the processing - we tried calling DataSourceManager.get() to get an instance of your DataSource, but something crashed. The later NPE isn’t the problem - once we can’t get the DataSource, there’s no way to complete the request.

Since this is happening with two nearly-concurrent requests, we would guess that your Spring serverConstructor has some sort of concurrency bug and threw an exception during DataSource creation.

If you look earlier in the log for something like “Couldn’t create DataSource” or “Failed to create data source” you should see us logging whatever exception your Spring code threw.

Isomorphic · May 3, 2026, 1:37am

Just to make it clear (we were doing a second review on this) - if you can’t find logs enough to figure out where the crash happened, please show us what you have in the logs, because we would want to improve the logs so that the cause is very clear.

Or if you did figure it out from the logs, perhaps just briefly tell the story to help other users? Thanks in advance.

claudiobosticco · May 3, 2026, 7:38pm

Hi, I haven’t spent much time investigating the issue yet, but for now I can say that I do see an earlier error in the logs:

WARN IncludeFromDefinition Failed to create data source 'SC_DOCUMENTI'. java.util.ConcurrentModificationException
    at java.base/java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:719)
    at java.base/java.util.LinkedHashMap$LinkedKeyIterator.next(LinkedHashMap.java:741)
    at com.isomorphic.datasource.DataSource.getDynamicDSGenerator(DataSource.java:1075)
    at com.isomorphic.datasource.DataSource.isUnPooledDynamicDS(DataSource.java:1099)
    at com.isomorphic.datasource.DataSourceManager._getDataSource(DataSourceManager.java:210)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:163)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:121)
    at com.isomorphic.datasource.DataSourceManager.get(DataSourceManager.java:313)
    at com.isomorphic.datasource.DataSource.getIncludeFromInfo(DataSource.java:10737)
    at com.isomorphic.datasource.BasicDataSource.init(BasicDataSource.java:732)
    at com.isomorphic.sql.SQLDataSource.init(SQLDataSource.java:270)
    at com.isomorphic.datasource.DataSource.initialize(DataSource.java:1150)
    at com.isomorphic.datasource.BasicDataSource.fromConfig(BasicDataSource.java:258)
    at com.isomorphic.datasource.DataSource.fromConfig(DataSource.java:1125)
    at com.isomorphic.datasource.DataSource.loadDS(DataSource.java:694)
    at com.isomorphic.datasource.DataSource.forName(DataSource.java:577)
    at com.isomorphic.datasource.PoolableDataSourceFactory.makeUnpooledObject(PoolableDataSourceFactory.java:128)
    at com.isomorphic.datasource.PoolableDataSourceFactory.makeObject(PoolableDataSourceFactory.java:154)
    at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1220)
    at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:90)
    at com.isomorphic.datasource.DataSourceManager._getDataSource(DataSourceManager.java:214)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:163)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:121)
    at com.isomorphic.datasource.DataSourceManager.get(DataSourceManager.java:313)
    at com.isomorphic.datasource.IncludeFromDefinition.create(IncludeFromDefinition.java:80)
    at com.isomorphic.datasource.DSRequest.buildIncludeFromDefinitions(DSRequest.java:8527)
    at com.isomorphic.datasource.DSRequest.buildFieldData(DSRequest.java:5947)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5707)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5671)

claudiobosticco · May 3, 2026, 9:03pm

I also noticed this log:

SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria

I’m not sure whether it’s relevant to the error. In any case, I could try setting the rpcManager/DSTransaction.

Isomorphic · May 3, 2026, 10:35pm

Questions:

Is that concurrent modification problem from the same thread, from earlier in it?
Is SC_DOCUMENTI the DataSource that was fielding the request? If not, how is it related?

We probably need the full request logs, but right now this is looking like an app-level concurrency issue, like running two threads through the same DataSource instance. Perhaps your Spring code that produces the DataSource also hangs onto it and does something with it later? That would be a no-no.

claudiobosticco · May 4, 2026, 10:15am

Hi, this is the full request log, and:

yes, it seems to be the same thread
yes, it’s the same dataSource that issued the requests

2026-05-04T11:47:35,207 [tid:50] DEBUG RPCManager Starting request parsing
2026-05-04T11:47:35,207 [tid:45] DEBUG RPCManager Starting request parsing
2026-05-04T11:47:35,208 [tid:45] DEBUG RPCManager Done request parsing
2026-05-04T11:47:35,208 [tid:45] DEBUG RPCManager Processing 1 requests.
2026-05-04T11:47:35,208 [tid:50] DEBUG RPCManager Done request parsing
2026-05-04T11:47:35,208 [tid:50] DEBUG RPCManager Processing 1 requests.
2026-05-04T11:47:35,208 [tid:45] DEBUG RPCManager Request #1 (DSRequest) payload: {
    criteria:{
    },
    operationConfig:{
        dataSource:"SC_DOCUMENTI",
        repo:null,
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    startRow:0,
    endRow:15,
    appID:"builtinApplication",
    operation:"SC_DOCUMENTI_fetch",
    oldValues:null,
    tenantId:null
}
2026-05-04T11:47:35,208 [tid:45] INFO DSRequest Executing SC_DOCUMENTI.fetch rows: 0->15 with
criteria: {}
2026-05-04T11:47:35,211 [tid:45] DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '884093923'
2026-05-04T11:47:35,211 [tid:45] DEBUG SQLConnectionManager Borrowed connection '884093923' from DBCP
2026-05-04T11:47:35,211 [tid:45] DEBUG SQLTransaction Started new dbJas transaction "884093923"
2026-05-04T11:47:35,212 [tid:45] INFO DSRequest Executing SC_DOCUMENTI.fetch rows: 0->15 with
criteria: {}
2026-05-04T11:47:35,212 [tid:45] DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2026-05-04T11:47:35,212 [tid:45] DEBUG AppBase No public zero-argument method named '_SC_DOCUMENTI_fetch' found, performing generic datasource operation
2026-05-04T11:47:35,213 [tid:50] DEBUG RPCManager Request #1 (DSRequest) payload: {
    criteria:{
    },
    operationConfig:{
        dataSource:"SC_DOCUMENTI",
        repo:null,
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    startRow:0,
    endRow:15,
    appID:"builtinApplication",
    operation:"SC_DOCUMENTI_fetch",
    oldValues:null,
    tenantId:null
}
2026-05-04T11:47:35,213 [tid:50] INFO DSRequest Executing SC_DOCUMENTI.fetch rows: 0->15 with
criteria: {}
2026-05-04T11:47:35,213 [tid:45] DEBUG SQLOrderClause no data; returning empty string
2026-05-04T11:47:35,214 [tid:45] INFO SQLWhereClause empty condition
2026-05-04T11:47:35,214 [tid:45] DEBUG SQL Executing row count query: SELECT COUNT(*) FROM $defaultTableClause$defaultAnsiJoinClause
2026-05-04T11:47:35,214 [tid:45] INFO SQL Executing SQL query on 'dbJas': SELECT COUNT(*) FROM DBJAS.SC_DOCUMENTI JOIN DBJAS.JAS_STAGIONI ON SC_DOCUMENTI.ID_STAGIONE_FK = JAS_STAGIONI.ID_REC LEFT OUTER JOIN DBJAS.JAS_SOCIETA SOCIETA ON SC_DOCUMENTI.ID_SCUOLA_CALCIO_FK = SOCIETA.ID_REC LEFT OUTER JOIN DBJAS.OSS_PLANNING_ATTIVITA OSS_PLANNING_ATTIVITA ON SC_DOCUMENTI.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC LEFT OUTER JOIN DBJAS.JAS_SOCIETA OSS_PLANNING_ATTIVITA_ID_SCUOLA_CALCIO_FK ON OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK = OSS_PLANNING_ATTIVITA_ID_SCUOLA_CALCIO_FK.ID_REC
2026-05-04T11:47:35,216 [tid:50] DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '889564978'
2026-05-04T11:47:35,216 [tid:50] DEBUG SQLConnectionManager Borrowed connection '889564978' from DBCP
2026-05-04T11:47:35,216 [tid:50] DEBUG SQLTransaction Started new dbJas transaction "889564978"
2026-05-04T11:47:35,216 [tid:50] INFO DSRequest Executing SC_DOCUMENTI.fetch rows: 0->15 with
criteria: {}
2026-05-04T11:47:35,216 [tid:50] DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2026-05-04T11:47:35,216 [tid:50] DEBUG AppBase No public zero-argument method named '_SC_DOCUMENTI_fetch' found, performing generic datasource operation
2026-05-04T11:47:35,217 [tid:50] DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '376030724'
2026-05-04T11:47:35,217 [tid:50] DEBUG SQLConnectionManager Borrowed connection '376030724' from DBCP
2026-05-04T11:47:35,217 [tid:50] INFO SQLDSGenerator Fetching column metadata for table: SC_DOCUMENTI
2026-05-04T11:47:35,217 [tid:50] INFO SQLDSGenerator =============Using catalog: null
2026-05-04T11:47:35,228 [tid:50] INFO SQLDSGenerator Fetching column metadata for SC_DOCUMENTI complete
2026-05-04T11:47:35,233 [tid:50] DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "376030724"
2026-05-04T11:47:35,235 [tid:50] DEBUG SQLOrderClause no data; returning empty string
2026-05-04T11:47:35,235 [tid:50] INFO SQLWhereClause empty condition
2026-05-04T11:47:35,236 [tid:50] DEBUG SQL Executing row count query: SELECT COUNT(*) FROM $defaultTableClause$defaultAnsiJoinClause
2026-05-04T11:47:35,236 [tid:50] INFO SQL Executing SQL query on 'dbJas': SELECT COUNT(*) FROM DBJAS.SC_DOCUMENTI JOIN DBJAS.JAS_STAGIONI ON SC_DOCUMENTI.ID_STAGIONE_FK = JAS_STAGIONI.ID_REC LEFT OUTER JOIN DBJAS.JAS_SOCIETA SOCIETA ON SC_DOCUMENTI.ID_SCUOLA_CALCIO_FK = SOCIETA.ID_REC LEFT OUTER JOIN DBJAS.OSS_PLANNING_ATTIVITA OSS_PLANNING_ATTIVITA ON SC_DOCUMENTI.ID_ATTIVITA_FK = OSS_PLANNING_ATTIVITA.ID_REC LEFT OUTER JOIN DBJAS.JAS_SOCIETA OSS_PLANNING_ATTIVITA_ID_SCUOLA_CALCIO_FK ON OSS_PLANNING_ATTIVITA.ID_SCUOLA_CALCIO_FK = OSS_PLANNING_ATTIVITA_ID_SCUOLA_CALCIO_FK.ID_REC
2026-05-04T11:47:35,338 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,340 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,351 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,353 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,371 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,372 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,382 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,384 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,406 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,408 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,414 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,415 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,445 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,448 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,448 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,449 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,476 [tid:50] WARN IncludeFromDefinition Failed to create data source 'SC_DOCUMENTI'. java.util.ConcurrentModificationException
    at java.base/java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:719)
    at java.base/java.util.LinkedHashMap$LinkedKeyIterator.next(LinkedHashMap.java:741)
    at com.isomorphic.datasource.DataSource.getDynamicDataSource(DataSource.java:1013)
    at com.isomorphic.datasource.DataSource.forName(DataSource.java:576)
    at com.isomorphic.datasource.PoolableDataSourceFactory.makeUnpooledObject(PoolableDataSourceFactory.java:128)
    at com.isomorphic.datasource.PoolableDataSourceFactory.makeObject(PoolableDataSourceFactory.java:154)
    at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1220)
    at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:90)
    at com.isomorphic.datasource.DataSourceManager._getDataSource(DataSourceManager.java:214)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:163)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:121)
    at com.isomorphic.datasource.DataSourceManager.get(DataSourceManager.java:313)
    at com.isomorphic.datasource.DataSource.getIncludeFromInfo(DataSource.java:10737)
    at com.isomorphic.datasource.BasicDataSource.init(BasicDataSource.java:732)
    at com.isomorphic.sql.SQLDataSource.init(SQLDataSource.java:270)
    at com.isomorphic.datasource.DataSource.initialize(DataSource.java:1150)
    at com.isomorphic.datasource.BasicDataSource.fromConfig(BasicDataSource.java:258)
    at com.isomorphic.datasource.DataSource.fromConfig(DataSource.java:1125)
    at com.isomorphic.datasource.DataSource.loadDS(DataSource.java:694)
    at com.isomorphic.datasource.DataSource.forName(DataSource.java:577)
    at com.isomorphic.datasource.PoolableDataSourceFactory.makeUnpooledObject(PoolableDataSourceFactory.java:128)
    at com.isomorphic.datasource.PoolableDataSourceFactory.makeObject(PoolableDataSourceFactory.java:154)
    at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1220)
    at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:90)
    at com.isomorphic.datasource.DataSourceManager._getDataSource(DataSourceManager.java:214)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:163)
    at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:121)
    at com.isomorphic.datasource.DataSourceManager.get(DataSourceManager.java:313)
    at com.isomorphic.datasource.IncludeFromDefinition.create(IncludeFromDefinition.java:80)
    at com.isomorphic.datasource.DSRequest.buildIncludeFromDefinitions(DSRequest.java:8527)
    at com.isomorphic.datasource.DSRequest.buildFieldData(DSRequest.java:5947)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5707)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5671)
    at com.juve.azure.storage.helpers.AzureDataSourceHandler.createUpdateRequest(AzureDataSourceHandler.java:905)
    at com.juve.azure.storage.helpers.AzureDataSourceHandler.updateSASUrlsAndSetFileMetadata(AzureDataSourceHandler.java:683)
    at com.juve.azure.storage.CustomBinaryFieldDataSource.executeFetch(CustomBinaryFieldDataSource.java:303)
    at com.isomorphic.datasource.DataSource.execute(DataSource.java:3397)
    at com.juve.azure.storage.CustomBinaryFieldDataSource.execute(CustomBinaryFieldDataSource.java:239)
    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:656)
    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555)
    at com.isomorphic.application.AppBase.execute(AppBase.java:498)
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4881)
    at com.isomorphic.datasource.DSRequest$execute$1.call(Unknown Source)
    at Script1.run(Script1.groovy:24)
    at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:317)
    at org.codehaus.groovy.jsr223.GroovyCompiledScript.eval(GroovyCompiledScript.java:71)
    at com.isomorphic.scripting.ScriptXBase.evalScript(ScriptXBase.java:551)
    at com.isomorphic.scripting.ScriptXBase.eval(ScriptXBase.java:76)
    at com.isomorphic.rpc.Scripting.evalServerScript(Scripting.java:141)
    at com.isomorphic.rpc.BuiltinRPC.evalServerScript(BuiltinRPC.java:763)
    at com.isomorphic.datasource.DataSourceDMI.evalInlineScript(DataSourceDMI.java:1010)
    at com.isomorphic.datasource.DataSourceDMI.evalInlineScript(DataSourceDMI.java:836)
    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:236)
    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4857)
    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:255)
    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:212)
    at com.juve.azure.storage.CustomBinaryFieldIDACall.processRPCTransaction(CustomBinaryFieldIDACall.java:22)
    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:153)
    at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:123)
    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:180)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at com.juve.spring.FrameOriginFilter.doFilter(FrameOriginFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263)
    at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter.doFilterInternal(DefaultLogoutPageGeneratingFilter.java:52)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:206)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:154)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
2026-05-04T11:47:35,479 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,481 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:643)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:398)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:939)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
    at java.base/java.lang.Thread.run(Thread.java:829)

2026-05-04T11:47:35,476 [tid:50] ERROR AzureDataSourceHandler Errore durante l'aggiornamento del record con primary key: 10185225 java.lang.NullPointerException
    at com.isomorphic.datasource.IncludeFromDefinition.create(IncludeFromDefinition.java:118)
    at com.isomorphic.datasource.DSRequest.buildIncludeFromDefinitions(DSRequest.java:8527)
    at com.isomorphic.datasource.DSRequest.buildFieldData(DSRequest.java:5947)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5707)
    at com.isomorphic.sql.SQLDataSource.getSQLClause(SQLDataSource.java:5671)
    at com.juve.azure.storage.helpers.AzureDataSourceHandler.createUpdateRequest(AzureDataSourceHandler.java:905)
    at com.juve.azure.storage.helpers.AzureDataSourceHandler.updateSASUrlsAndSetFileMetadata(AzureDataSourceHandler.java:683)
    at com.juve.azure.storage.CustomBinaryFieldDataSource.executeFetch(CustomBinaryFieldDataSource.java:303)
    at com.isomorphic.datasource.DataSource.execute(DataSource.java:3397)
    at com.juve.azure.storage.CustomBinaryFieldDataSource.execute(CustomBinaryFieldDataSource.java:239)
    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:656)
    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555)
    at com.isomorphic.application.AppBase.execute(AppBase.java:498)
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4881)
    at com.isomorphic.datasource.DSRequest$execute$1.call(Unknown Source)
    at Script1.run(Script1.groovy:24)
    at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:317)
    at org.codehaus.groovy.jsr223.GroovyCompiledScript.eval(GroovyCompiledScript.java:71)
    at com.isomorphic.scripting.ScriptXBase.evalScript(ScriptXBase.java:551)
    at com.isomorphic.scripting.ScriptXBase.eval(ScriptXBase.java:76)
    at com.isomorphic.rpc.Scripting.evalServerScript(Scripting.java:141)
    at com.isomorphic.rpc.BuiltinRPC.evalServerScript(BuiltinRPC.java:763)
    at com.isomorphic.datasource.DataSourceDMI.evalInlineScript(DataSourceDMI.java:1010)
    at com.isomorphic.datasource.DataSourceDMI.evalInlineScript(DataSourceDMI.java:836)
    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:236)
    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4857)
    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:255)
    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:212)
    at com.juve.azure.storage.CustomBinaryFieldIDACall.processRPCTransaction(CustomBinaryFieldIDACall.java:22)
    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:153)
    at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:123)
    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:180)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at com.juve.spring.FrameOriginFilter.doFilter(FrameOriginFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263)
    at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter.doFilterInternal(DefaultLogoutPageGeneratingFilter.java:52)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:206)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:154)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:643)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:398)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:939)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
    at java.base/java.lang.Thread.run(Thread.java:829)

2026-05-04T11:47:35,509 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,511 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,511 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,513 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,542 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,544 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,544 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,545 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,576 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,576 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,578 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,578 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,609 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,609 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,611 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,611 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,641 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,641 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,643 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,643 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,674 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,674 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,676 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,676 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,707 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,707 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,709 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,709 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,741 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,741 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,743 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,743 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,774 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,774 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,776 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,776 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,808 [tid:50] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,808 [tid:45] INFO SQLDataSource dsTransaction was null in getSQLClause() - cannot apply declarative criteria
2026-05-04T11:47:35,810 [tid:50] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,810 [tid:45] DEBUG rendering Null reference [template 'getSQLClause(Values)', line 1, column 1]: $defaultValuesClause cannot be resolved.
2026-05-04T11:47:35,810 [tid:45] INFO DSResponse DSResponse: List with 15 items
2026-05-04T11:47:35,810 [tid:50] INFO DSResponse DSResponse: List with 15 items
2026-05-04T11:47:35,810 [tid:45] INFO DSResponse DSResponse: List with 15 items
2026-05-04T11:47:35,810 [tid:50] INFO DSResponse DSResponse: List with 15 items
2026-05-04T11:47:35,810 [tid:50] DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2026-05-04T11:47:35,810 [tid:45] DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2026-05-04T11:47:35,810 [tid:50] DEBUG SQLTransaction Committing dbJas transaction "889564978"
2026-05-04T11:47:35,810 [tid:45] DEBUG SQLTransaction Committing dbJas transaction "884093923"
2026-05-04T11:47:35,810 [tid:50] DEBUG RPCManager DMI response, dropExtraFields: false
2026-05-04T11:47:35,810 [tid:45] DEBUG RPCManager DMI response, dropExtraFields: false
2026-05-04T11:47:35,811 [tid:45] DEBUG SQLTransaction getConnection() looked for transactional connection for dbJas: hashcode "884093923"
2026-05-04T11:47:35,811 [tid:50] DEBUG SQLTransaction getConnection() looked for transactional connection for dbJas: hashcode "889564978"
2026-05-04T11:47:35,811 [tid:45] DEBUG SQLTransaction Ending dbJas transaction "884093923"
2026-05-04T11:47:35,811 [tid:50] DEBUG SQLTransaction Ending dbJas transaction "889564978"
2026-05-04T11:47:35,811 [tid:45] DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "884093923"
2026-05-04T11:47:35,811 [tid:50] DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "889564978"

note that you will also see a log entry related to a call to DataSourceTools.getDataSourceConfigFromTable(), because I invoke it when initializing my custom server dataSource. I tried removing it since it’s not essential, but the problem still occurs.

What actually seems to “fix” the issue is assigning the dsTransaction to the dsRequest used in the call to SQLDataSource.getSQLClause() (so that the WARN from post #6 no longer appears).

However, I’m not sure whether this is a proper fix.

Isomorphic · May 8, 2026, 6:51pm

That’s a good change to make, because what you’ve done there is caused the DataSources that were already loaded for the current transaction to be used for SQL generation, instead of fetching a new one from the pool (or dynamically creating one, which is likely what’s happening here).

We see a potential concurrency hole here but it would require either:

your app code is repeatedly adding and removing DynamicDSGenerators
you’re using auditing with dynamically-generated audit DataSources
very heavy use of auditing, like continuously writing records in a background thread (this one is more of a maybe)

Are any of these true of your app?

Isomorphic · May 9, 2026, 12:29am

We actually went ahead with some “bulletproofing” where, even if you were doing any of these things, you could never cause an error - even covering cases that would definitely be borderline at best given the docs (not saying you were doing those things, but now you’d be covered anyway).

Can you please grab tomorrow’s build and temporarily revert the change to use the dsTransaction assignment on the DSRequest used for get getSQLClause(), to verify the new build avoids the error even in that less-efficient case? Once you’ve verified that, you should definitely re-apply that code change, for performance reasons as noted above.

claudiobosticco · May 9, 2026, 5:08pm

SmartClient Version: v13.1p_2026-05-09/Enterprise Deployment (built 2026-05-09)

Hi, regarding your post #9, the answer is no for all three points: there were no DynamicDSGenerators involved in that code path, nor any audit DataSources.

I tested the latest build using the previous version of my code that did not assign the dsTransaction, and I can no longer reproduce the error even in that case.

That said, I will obviously keep using the version that sets the dsTransaction.

Also, I have the impression that execution of that code path has become faster with the new build - is that possible, or is it just my impression?

In any case, thank you very much - excellent work!

Isomorphic · May 10, 2026, 1:28am

Are you using DynamicDSGenerators at all? Or perhaps using the multi-tenant system?

The only way we can imagine this change leading to a speedup is if your code was (directly or indirectly) adding a lot of DynamicDSGenerators - probably there’s something in your code that you intended to run once only, but which actually runs thousands of times.

claudiobosticco · May 11, 2026, 2:38pm

Hi, I don’t use DynamicDSGenerators directly. However, I do use DataSourceTools.getDataSourceConfigFromTable() and SQLDataSource.getSQLClause(), so perhaps those APIs involve DynamicDSGenerators indirectly?

In any case, your comment prompted me to review that part of the code, and I’ve now optimized it to drastically reduce the number of those calls.

Isomorphic · May 11, 2026, 10:01pm

Neither of those APIs use DynamicDSGenerators, but it’s very good that you are reducing calls to getDataSourceConfigFromTable() as that is entirely uncached at the framework level and pretty expensive.

The remaining theories as to your speedup:

you secretly really are using auditing or maybe multiTenancy or DynamicDSGenerators…

.. or ..

a lot of CMEs (ConcurrentModificationExceptions) were occuring and being swallowed by a silent exception handler. Throwing exceptions is fairly expensive