Connection close error in outsystems 9

Connection close error in outsystems 9

  
Hi, 
What could be possible cause of below error which is happening fequently in outsystem 9.1

Module:
CompilerService
Message:
Invalid compiler output.
The connection is closed: The connection is closed
Environment Information  
Stack:
Exception Details:
[1] Internal Error: Invalid compiler output.
The connection is closed: The connection is closed
   at outsystems.hubedition.compiler.Compiler.compile(Unknown Source)
   at outsystems.hubedition.compiler.Compiler.$zkn(Unknown Source)
   at outsystems.hubedition.compiler.Compiler$$Lambda$125/540732590.executeImplLambda(Unknown Source)
   at outsystems.hubedition.util.delegates.Action$Action0_Lambda.execute(Unknown Source)
   at outsystems.hubedition.compiler.utils.CompilerUtils.withOverridenSettings(Unknown Source)
   at outsystems.hubedition.compiler.Compiler.$xfn(Unknown Source)
   at outsystems.hubedition.compiler.Compiler$$Lambda$124/1647939748.executeImplLambda(Unknown Source)
   at outsystems.hubedition.util.delegates.Action$Action0_Lambda.execute(Unknown Source)
   at outsystems.hubedition.util.delegates.ThreadStart_Lambda.run(Unknown Source)
   at java.lang.Thread.run(Thread.java:745)
[2] java.sql.SQLException: The connection is closed: The connection is closed
   at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:473)
   at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:457)
   at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:285)
   at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.invoke(ConnectionProxyFactory.java:48)
   at com.sun.proxy.$Proxy3.getAutoCommit(Unknown Source)
   at outsystems.hubedition.databaseabstractionlayer.adoadapters.ConnectionUtils.closeConnection(Unknown Source)
   at outsystems.hubedition.databaseprovider.oracle.transactionservice.TransactionService.createConnection(Unknown Source)
   at outsystems.hubedition.extensibility.data.transactionservice.BaseTransactionService.createConnection(Unknown Source)
   at outsystems.hubedition.extensibility.data.transactionservice.GenericTransactionManager.getConnection(Unknown Source)
   at outsystems.hubedition.extensibility.data.transactionservice.GenericTransactionManager.buildTransactionInfo(Unknown Source)
   at outsystems.hubedition.extensibility.data.transactionservice.GenericTransactionManager.addToPoolAndReserve(Unknown Source)
   at outsystems.hubedition.extensibility.data.transactionservice.GenericTransactionManager.getCommitableTransaction(Unknown Source)
   at outsystems.internal.db.DatabaseAccessProvider.getCommitableTransaction(Unknown Source)
   at outsystems.hubedition.servercommon.PlatformDatabaseAccess.getAdminTransaction(Unknown Source)
   at outsystems.hubedition.compiler.AbstractEntity.loadTableNameAndMissingStatus(Unknown Source)
   at outsystems.hubedition.compiler.AbstractEntity.ensureTableNameLoaded(Unknown Source)
   at outsystems.hubedition.compiler.AbstractEntity.getTableName(Unknown Source)
   at outsystems.hubedition.compiler.AbstractEntity.getMetadataString(Unknown Source)
   at outsystems.hubedition.compiler.AbstractRecord.dumpMetaInformation(Unknown Source)
   at outsystems.hubedition.compiler.AbstractRecord.dumpJava(Unknown Source)
   at outsystems.hubedition.compiler.AbstractRecord.dump(Unknown Source)
   at outsystems.hubedition.compiler.AbstractEntity.dump(Unknown Source)
   at outsystems.hubedition.compiler.iIiiiiiiiiIii.dump(Unknown Source)
   at outsystems.hubedition.compiler.ESpace.dumpEntitiesJava(Unknown Source)
   at outsystems.hubedition.compiler.ESpace.dumpEntities(Unknown Source)
   at outsystems.hubedition.compiler.ESpace.dump(Unknown Source)
   at outsystems.hubedition.compiler.Compiler.innerCompile(Unknown Source)
   at outsystems.hubedition.compiler.Compiler.compile(Unknown Source)
   at outsystems.hubedition.compiler.Compiler.$zkn(Unknown Source)
   at outsystems.hubedition.compiler.Compiler$$Lambda$125/540732590.executeImplLambda(Unknown Source)
   at outsystems.hubedition.util.delegates.Action$Action0_Lambda.execute(Unknown Source)
   at outsystems.hubedition.compiler.utils.CompilerUtils.withOverridenSettings(Unknown Source)
   at outsystems.hubedition.compiler.Compiler.$xfn(Unknown Source)
   at outsystems.hubedition.compiler.Compiler$$Lambda$124/1647939748.executeImplLambda(Unknown Source)
   at outsystems.hubedition.util.delegates.Action$Action0_Lambda.execute(Unknown Source)
   at outsystems.hubedition.util.delegates.ThreadStart_Lambda.run(Unknown Source)
   at java.lang.Thread.run(Thread.java:745)

Unstable network conditions? It seems the exception is thrown when the JDBC tries to connect to the database, which fails.

Kilian Hekhuis wrote:

Unstable network conditions? It seems the exception is thrown when the JDBC tries to connect to the database, which fails.

 Hi Kilian,
Well it was not an issue with unstable network. The issue was mainly with dba_profiles table for outsystem profile. I had to change few parameters to unlimited to get rid of issue.

 

Hi Barun,

Great to hear you solved it!