SAP Knowledge Base Article - Preview

3057100 - Synchronization fails when mandatory attributes are undefined

Symptom

  1. After making a simple change like the name of one product and synchronizing that product alone, the sync fails.

  2. The synchronization logs show that the job ended in with errors and unfinished items:

    19.11.05 16:10:00:009	INFO	Starting synchronization ...
    19.11.05 16:10:00:011	DEBUG	Starting sync 00000337[8796224225781] (turn 1, previous dump -1, lines to skip 0, invocations 0)
    19.11.05 16:10:00:107	DEBUG	Stats<00000337 maxLine:1 (+1) dumped:1 (+1) cache:0% (hits:0, misses:1 total)>
    19.11.05 16:10:00:107	INFO	1. pass, 0 (+0) of 0 items processed (0 %),  0.00 items/sec, 1 (+1, deadlocks:0) items dumped.
    19.11.05 16:10:00:119	DEBUG	Finished sync 00000337 (turn 1, lines 0, previous dump -1, current dump 1)
    19.11.05 16:10:00:121	DEBUG	Starting sync 00000337[8796224225781] (turn 2, previous dump 1, lines to skip 0, invocations 1)
    19.11.05 16:10:00:149	DEBUG	Stats<00000337 maxLine:1 (+1) dumped:1 (+1) cache:0% (hits:0, misses:1 total)>
    19.11.05 16:10:00:150	INFO	2. pass, 0 (+0) of 1 items processed (0 %),  0.00 items/sec, 1 (+1, deadlocks:0) items dumped.
    19.11.05 16:10:00:158	DEBUG	Finished sync 00000337 (turn 2, lines 0, previous dump 1, current dump 1)
    19.11.05 16:10:00:158	INFO	comparing last dumps (1/8798263214110 vs 1/8798263312414) - this might take some time...
    19.11.05 16:10:00:158	INFO	done comparing last dumps - dumps are equal
    19.11.05 16:10:00:159	ERROR	sync ended with 1 unfinished items - see last sync media for details
    19.11.05 16:10:00:160	ERROR	Finished synchronization in 0d 00h:00m:00s:152ms. There were errors during the synchronization!
  3. The last sync media, which contains the unfinished items, prints out the PK of the source/target version of the product(s), the PK of the itemsynctimestamp and the list of attributes that couldn't be synchronized. In reality, there can be as little as one attribute contributing to the entire sync failure, so the values printed can be misleading. For example:

    8796093054977;8796156461057;8796111798891;allDocuments,europe1Discounts,europe1Prices,europe1Taxes,features,galleryImages,ownEurope1Discounts,ownEurope1Prices,ownEurope1Taxes,productReferences,untypedFeatures,variants,
    Europe1PriceFactory_PDG,Europe1PriceFactory_PPG,Europe1PriceFactory_PTG,articleStatus,buyerIDS,contentUnit,data_sheet,deliveryModes,detail,genders,keywords,linkComponents,logo,normal,others,picture,productOrderLimit,stockLevels,
    supercategories,thumbnail,thumbnails,unit,vendors,approvalStatus,code,deliveryTime,description,ean,endLineNumber,erpGroupBuyer,erpGroupSupplier,manufacturerAID,manufacturerName,manufacturerTypeDescription,maxOrderQuantity,
    minOrderQuantity,name,numberContentUnits,offlineDate,onlineDate,order,orderQuantityInterval,priceQuantity,remarks,segment,specialTreatmentClasses,startLineNumber,summary,supplierAlternativeAID,test,variantType,xmlcontent;;false
  4. When executing the below Groovy script, some undefined mandatory attributes are found in the Output tab:

    import de.hybris.platform.servicelayer.search.FlexibleSearchQuery
      
      
    final String type = "Product"
    def String query = "SELECT {pk} FROM {} WHERE "
      
      
    def String[] mandatoryAttributes = defaultTypeService.getMandatoryAttributes(type, false)
      
    mandatoryAttributes.eachWithIndex { mandatoryAttribute, i ->
      query += "{} IS NULL"
      if (i != mandatoryAttributes.size() - 1) {
        query += " OR "
      }
    }
      
    println("Mandatory Attributes: \n")
      
      
    defaultFlexibleSearchService.search(new FlexibleSearchQuery(query)).getResult().each {
      println "Found undefined Mandatory Attribute for with code "
    }


Read more...

Environment

All Commerce or Commerce Cloud versions.

Keywords

sync,synch,unfinished,null,error,debug,logs,syncdump , KBA , CEC-COM-CPS-CAS , Catalog & Sync , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.