Database replication when sync the database : An internal object limit has been exceeded

0
Hi all,   I am getting below error when I do sync the database in Mendix version 9.24.1. I am using custom database type to connect AS400. Does anyone know the solution or root cause?   2024-02-08 18:03:52.400 ERROR - CustomReader: An error occurred while processing columns for table: ABCTable - resuming the importjava.sql.SQLException: [SQL7049] An internal object limit has been exceeded.        at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:899)        at com.ibm.as400.access.JDError.throwSQLException(JDError.java:686)        at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1043)        at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1413)        at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getColumns(AS400JDBCDatabaseMetaData.java:1100)        at databasereplication.implementation.DbReader.CustomReader.processDatabase(CustomReader.java:135)        at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:64)        at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:26)        at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)        at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)        at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:106)        at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)        at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:105)        at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:57)        at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:35)        at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:11)        at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:38)        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:167)        at scala.Option.flatMap(Option.scala:283)        at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:167)        at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:114)        at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)        at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59)        at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)        at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)        at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59)        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46)        at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)        at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:89)        at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:678)        at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:467)        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)        at java.base/java.lang.Thread.run(Thread.java:829)
asked
1 answers
0

This forum post has some answers regarding the same issue. It's not really something that can be fixed in Mendix it seems.

answered