You are trying to use a non-persistable entity, and the exporter is complaining.
'SistemaGestionAlmacen.Paleta' is not a persistable entity
The solution is to make the Paleta entity persistable. Once you have completed the export, you can then carry out some housekeeping to delete the objects that are no longer needed.
Hope this helps.
An error has occurred while handling the request. [User '2' with session id '973074f4-XXXX-XXXX-XXXX-XXXXXXXX81f7' and roles 'Usuario']
--------
com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
InternalOqlTextGetRequest (depth = -1): SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM "SistemaGestionAlmacen"."Paleta" AS aa77e9874 INNER JOIN "aa77e9874"/"SistemaGestionAlmacen"."Paleta_ResourceExcelDocument"/"SistemaGestionAlmacen"."ResourceExcelDocument" AS refobject ON refobject/ID = 30117822508041393 ;
at SistemaGestionAlmacen.DS_PruebaPaleta (JavaAction : 'GenerateExcelDoc')
Advanced stacktrace:
at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:85)
Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
InternalOqlTextGetRequest (depth = -1): SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM "SistemaGestionAlmacen"."Paleta" AS aa77e9874 INNER JOIN "aa77e9874"/"SistemaGestionAlmacen"."Paleta_ResourceExcelDocument"/"SistemaGestionAlmacen"."ResourceExcelDocument" AS refobject ON refobject/ID = 30117822508041393 ;
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:156)
Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
InternalOqlTextGetRequest (depth = -1): SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM "SistemaGestionAlmacen"."Paleta" AS aa77e9874 INNER JOIN "aa77e9874"/"SistemaGestionAlmacen"."Paleta_ResourceExcelDocument"/"SistemaGestionAlmacen"."ResourceExcelDocument" AS refobject ON refobject/ID = 30117822508041393 ;
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:30)
Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
InternalOqlTextGetRequest (depth = -1): SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM "SistemaGestionAlmacen"."Paleta" AS aa77e9874 INNER JOIN "aa77e9874"/"SistemaGestionAlmacen"."Paleta_ResourceExcelDocument"/"SistemaGestionAlmacen"."ResourceExcelDocument" AS refobject ON refobject/ID = 30117822508041393 ;
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:156)
Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
InternalOqlTextGetRequest (depth = -1): SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM "SistemaGestionAlmacen"."Paleta" AS aa77e9874 INNER JOIN "aa77e9874"/"SistemaGestionAlmacen"."Paleta_ResourceExcelDocument"/"SistemaGestionAlmacen"."ResourceExcelDocument" AS refobject ON refobject/ID = 30117822508041393 ;
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:30)
Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
InternalOqlTextGetRequest (depth = -1): SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM "SistemaGestionAlmacen"."Paleta" AS aa77e9874 INNER JOIN "aa77e9874"/"SistemaGestionAlmacen"."Paleta_ResourceExcelDocument"/"SistemaGestionAlmacen"."ResourceExcelDocument" AS refobject ON refobject/ID = 30117822508041393 ;
at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:63)
Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: 'SistemaGestionAlmacen.Paleta' is not a persistable entity, exception occurred on mapping the following query: SELECT aa77e9874.T_CODIGO AS T_CODIGO0, aa77e9874.T_DENOMI AS T_DENOMI0, aa77e9874.N_TARPAL AS N_TARPAL0, aa77e9874.N_PROPIE AS N_PROPIE0, aa77e9874.T_RAZSOC AS T_RAZSOC0 FROM SistemaGestionAlmacen.Paleta AS aa77e9874 INNER JOIN aa77e9874/SistemaGestionAlmacen.Paleta_ResourceExcelDocument/SistemaGestionAlmacen.ResourceExcelDocument AS refobject ON refobject/ID = 30117822508041393
at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:281)
Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: 'SistemaGestionAlmacen.Paleta' is not a persistable entity
at com.mendix.connectionbus.retrieve.query.mapping.MetaObjectInfo.getMetaObject(MetaObjectInfo.java:171)
Caused by: com.mendix.core.CoreRuntimeException: 'SistemaGestionAlmacen.Paleta' is not a persistable entity
at com.mendix.connectionbus.DomainModelUtilImpl.getPersistableMetaObject(DomainModelUtil.scala:45)
at com.mendix.connectionbus.retrieve.query.mapping.MetaObjectInfo.getMetaObject(MetaObjectInfo.java:148)
at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.getColumnLocation(SelectColumnsMapper.java:322)
at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.handleDoubleLocationSelectColumn(SelectColumnsMapper.java:223)
at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.handleLocationSelectColumn(SelectColumnsMapper.java:151)
at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.handleColumn(SelectColumnsMapper.java:86)
at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.mapSelectColumns(SelectColumnsMapper.java:52)
at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.mapSelectColumns(QueryMapper.java:741)
at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:251)
at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getQueryInstances(QueryMapper.java:148)
at com.mendix.connectionbus.retrieve.OqlRequestHandler.doOldQueryHandling(OqlRequestHandler.scala:203)
at com.mendix.connectionbus.retrieve.OqlRequestHandler.$anonfun$handleRequest$5(OqlRequestHandler.scala:104)
at scala.util.Try$.apply(Try.scala:210)
at com.mendix.connectionbus.retrieve.OqlRequestHandler.handleRequest(OqlRequestHandler.scala:104)
at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:41)
at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:35)
at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:117)
at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:104)
at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35)
at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:35)
at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:33)
at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:65)
at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:49)
at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:514)
at com.mendix.basis.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:87)
at com.mendix.basis.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:18)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)
at com.mendix.basis.component.InternalCoreBase.retrieveOQLDataTable(InternalCoreBase.java:806)
at com.mendix.basis.component.InternalCoreBase.retrieveOQLDataTable(InternalCoreBase.java:100)
at com.mendix.core.Core.retrieveOQLDataTable(Core.java:1121)
at xlsreport.report.DataOQL.getRowData(DataOQL.java:89)
at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:133)
at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:34)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)
at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:30)
at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:56)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:32)
at scala.Option.flatMap(Option.scala:283)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:29)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAfterBreakingIfNecessary$2(MicroflowImpl.scala:172)
at scala.Option.flatMap(Option.scala:283)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:172)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:119)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)
at com.mendix.basis.actionmanagement.MicroflowCallBuilderImpl.execute(MicroflowCallBuilderImpl.scala:40)
at com.mendix.webui.actions.client.ExecuteMicroflowAction.runMicroflow(ExecuteMicroflowAction.scala:76)
at com.mendix.webui.actions.client.ExecuteMicroflowAction.$anonfun$apply$3(ExecuteMicroflowAction.scala:42)
at com.mendix.webui.actions.client.RegularClientAction$Helpers$.$anonfun$liftEither$1(RegularClientAction.scala:29)
at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.$anonfun$apply$4(RegularClientAction.scala:55)
at com.mendix.webui.requesthandling.helpers.StateHandling.withState(StateHandling.scala:37)
at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:34)
at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.withState(RegularClientAction.scala:45)
at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:53)
at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:45)
at com.mendix.webui.actions.client.ExecuteMicroflowAction.apply(ExecuteMicroflowAction.scala:43)
at com.mendix.webui.actions.client.ExecuteMicroflowAction.apply(ExecuteMicroflowAction.scala:22)
at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$3(RegularClientAction.scala:109)
at scala.util.Try$.apply(Try.scala:210)
at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2(RegularClientAction.scala:109)
at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2$adapted(RegularClientAction.scala:107)
at com.mendix.webui.requesthandling.helpers.ContextHandling.$anonfun$inContext$5(ContextHandling.scala:47)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)
at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)
at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)
at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)
at com.mendix.webui.requesthandling.helpers.ContextHandling$ClientMonitoredAction.monitor(ContextHandling.scala:59)
at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:47)
at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:27)
at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:86)
at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:24)
at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:19)
at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:86)
at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$1(RegularClientAction.scala:107)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)
at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest(ProfileHandling.scala:14)
at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest$(ProfileHandling.scala:10)
at com.mendix.webui.actions.client.RegularClientAction.profileRequest(RegularClientAction.scala:86)
at com.mendix.webui.actions.client.RegularClientAction.execute(RegularClientAction.scala:104)
at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:105)
at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:82)
at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:46)
at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:76)
at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:73)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)
at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:79)
at com.mendix.basis.impl.MxRuntimeImplBase.processRequest(MxRuntimeImplBase.java:857)
at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626)
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:834)