Non persistable object gives database error (timed out)
0
In one of our applications we get a "Read timed out" error on a non persistable object. It happens in a huge microflow that does a lot of calculations and usage of non persistable object. 2 Questions: 1. How is it possible to get a "Read timed out" error on a non persistable object? 2. Any tips how to solve this error? Note: We got this error after upgrade van SQL Server 2005 to 2012. Stacktrace of the error where CashPositionYear is a non persistable object. Advanced stacktrace: at mz.a(SourceFile:185) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: n: Error occurred while reserving the next 100 object identifiers of entity App.CashPositionYear. at hG.a(SourceFile:184) Caused by: com.mendix.core.CoreRuntimeException: n: Error occurred while reserving the next 100 object identifiers of entity App.CashPositionYear. at hG.b(SourceFile:218) Caused by: n: Error occurred while reserving the next 100 object identifiers of entity App.CashPositionYear. at w.a(SourceFile:106) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667) at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1789) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6154) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6106) at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:1901) at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328) at w.a(SourceFile:86)