11-27-2020 11:51 PM
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)