2018 Jul 20 10:49 PM - edited 2024 Feb 04 6:27 AM
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
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
29 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.