Skip to Content

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.