Order CSV created without user info and ERROR Failed to create a target item from CanonicalItem
While creating Order C64 IDOC in datahub the order csv is missing user information. In our system we are processing 10 orders in a batch and sending from hybris to datahub but only 1 order is failing(not the first one, anyone in that batch. Sometime more than 1). The csv creation in hybris is failing to create complete csv for one of these order when we call OOTB method to create raw item for the order. Please see the error details we are receiving in datahub:
2020-07-14 04:30:44.175 293290336 [DataHubActorSystem-akka.actor.default-dispatcher-15] ERROR c.h.d.s.p.i.DefaultCanonicalToTargetItemConverterService - Failed to create a target item from CanonicalItem{id='1620525', integrationKey='1005607701\|7/13/20 NC Main', status=SUCCESS, dataPool=DataHubPoolEntity{id=9306, name=SAPORDER_OUTBOUND_POOL}, batchId=230852||, traceId=90772409-fdd8-3c06-b9a2-c8304b14c216, uuid=486dd7bb-b345-420f-a712-b7ea3a72c706, fields={gskPromptPayTermsCode=null, orderId=1005607701|7/13/20 NC Main, gskSapFriendlyToken=*******, paymentMode=null, gskRequestedDeliveryDate=null, receiverName=null, gskOrderId=null, channel=null, gskOrderType=null, creationDate=null, gskPaymentType=null, gskContractNo=null, gskCardType=*******, deliveryMode=012, gskDeliveryInstruction=null, purchaseOrderNumber=null, gskCardExpirationDate=*******, baseStoreUid=null, currencyIsoCode=null, gskCardTypeDesc=*******, gskLanguageIsoCode=null}}
com.hybris.datahub.service.spel.TransformationExpressionException: Could not transform by expression deliveryMode=='008'?resolve('SAPBaseStoreConfigurationMapping','SAPCONFIGURATION_POOL').resolve('SAPBaseStoreConfiguration','SAPCONFIGURATION_POOL').salesOrganization:(deliveryMode=='007'?resolve('SAPBaseStoreConfigurationMapping','SAPCONFIGURATION_POOL').resolve('SAPBaseStoreConfiguration','SAPCONFIGURATION_POOL').distributionChannel:(deliveryMode=='006'?resolve('SAPBaseStoreConfigurationMapping','SAPCONFIGURATION_POOL').resolve('SAPBaseStoreConfiguration','SAPCONFIGURATION_POOL').division:(deliveryMode=='019'?resolve('CanonicalOrder').gskOrderType:(deliveryMode=='012'?resolve('SAPBaseStoreConfigurationMapping','SAPCONFIGURATION_POOL').resolve('SAPBaseStoreConfiguration','SAPCONFIGURATION_POOL').transactionType:''))))
at com.hybris.datahub.service.spel.impl.CompilableSpelExpressionProcessor.transform(CompilableSpelExpressionProcessor.java:89) ~[datahub-service-18.11.19-RC1.jar:18.11.19-RC1]
CSV created for this order without user info:
2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 1 Data :3, 1.0, 1005607701|7/13/20 NC Main, true, 0, USD, 489.41, EA, 496.91, ZPR0 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 2 Data :1, , 1005607701|7/13/20 NC Main, true, -1, USD, 0.0, , , ZHC0 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 3 Data :2, , 1005607701|7/13/20 NC Main, true, -1, USD, 0.0, , , 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 4 Data :, , 1005607701|7/13/20 NC Main, , , , , , , 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 5 Data :, , 1005607701|7/13/20 NC Main, , , , , , , 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 6 Data :, , 1005607701|7/13/20 NC Main, , , , , , , 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 7 Data :, , 1005607701|7/13/20 NC Main, , , , , , , 2020-07-14 04:30:24.044 293270205 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 8 Data :, , 1005607701|7/13/20 NC Main, , , , , , , 2020-07-14 04:30:24.045 293270206 [ajp-bio-8009-exec-5384] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 9 Data :, , 1005607701|7/13/20 NC Main, , , , , , ,
Example of a successful order CSV(which contain all user information):
2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 1 Data :3, , , 1005572544|1005572544, , , , , , , , , , , , , , , 1.0, , 0, , , , , , , USD, 419.21, , , , , , , , , EA, , , , , , 449.21, , , , , , , , , , , , ZPR0, , , , , true, , , , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 2 Data :1, , , 1005572544|1005572544, , , , , , , , , , , , , , , , , -1, , , , , , , USD, 0.0, , , , , , , , , , , , , , , , , , , , , , , , , , , ZHC0, , , , , true, , , , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 3 Data :2, , , 1005572544|1005572544, , , , , , , , , , , , , , , , , -1, , , , , , , USD, 0.0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , true, , , , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 4 Data :, 2020-07-02 18:33:47.565, gsk, 1005572544|1005572544, 2020-07-07 00:00:00.0, , B2B, , , , , free-standard-shipping, , , , , USD, , , , , 1005572544, , , , , , , , , , , YD61, , , , , , , SALESORDER_CREATE, , HYBRIS, , , , , en, , , , , , , ZGS1, , , 52138101, , , , , 1005572544, , , 1005572544, 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 5 Data :, , , 1005572544|1005572544, , , , , KINRIX 1 DS/0.5ML PFS NONDLSYR 10'S LM, , , , , , , , , , , , , , , , EA, , , , , , , , , , , , , , , , , , , , , , , , 1, , , , , , , , , , 58160081252, , , , 0, , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 6 Data :, , , 1005572544|1005572544, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 1100605373, , , , , , , , , , , , , , , , , , , , , AG, , , , , , , , , , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 7 Data :, , , 1005572544|1005572544, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 1100605373, , , , , , , , , , , , , , , , , , , , , RE, , , , , , , , , , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 8 Data :, , , 1005572544|1005572544, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 1100605373, , , , , , , , , , , , , , , , , , , , , RG, , , , , , , , , , , 2020-07-13 15:42:20.178 247186339 [ajp-bio-8009-exec-4159] INFO c.g.d.c.s.i.GskDefaultCsvReaderService - CSV Line - 9 Data :, , , 1005572544|1005572544, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 1100605373, , , , , , , , , , , , , , , , , , , , , WE, , , , , , , , , , ,
Please provide a solution if you faced this kind of issue in your project.