How to find and fix Sequence Number Corruption in the Category and Child Product Relationship tables in versioned schema - BCC
Issue : how to find and fix sequence number corruption between categories and their child products in the versioned schema. Sequence number corruption may be identified in the following ways: When you try to add a new child product and saving does not preserve the new child product. Try changing a category's child products and saving results all child products to vanish. Reverting changes to a category's child products causes inconsistencies in the child product list Merge, revert, or deploy operations fail with errors referring to DCS_CAT_CHLDPRD in BCC Sample Error: ERROR [ProductCatalog-ver] Error reading list or array index from the database. Expected: "112", got "113". The following property was not read: " {fixedChildProducts,pType=List,IDesc=[ItemDesc: category],table=dcs_cat_chldprd,cols=child_prd_id Type=interface atg.repository.RepositoryItem,cBI=[ItemDesc: product],cIDesc=[ItemDesc: product],colHandle=null}", for ite...