Connection to datasource is broken when running catalog sync jobs in SAP Commerce 1808

[former_member704915]

I am getting the below exceptions in the logs when I am trying to run the content catalog sync job for our application. This is happening intermittently and sometimes the jobs are successful, and sometimes failing with below error. Any pointers would help:

Synchronization Failure error message :-

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | SEVERE: Exception error looking up JNDI data source 'java:jdbc/sapCommerceDataSource' due to Name [jdbc/sapComme

rceDataSource] is not bound in this Context. Unable to find [jdbc]. occurred during executing query

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | (SELECT {p1:pk},{p2:pk} FROM {PriceRow AS p1 JOIN PriceRow AS p2 ON {p1:catalogVersion}=?srcVer AND {p2:catalogV

ersion}=?tgtVer AND {p1:unit}={p2:unit} AND {p1:currency}={p2:currency} AND {p1:ug}={p2:ug} AND {p1:user}={p2:user} AND {p1:net}={p2:net} AND {p1:product}={p2:product}

AND {p1:pg}={p2:pg} AND {p1:minqtd}={p2:minqtd} } WHERE ( {product} IS NULL) AND NOT EXISTS ({{SELECT {pk} FROM {ItemSyncTimestamp AS ts} WHERE {ts:syncJob}=0 AND {ts:

targetVersion}=?tgtVer AND {ts:sourceVersion}=?srcVer AND ({ts:sourceItem}={p1:pk} )}}) AND NOT EXISTS ({{ SELECT {pk} FROM {ItemSyncTimestamp AS ts} WHERE {ts:syncJob}

=0 AND {ts:targetVersion}=?tgtVer AND {ts:sourceVersion}=?srcVer AND ({ts:targetItem}={p2:pk} )}})ORDER BY {p1:creationtime} ASC, {p1:pk} ASC) with arguments (srcVer,tg

tVer),

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | values(lscoUSb2bContentCatalog/Staged(8796322595417),lscoUSb2bContentCatalog/Online(8796322628185))

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 |

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | de.hybris.platform.jalo.JaloSystemException: error looking up JNDI data source 'java:jdbc/sapCommerceDataSource'

due to Name [jdbc/sapCommerceDataSource] is not bound in this Context. Unable to find [jdbc].[HY--1]

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.catalog.jalo.synchronization.JDBCQuery.handleError(JDBCQuery.java:123)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.catalog.jalo.synchronization.JDBCQuery.execute(JDBCQuery.java:71)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.catalog.jalo.synchronization.SyncSchedulerCallableBase.callImpl(SyncSchedulerCalla

bleBase.java:117)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.catalog.jalo.synchronization.SyncSchedulerCallableBase.call(SyncSchedulerCallableB

ase.java:93)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.catalog.jalo.synchronization.SyncSchedulerCallableBase.call(SyncSchedulerCallableB

ase.java:1)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.core.TenantAwareThreadFactory$1.internalRun(TenantAwareThreadFactory.java:159)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:134)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | Caused by: java.sql.SQLException: error looking up JNDI data source 'java:jdbc/sapCommerceDataSource' due to Nam

e [jdbc/sapCommerceDataSource] is not bound in this Context. Unable to find [jdbc].

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.JDBCConnectionFactory.getConfiguredDataSource(JDBCConnectionFactory.ja

va:207)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.JDBCConnectionFactory.createRawSQLConnection(JDBCConnectionFactory.jav

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.JDBCConnectionFactory.createSQLConnection(JDBCConnectionFactory.java:2

15)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.JDBCConnectionFactory.makeObject(JDBCConnectionFactory.java:108)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:868)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:113)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.ConnectionErrorCheckingJDBCConnectionPool.borrowConnection(ConnectionE

rrorCheckingJDBCConnectionPool.java:102)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.DataSourceImpl.getFromPool(DataSourceImpl.java:486)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.DataSourceImpl.doGetConnection(DataSourceImpl.java:461)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.DataSourceImpl.getConnection(DataSourceImpl.java:452)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.DataSourceImpl.getConnection(DataSourceImpl.java:406)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.catalog.jalo.synchronization.JDBCQuery.execute(JDBCQuery.java:61)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | ... 8 more

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | Caused by: javax.naming.NameNotFoundException: Name [jdbc/sapCommerceDataSource] is not bound in this Context. U

nable to find [jdbc].

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at org.apache.naming.NamingContext.lookup(NamingContext.java:816)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at org.apache.naming.NamingContext.lookup(NamingContext.java:173)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at org.apache.naming.SelectorContext.lookup(SelectorContext.java:163)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at javax.naming.InitialContext.lookup(InitialContext.java:417)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | at de.hybris.platform.jdbcwrapper.JDBCConnectionFactory.getConfiguredDataSource(JDBCConnectionFactory.ja

va:202)

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 | ... 21 more

INFO | jvm 1 | main | 2020/10/12 12:25:22.160 |

[geffchang]

What 1808 patch are you using? Have you tried the latest patch?

[former_member704915]

We are on Hybris 1808.2 patch and we did not try upgrading to the latest patch

[geffchang]

abhijit.gupta4 There is already 1808.30. Test in local if the latest version fixes the issue.