Skip to Content
-1
Nov 27, 2020 at 11:51 PM

[Bug]JNDI data source 'java:jdbc/sapCommerceDataSource' is not bound in this Context.

29 Views Last edit Nov 30, 2020 at 08:58 AM 2 rev

We are the facing catalog sync issue on Carrolton preprod environments.While executing few of the syncjobs JDBC connection is not getting established between the database and preprod nodes.Earlier the issue was happening on the store nodes only and working fine on cron nodes but since last week we have seen the same issue happening on cron nodes of preprod as well.

SEVERE: Exception error looking up JNDI data source 'java:jdbc/sapCommerceDataSource' due to Name [jdbc/sapCommerceDataSource] is not bound in this Context. Unable to find [jdbc]. occurred during executing query

SELECT {p1:pk},{p2:pk} FROM {Media AS p1 JOIN Media AS p2 ON {p1:catalogVersion}=?srcVer AND {p2:catalogVersion}=?tgtVer AND {p1:code}={p2:code} } WHERE 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,tgtVer)