Skip to Content
0
Former Member
Jul 08, 2019 at 02:09 PM

Unable to sync product catalog facing below Sql error

63 Views

Hi Experts,

While doing product sync in my local machine my facing below expection:

Unknown column 'SYSTIMESTAMP' in 'where clause' query = 'SELECT count(*) FROM (SELECT item_t0.p_catalogversion FROM products item_t0 WHERE ( item_t0.p_catalogversion =?) AND (item_t0.TypePkString IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND ((( INFO | jvm 1 | main | 2019/07/08 11:47:50.786 | ( item_t0.p_approvalstatus IN (SELECT item_t1.PK FROM enumerationvalues item_t1 WHERE ( item_t1.Code = 'approved') AND (item_t1.TypePkString=? ))) AND INFO | jvm 1 | main | 2019/07/08 11:47:50.786 | ( item_t0.p_onlinedate IS NULL OR item_t0.p_onlinedate <= SYSTIMESTAMP ) AND INFO | jvm 1 | main | 2019/07/08 11:47:50.786 | item_t0.p_catalogversion IN INFO | jvm 1 | main | 2019/07/08 11:47:50.786 | (SELECT item_t2.PK FROM catalogversions item_t2 WHERE ( item_t2.p_version = 'Staged' and item_t2.p_catalog IN (SELECT item_t3.PK FROM catalogs item_t3 WHERE ( item_t3.p_id = 'b2ctel

Please provide a solution to resolve this issue.