CatalogVersionSyncCronJob is not syncing modified products since last sync

[Former Member]

We have a daily CronJob (CatalogVersionSyncCronJob) that executes a synchronization of the Product Catalog from Staged to Online around at 3AM. The job is an instance of CatalogVersionSyncJob.

It's configured to do a full syncronization of all catalog (mainly products and categories), but not a force update.

Since like a week ago, the CronJob doesn't update anything modified on Staged, the logs shows like there is not modified items at all.

19.09.12 11:34:12:987	INFO	Starting synchronization ...
19.09.12 11:34:13:041	INFO	1. pass, 0 (+0) of 0 items processed (0 %),  0.00 items/sec, 0 (+0, deadlocks:0) items dumped.
19.09.12 11:34:13:092	INFO	Finished synchronization in 0d 00h:00m:00s:105ms. No errors.

That's the log from the last execution of the CronJob (executed manually through backoffice). There is an item that should be synced cause was modified his Staged version way before that execution and the Online version still has not the changes (one on the localized name and one on the supercategories of the product, and yes, the language is associated to the catalog to be synced).

If I create a new CronJob with the same configuration and the same job, it syncs all the catalog flawlessly

BUT

If I run the same CronJob again (after modifying a product on Staged), it doesn't find it and shows the same log stating that ther is no items processed.

I ran the following FlexibleSearch query and returned two items modified after the last time they were sync

 select {c.id},{cv.version},{p.code},{ist.lastsynctime},{p.modifiedtime}
 from {product as p
 join catalogversion as cv on {p.catalogversion}={cv.pk}
 join catalog as c on {cv.catalog}={c.pk}
 join itemsynctimestamp as ist on {ist.sourceitem}={p.pk}}
 where {p.modifiedtime}>{ist.lastsynctime}

p_id | p_version | p_code | p_lastsync | timemodifiedTS
productCatalog | Staged | 000351010 | 2019-09-11 15:26:29.0 | 2019-09-12 12:54:05.0
productCatalog | Staged | 812461520 | 2019-09-09 17:56:25.0 | 2019-09-11 11:59:18.0

That's the behavior at PRD and QA servers, but when I replicate the configuration on my local machine for dev, it doesn't matter how many times I start the CronJob that it syncs all changes flawlessly.

All machines run SAP Commerce 6.6.0.0

Any suggestion that what can be the solution or any thecks that could help me to resolve the problem?

Thanks.

[former_member1254669]

I am having the exact same Issue, any updates on this one?