Hello, I have a data grid page I use for reports, however it randomly started showing me an error, can someone explain what might be happening in this situation, is there too many entires or something of that nature? : 'Administrator'] 11:15:29 AMruntime-container/2nvpxcom.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//Module1.OrderLine","amount":20,"offset":0,"returnsCount":true,"sort":[{"memberName":"Module1.OrderLine_Order/Module1.Order/Order_Number","direction":{}}],"type":"RetrieveXPathSchemaRawAction"}', all database changes executed by this action were rolled back 11:15:29 AMruntime-container/2nvpxat com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:153) 11:15:29 AMruntime-container/2nvpx2025-10-24T15:15:29.452038138Z 11:15:29 AMruntime-container/2nvpxCaused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 11:15:29 AMruntime-container/2nvpxInternalLimitedXPathTextGetRequest (depth = -1, amount = 20): //Module1.OrderLine 11:15:29 AMruntime-container/2nvpxat com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:35) 11:15:29 AMruntime-container/2nvpx2025-10-24T15:15:29.452072718Z 11:15:29 AMruntime-container/2nvpxCaused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Error on retrieving aggregate results. 11:15:29 AMruntime-container/2nvpxat com.mendix.connectionbus.retrieve.QueryRequestExecutor.$anonfun$handleAggregateResult$4(QueryRequestExecutor.scala:147) 11:15:29 AMruntime-container/2nvpx2025-10-24T15:15:29.452103628Z 11:15:29 AMruntime-container/2nvpxCaused by: java.util.concurrent.ExecutionException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 22003, Error Code: 0) Thank you in advance for any help.
asked
Alexander Eitland
1 answers
1
It occurs because the data grid is trying to load or calculate too much information from the database at once. The message “SQL State: 22003” means that the database is receiving numbers or results that are too large to handle, often caused by having too many records or very large numeric values. It can also happen if the grid includes aggregate functions like totals or counts, or if sorting is applied on associated attributes such as Order Number. When the data volume grows too big, Mendix struggles to process it, and the operation fails. To fix this, you can limit the number of records shown by adding filters, remove unnecessary sorting or total columns, and if any attribute stores large numeric values, change its type from Integer to Long. In simple terms, the issue happens because the report tries to handle too much data at once, and reducing or filtering the data will usually solve the problem.