cancel
Showing results for 
Search instead for 
Did you mean: 

TargetItem and PubicationError Cleanup issue

0 Kudos
145

Hi,

We are processing 50 K materials from ECC to Hybris. After around 40 K material processed, it stopped pushing a single material to Hybris.

I am suspecting deletion of old Items from DataHub Database not happening , So it got stuck and not processing any further material.

i checked the log and found the cleanup for TargetItem is not working.

While cleaning TargetItem, it is deleting 0 items.

So every-time the same message in log i am seeing as :

TargetItem cleanup: [DELETE FROM "TargetItem" WHERE "targetsystempublication" IN (:ids)]: 0 records were deleted [DELETE FROM "PublicationError" WHERE "canonicalitempublicationstatus" IN (:ids)]: 0 records were deleted [DELETE FROM "PublicationError" WHERE "canonicalitempublicationstatus" IN (:secondaryids)]: 0 records were deleted

So it is not deleting any TargetItem and PubicationError data/records from DataHub DB.

NOTE : When we are processing Customer IDOC, it is working fine. But the issue is coming for Material.

Could you please check if what i am suspecting is correct becuase of not deletinog any OLD Items from TargetItem and PublicationError Tables it is not processing any new Material.

Also please provide me the detail why TargetItem and PubicationError not getting deleted and Also please suggest some solution for this.

Thanks

Former Member
0 Kudos

could you please share your local.properties.

Slava
Product and Topic Expert
Product and Topic Expert
0 Kudos

I doubt cleanup will delete any items for the publication in progress, so what did happen with the publication? why is it stuck? Not cleaning items should not affect publication but will slow it down eventually. Check for exceptions/errors in the log and post here what you found. Also, can you specify what exact error do you get when trying to push more data to DataHub

View Entire Topic
rahulverma94
Active Participant
0 Kudos

Please set up the following properties in datahub local properties file: datahub.cleanup.rawitem.enabled=true datahub.cleanup.canonicalitem.enabled=true datahub.cleanup.targetitem.enabled=true

Let me know if these helped!!