SAP hybris 6.3 cannot connect to jdbc (Check Server and network status)

[former_member97068]

Hello Experts,

I have an issue regarding to a SAP Hybris node in a Testing environment which is connected to a multitenant SAP Hana database ; when I see the logs on /opt/hybris/log/tomcat/console-yearmonthday.log I see the following message:

ERROR [TransferQueueBundler,hybris-broadcast,hybrisnode-0] [TCP] JGRP000036: hybrisnode-0: exception sending bundled msgs: java.net.SocketTimeoutException INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | java.net.SocketTimeoutException: null INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at java.net.SocksSocketImpl.remainingMillis(SocksSocketImpl.java:111) ~[?:1.8.0_161] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_161] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_161] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.util.Util.connect(Util.java:411) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.blocks.cs.TcpConnection.connect(TcpConnection.java:101) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.blocks.cs.TcpConnection.connect(TcpConnection.java:91) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.blocks.cs.BaseServer.getConnection(BaseServer.java:271) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.blocks.cs.BaseServer.send(BaseServer.java:184) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.TCP.send(TCP.java:60) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.BasicTCP.sendUnicast(BasicTCP.java:128) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.TP.sendToSingleMember(TP.java:1951) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.TP.doSend(TP.java:1939) ~[jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.BaseBundler.sendMessageList(BaseBundler.java:129) [jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.BaseBundler.sendBundledMessages(BaseBundler.java:88) [jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at org.jgroups.protocols.TransferQueueBundler.run(TransferQueueBundler.java:105) [jgroups-3.6.11.Final.jar:3.6.11.Final] INFO | jvm 2 | main | 2019/06/03 12:04:30.674 | at java.lang.Thread.run(Thread.java:748) [?:1.8.0_161] INFO | jvm 2 | main | 2019/06/03 12:04:39.581 | WARN [full-apparel-ukIndex-cronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (full-apparel-ukIndex-cronJob) [SolrIndexerJob] Error during indexer call: apparel-ukIndex INFO | jvm 2 | main | 2019/06/03 12:04:39.581 | de.hybris.platform.solrfacetsearch.indexer.exceptions.IndexerException: de.hybris.platform.solrfacetsearch.solr.exceptions.SolrServiceException: de.hybris.platform.servicelayer.exceptions.ModelSavingException: [de.hybris.platform.servicelayer.interceptor.impl.UniqueAttributesInterceptor@4e0b484d]: unexpected validator error: SQL search error - SAP DBTech JDBC: Cannot connect to jdbc:sap://10.82.0.134:33071/QCH [Connection to database server lost; check server and network status [System error: Connection reset]]. query = 'null', values = [70972, 8796123856978] INFO | jvm 2 | main | 2019/06/03 12:04:39.581 | at de.hybris.platform.solrfacetsearch.indexer.listeners.IndexerOperationListener.afterPrepareContext(IndexerOperationListener.java:97) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.581 | at de.hybris.platform.solrfacetsearch.indexer.impl.DefaultIndexerContextFactory.executeAfterPrepareListeners(DefaultIndexerContextFactory.java:168) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.impl.DefaultIndexerContextFactory.prepareContext(DefaultIndexerContextFactory.java:97) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.strategies.impl.AbstractIndexerStrategy.doExecute(AbstractIndexerStrategy.java:147) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.strategies.impl.AbstractIndexerStrategy.execute(AbstractIndexerStrategy.java:116) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.impl.DefaultIndexerService.performFullIndex(DefaultIndexerService.java:68) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.cron.SolrIndexerJob.indexItems(SolrIndexerJob.java:78) ~[solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.cron.SolrIndexerJob.performIndexingJob(SolrIndexerJob.java:57) [solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.solrfacetsearch.indexer.cron.AbstractIndexerJob.perform(AbstractIndexerJob.java:40) [solrfacetsearchserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob.performCronJob(ServicelayerJob.java:38) [processingserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1358) [processingserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:814) [processingserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.cronjob.jalo.Job.access$1(Job.java:767) [processingserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.cronjob.jalo.Job$JobRunable.run(Job.java:686) [processingserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | at de.hybris.platform.util.threadpool.PoolableThread.run(PoolableThread.java:195) [coreserver.jar:?] INFO | jvm 2 | main | 2019/06/03 12:04:39.582 | Caused by: de.hybris.platform.solrfacetsearch.solr.exceptions.SolrServiceException: de.hybris.platform.servicelayer.exceptions.ModelSavingException: [de.hybris.platform.servicelayer.interceptor.impl.UniqueAttributesInterceptor@4e0b484d]: unexpected validator error: SQL search error - SAP DBTech JDBC: Cannot connect to jdbc:sap://10.82.0.134:33071/QCH [Connection to database server lost; check server and network status [System error: Connection reset]]. query = 'null', values = [70972, 8796123856978]

By the message , I'm told that there's an issue with the connection to the database server ; I have performed the following procedures:

*Ensure that the local properties is updated and the db user and password is maintained as well

*Tha database server is operated by another consultancy service so I have notified them to check on any changes on the tenant

My main question is, where else shall I check this error on hybris server , is there a way or steps to ensure that this error is due to network status

Thank you for your help