How to increase internal object limit in Database replication?

0
java.sql.SQLException: [SQL7049] An internal object limit has been exceeded. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:701) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:667) at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1008) at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237) at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getColumns(AS400JDBCDatabaseMetaData.java:1075) at databasereplication.implementation.CustomReader.processDatabase(CustomReader.java:63) at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:66) at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:28) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hG.b(SourceFile:206) at com.mendix.core.Core.execute(SourceFile:226) at lp.a(SourceFile:69) at mz.a(SourceFile:77) at my.a(SourceFile:155) at my.executeAction(SourceFile:98) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hG.b(SourceFile:206) at com.mendix.core.Core.execute(SourceFile:226) at gp.execute(SourceFile:186) at jf.a(SourceFile:321) at com.mendix.externalinterface.connector.RequestDispatching$Worker.a(SourceFile:170) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.a(SourceFile:161) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.apply(SourceFile:160) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(SourceFile:156) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192)
asked
2 answers
1

Based on my research, this error is generated from the IBM AS/400, and that there are too many concurrent stored procedures with open result sets. Is it possible that connections (ResultSet) aren't being closed in the replication Java code?

answered
0

The error you are getting is from the as400 server you are connecting too. There isn't anything in the db replication module that you can change to preven this.

You should look into the AS400 server and see where this comes from, by doing a quick search it seems that there are to many open transactions on your database and that is why the connection is being refused.

answered