Product Structure - Data Mapping error

Question

Hello,When we navigate in a product structure (TDC5961 for example), a data mapping error due to type mismatch occurs.The components don’t go back. What is strange is that all the lower TDC orders are indeed present but do not "retranscribe" as components. The error does not come from the product structure either, which is in "Constructible" status and the components are also associated with it. I looked on Community and they refer to support tickets. In addition, the error is random, sometimes it happens on TDCs taken over and other times on new TDCs created. Same on the levels, sometimes the upper level is devoid of components but at the lower level they are there. 🙁 We had compared the IFS 7.5 and Cloud tables and no change. Everything is taken over identically both with those in error and those without errors.The error messages are the following :{"@odata.context":"https://url_prod/main/ifsapplications/projection/v1/DopHeaderHandling.svc/$metadata#DopOrderSet(DopId=%273%27,DopOrderId=1)/ChildDopOrdersArray(luname,keyref,Objstate,Objgrants,DopId,DopOrderId,Contract,ParentDopOrderId,PartNo,Planner,CreatePegged,QtyPerAssembly,ComponentScrap,ShrinkageFac,LeadtimeOffset,OperationNo,IssueToLoc,DrawPosNo,NoteText,Netting,OrigDueDate,OrigQtyRequired,PartType,RevisedDueDate,RevisedQtyDue,RevisedStartDate,QtyComplete,DopStructureLevel,ConsumptionItem,RevisionNo,AlternativeNo,RoutingAlternativeNo,RoutingRevisionNo,ConfigurationId,ConditionCode,DopPeggedSoUpdateFlag,DopPeggedPoUpdateFlag,ProcedureStep,IssueType,IssuePlannedScrap,StdPlannedItem,IssueOverreportedQty,NetDopSourcedSupplyOrd,NetInvSourcedSupplyOrd,ProjectId,ActivitySeq,DopHeadPartNo,DopHeadDescription,DopHeadObjstate,DOPStructureLevelStr,HasConfiguration,AlarmExists,LogExists,ComponentAlarmExists,StructureChangedDb,RoutingChangedDb,RemainingtoSupply,OrderRequisition,SupplyProjectId,PartDescription,PlannedSupplyScrap,QtyPegged,QtyDelivered,NettInvDb,DopHeadNetDopSupplyOrd,DopHeadNetInvSupplyOrd,NettingOld,CreatePeggedOld,PlanEnabled,NetEnabled,NetBranchEnabled,ReleaseEnabled,ReleaseBranchEnabled,CloseEnabled,CloseBranchEnabled,OpenEnabled,CancelEnabled,StartEnabled,IsParentOpen,IsCancelAllowed,SerialReservationsExist,LogCount,AlarmCount,Company,AllowStructChangeDb,CheckCreateOrderDb,UpdateSupplyOrderQty,UpdateSupplyOrderDate,DopHeadPartDesc,StructureRoutingType,StructureAltStateDb,RoutingAltStateDb,SerialRule,CountReservation)","value":[{"@odata.etag":"W/\"Vy8iQUFBY3M3QUFNQUFFN1RnQUFYOjIwMjQxMDE4MDgzMzA4Ig==\"","luname":"DopOrder","keyref":"DOP_ID=3^DOP_ORDER_ID=2^","Objstate":"Unreleased","Objgrants":null,"DopId":"3","DopOrderId":2,"Contract":"JE","ParentDopOrderId":1,"PartNo":"S17885_M10_MT_GEN","Planner":"VALIDE","CreatePegged":"PeggedOrders","QtyPerAssembly":1,"ComponentScrap":0,"ShrinkageFac":0,"LeadtimeOffset":null,"OperationNo":null,"IssueToLoc":null,"DrawPosNo":null,"NoteText":null,"Netting":"Netting","OrigDueDate":"2025-04-04","OrigQtyRequired":1,"PartType":"Manufactured","RevisedDueDate":"2025-04-04","RevisedQtyDue":1,"RevisedStartDate":"2025-03-31","QtyComplete":0,"DopStructureLevel":1,"ConsumptionItem":"Consumed","RevisionNo":"1","AlternativeNo":"*","RoutingAlternativeNo":"*","RoutingRevisionNo":"1","ConfigurationId":"*","ConditionCode":null,"DopPeggedSoUpdateFlag":"Planned","DopPeggedPoUpdateFlag":"Planned","ProcedureStep":null,"IssueType":"ReserveAndBackflush","IssuePlannedScrap":true,"StdPlannedItem":true,"IssueOverreportedQty":false,"NetDopSourcedSupplyOrd":true,"NetInvSourcedSupplyOrd":false,"ProjectId":"G00341","ActivitySeq":100017825,"DopHeadPartNo":"S17885_M10_MACHINE","DopHeadDescription":"G 00341 S17885 changement vis épanouissement S17885","DopHeadObjstate":"Released","DOPStructureLevelStr":"**1","HasConfiguration":false,"AlarmExists":false,"LogExists":false,"ComponentAlarmExists":false,"StructureChangedDb":true,"RoutingChangedDb":true,"RemainingtoSupply":1,"OrderRequisition":"DOP","SupplyProjectId":"G00341","PartDescription":"Montage général","PlannedSupplyScrap":0,"QtyPegged":0,"QtyDelivered":0,"NettInvDb":true,"DopHeadNetDopSupplyOrd":true,"DopHeadNetInvSupplyOrd":false,"NettingOld":"Netting","CreatePeggedOld":"PeggedOrders","PlanEnabled":false,"NetEnabled":true,"NetBranchEnabled":true,"ReleaseEnabled":true,"ReleaseBranchEnabled":true,"CloseEnabled":false,"CloseBranchEnabled":false,"OpenEnabled":false,"CancelEnabled":true,"StartEnabled":false,"IsParentOpen":true,"IsCancelAllowed":false,"SerialReservationsExist":"FALSE","LogCount":0,"AlarmCount":0,"Company":"JE","AllowStructChangeDb":true,"CheckCreateOrderDb":true,"UpdateSupplyOrderQty":null,"UpdateSupplyOrderDate":null,"DopHeadPartDesc":"JEMSY 90 892 mm 4 R","StructureRoutingType":"Manufacturing","StructureAltStateDb":"Buildable","RoutingAltStateDb":"Buildable","SerialRule":"MANUAL","CountReservation":0,"ConfigurationIdRef":null,"PartNoRef":{"@odata.id":"https://url_prod/main/ifsapplications/projection/v1/DopHeaderHandling.svc/DopOrderSet(DopId='3',DopOrderId=1)/ChildDopOrdersArray(DopId='3',DopOrderId=2)/PartNoRef","luname":"InventoryPart","keyref":"CONTRACT=JE^PART_NO=S17885_M10_MT_GEN^","Contract":"JE","PartNo":"S17885_M10_MT_GEN","Description":"Montage général","TypeCode":"Manufactured","UnitMeas":"pcs","LeadTimeCode":"Manufactured"},"OperationNoRef":null,"IssueToLocRef":null,"ConditionCodeRef":null,"PartCatalogRef":{"@odata.id":"https://jurl_prod/main/ifsapplications/projection/v1/DopHeaderHandling.svc/DopOrderSet(DopId='3',DopOrderId=1)/ChildDopOrdersArray(DopId='3',DopOrderId=2)/PartCatalogRef","luname":"PartCatalog","keyref":"PART_NO=S17885_M10_MT_GEN^","Objgrants":null,"PartNo":"S17885_M10_MT_GEN","Configurable":"NotConfigured","ConditionCodeUsage":"NotAllowConditionCode","ReceiptIssueSerialTrack":false,"ConfigurableDb":false},"PlannerRef":{"@odata.id":"https://url_prod/main/ifsapplications/projection/v1/DopHeaderHandling.svc/DopOrderSet(DopId='3',DopOrderId=1)/ChildDopOrdersArray(DopId='3',DopOrderId=2)/PlannerRef","luname":"InventoryPartPlanner","keyref":"BUYER_CODE=VALIDE^","BuyerCode":"VALIDE","BuyerName":"Validé "}},{"@odata.etag":"W/\"Vy8iQUFBY3M3QUFNQUFFN1VCQUFiOjIwMjQxMDAyMTEzODQ4Ig==\"","luname":"DopOrder","keyref":"DOP_ID=3^DOP_ORDER_ID=485^","Objstate":"Unreleased","Objgrants":null,"DopId":"3","DopOrderId":485,"Contract":"JE","ParentDopOrderId":1,"PartNo":"S17885_M10_APPRO_CENT_LUB","Planner":"VALIDE","CreatePegged":"PeggedOrders","QtyPerAssembly":1,"ComponentScrap":0,"ShrinkageFac":0,"LeadtimeOffset":null,"OperationNo":null,"IssueToLoc":null,"DrawPosNo":null,"NoteText":null,"Netting":"Netting","OrigDueDate":"2025-04-04","OrigQtyRequired":1,"PartType":"PurchasedRaw","RevisedDueDate":"2025-04-04","RevisedQtyDue":1,"RevisedStartDate":"2025-04-04","QtyComplete":0,"DopStructureLevel":1,"ConsumptionItem":"Consumed","RevisionNo":null,"AlternativeNo":null,"RoutingAlternativeNo":null,"RoutingRevisionNo":null,"ConfigurationId":"*","ConditionCode":null,"DopPeggedSoUpdateFlag":"Planned","DopPeggedPoUpdateFlag":"Planned","ProcedureStep":null,"IssueType":"ReserveAndBackflush","IssuePlannedScrap":true,"StdPlannedItem":true,"IssueOverreportedQty":false,"NetDopSourcedSupplyOrd":true,"NetInvSourcedSupplyOrd":false,"ProjectId":"G00341","ActivitySeq":100017825,"DopHeadPartNo":"S17885_M10_MACHINE","DopHeadDescription":"G 00341 S17885 changement vis épanouissement S17885","DopHeadObjstate":"Released","DOPStructureLevelStr":"**1","HasConfiguration":false,"AlarmExists":false,"LogExists":false,"ComponentAlarmExists":false,"StructureChangedDb":false,"RoutingChangedDb":false,"RemainingtoSupply":1,"OrderRequisition":"DOP","SupplyProjectId":"G00341","PartDescription":"Appro centrale lubrification","PlannedSupplyScrap":0,"QtyPegged":0,"QtyDelivered":0,"NettInvDb":true,"DopHeadNetDopSupplyOrd":true,"DopHeadNetInvSupplyOrd":false,"NettingOld":"Netting","CreatePeggedOld":"PeggedOrders","PlanEnabled":false,"NetEnabled":true,"NetBranchEnabled":true,"ReleaseEnabled":true,"ReleaseBranchEnabled":true,"CloseEnabled":false,"CloseBranchEnabled":false,"OpenEnabled":false,"CancelEnabled":true,"StartEnabled":false,"IsParentOpen":true,"IsCancelAllowed":true,"SerialReservationsExist":"FALSE","LogCount":0,"AlarmCount":0,"Company":"JE","AllowStructChangeDb":true,"CheckCreateOrderDb":true,"UpdateSupplyOrderQty":null,"UpdateSupplyOrderDate":null,"DopHeadPartDesc":"JEMSY 90 892 mm 4 R","StructureRoutingType":"Purchase","StructureAltStateDb":null,"RoutingAltStateDb":null,"SerialRule":"MANUAL","CountReservation":0,"ConfigurationIdRef":null,"PartNoRef":{"@odata.id":"https://url_prod/main/ifsapplications/projection/v1/DopHeaderHandling.svc/DopOrderSet(DopId='3',DopOrderId=1)/ChildDopOrdersArray(DopId='3',DopOrderId=485)/PartNoRef","luname":"InventoryPart","keyref":{"error":{"code":"ODP_MAPPING_ERROR","message":"Erreur de mappage des données en raison d'une incompatibilité de type."}}Can you help me to resolve this problem please? Thanks a lot.Best regards

KennethP · Answer

We had an ODP_MAPPING_ERROR recently, which turned out to be due to values other than ‘TRUE’/’FALSE’ in a boolean field. Likewise, in your case, you probably have some data in a table that is inconsistent with the way it is defined in the projection. It can be a bit tricky to find though. ChildDopOrdersArray points to dop_order_tab so I would start to look there, on dop_id ‘3’ and dop_order_id ‘485’. Then compare it with other records and see if anything stands out as odd. Pay attention to booleans (true/false, y/n, yes/no etc) and enumerations. Then, look through the DopOrder entity in the DopHeaderHandling projection and look at the definitions of the fields to see if there is some discrepancy in your data.

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded