Scheduler service - Connection closed
Application Type
Traditional Web
Service Studio Version
10.0.613.0
Platform Version
10.0.604.0

Hi,

I am getting DB connection closed on scheduer service on one of the environment and couldn't figure out why its happening only in that environment.

Verified with DB team and Firewall team and we don't see any abnormal activity.

I noted in one of the forum that Scheduler service uses Outsystem service pool. 

Is there anything that we could verify the configuration?

Any suggestion to fix this issue ?


Platform version : Java stack

Version 10.0.604.0

Error log :

Scheduler Service: Error dequeuing events null
Scheduler Service: Error fetching emails 

Stack trace :

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.getTransaction(Unknown Source)
at outsystems.hubedition.scheduler.EventJob.dequeueEvents(Unknown Source)
at outsystems.hubedition.scheduler.Scheduler.lambda$9(Unknown Source)
at outsystems.hubedition.scheduler.SchedulerProducerConsumer$PullJobsFromDatabaseDelegate_Lambda.execute(Unknown Source)
at outsystems.hubedition.scheduler.SchedulerProducerConsumer.innerExecuteProducer(Unknown Source)
at outsystems.hubedition.scheduler.SchedulerProducerConsumer.lambda$3(Unknown Source)
at outsystems.hubedition.util.delegates.Action$Action0_Lambda.execute(Unknown Source)
at outsystems.hubedition.servercommon.SandboxUtils.executeInMainSandbox(Unknown Source)
at outsystems.hubedition.scheduler.SchedulerProducerConsumer.executeProducer(Unknown Source)
at outsystems.hubedition.scheduler.SchedulerProducerConsumer.access$0(Unknown Source)
at outsystems.hubedition.scheduler.SchedulerProducerConsumer$2.executeImpl(Unknown Source)
at outsystems.hubedition.util.delegates.Action$Action0.executeImplLambda(Unknown Source)
at outsystems.hubedition.util.delegates.Action$Action0_Lambda.execute(Unknown Source)
at outsystems.hubedition.util.delegates.Action$Action0_Lambda.run(Unknown Source)
   at java.lang.Thread.run(Thread.java:748)

Hi Prabhu,

I have not worked with the java stack for a while, however as far as I recall each OutSystems service dumps the logs into /var/log/outsystems. Did you check there for more details in the scheduller service log file?

You can also try to changing the log level for the scheduller service (here).

If you cannot find the root cause of the issue you should open a support ticket with OS support. They can help you troubleshooting your environment.

IG

Hi Ivo,

These logs are printed only on service center. Nothing is printed on Outsystems logs.

Thanks for passing along adding trace on logs which I can try and see.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.