sync issue on CategoryCategoryRelation, when we create the relationship via impex

[Former Member]

We are crating product category to classification category relationship via sync, but not sure why this relation is not getting sync after running the synchronization job.

impex used:

INSERT_UPDATE CategoryCategoryRelation;target(code, $catalogVersion)[unique=true];source(code, $classCatalogVersion)[unique=true]

;someProductcategory2;someClasificationcategory1;

;someProductcategory2;someClasificationcategory21;

Not sure what we are missing, as we don't see any log errors. Moreover when we check the sync attributes both supercategories and categories attribute are marked as sync attributes.

thanks for help in advance !!

[Former Member]

Hi Ankit, I can understand it becomes really difficult when you can't see logs.

Can you run a simple query to check if there are duplicates ? Just a shot in then dark.

[Former Member]

Hi,

Category is set as Roottype in syncprocess?

Updating CategoryCategoryRelation doesn't change the modified date of a Category.

Root types will sync if:

The source item modification time stamp is newer than last synchronizing time.

Documentation https://help.hybris.com/6.6.0/hcd/8c6a8d0786691014b52df14168b84ee7.html

Possible solution: When updating CategoryCategoryRelation also update the corresponding categories via

 UPDATE Category; code[unique = true]; modifiedtime[dateformat = dd.MM.yyyy hh:mm:ss];  $productCV; 

Br, Dieter