Problem with file content conversion

[Former Member]

Hi gurus,

I'm getting the error:

"Consistency error: more fields found in XML structure than specified in conversion parameters!" in message monitoring in an xml to file scenario in which I send file to an external server.

I think problem is in DT/M1/MA segments, because when these segments are not present in message there is no error.

Segment MA is a subelemnt of M1, which is a subelement of DT, is that a problem?

This is my structure:

<RootNode_IS>

<Key>IS</Key>

<DealerCode/>

</RootNode_IS>

<RootNode_MS>

<Key>MS</Key>

<MessageText/>

</RootNode_MS>

<RootNode_DT>

<Key>DT</Key>

<ShippingNumber/>

<OutboundDeliveryNumber/>

<GoodsIssueDate/>

<AWBNumber/>

<RootNode_M1>

<Key>M1</Key>

<ShippingNumber/>

<ItemCode/>

<ShippedQuantity/>

<NetAmountOfLine/>

<Currency/>

<SalesOrderNumber/>

<SalesOrderInDMH/>

<YearOrderArco/>

<NumberOrderArco/>

<LineOrderArco/>

<GoodsDestination/>

<CurrencyCode/>

<RootNode_MA>

<Key>MA</Key>

<Division/>

<ItemCode/>

<Description/>

<WeightInKg/>

<UnitsForConfection/>

</RootNode_MA>

</RootNode_M1>

</RootNode_DT>

<RootNode_BB>

<Key>BB</Key>

<YearOrderArco/>

<NumberOrderArco/>

<LineOrderArco/>

<ShippingNumber/>

<DateOfTransportDocument/>

<ItemCode/>

<DealerCode/>

<QuantityInShipment/>

<ItemDescription/>

</RootNode_BB>

<RootNode_ZS>

<Key>ZS</Key>

<RecordsCountingInTransmission/>

</RootNode_ZS>

In ContentConversion I have this recordset Structure:

RootNode_IS,RootNode_MS,RootNode_DT,RootNode_M1,RootNode_MA,RootNode_BB,RootNode_ZS

and this parameters:

RootNode_IS.fieldNames Key,DealerCode

RootNode_IS.fieldFixedLengths 2,10

RootNode_IS.endSeparator 'nl'

RootNode_MS.fieldNames Key,MessageText

RootNode_MS.fieldFixedLengths 2,80

RootNode_MS.endSeparator 'nl'

RootNode_DT.fieldNames Key,ShippingNumber,OutboundDeliveryNumber,GoodsIssueDate,AWBNumber

RootNode_DT.fieldFixedLengths 2,10,10,8,35

RootNode_DT.endSeparator 'nl'

RootNode_M1.fieldNames Key,ShippingNumber,ItemCode,ShippedQuantity,NetAmountOfLine,Currency,SalesOrderNumber,SalesOrderInDMH,YearOrderArco,NumberOrderArco,LineOrderArco,GoodsDestination,CurrencyCode

RootNode_M1.fieldFixedLengths 2,8,15,9,13,2,8,3,4,6,3,3,3

RootNode_M1.endSeparator 'nl'

RootNode_MA.fieldNames Key,Division,ItemCode,Description,WeightInKg,UnitsForConfection

RootNode_MA.fieldFixedLengths 2,1,15,30,6,4

RootNode_MA.endSeparator 'nl'

RootNode_BB.fieldNames Key,YearOrderArco,NumberOrderArco,LineOrderArco,ShippingNumber,DateOfTransportDocument,ItemCode,DealerCode,QuantityInShipment,ItemDescription

RootNode_BB.fieldFixedLengths 2,4,6,3,8,8,15,6,9,30

RootNode_BB.endSeparator 'nl'

RootNode_ZS.fieldNames Key,RecordsCountingInTrasmission

RootNode_ZS.fieldFixedLengths 2,9

RootNode_ZS.endSeparator 'nl'

Thanks,

Fabio Boni

Edited by: Fabio Boni on Dec 9, 2010 12:42 PM

[former_member200962 · Accepted solution]

<RootNode_DT>
<Key>DT</Key>
<ShippingNumber/>
<OutboundDeliveryNumber/>
<GoodsIssueDate/>
<AWBNumber/>
<RootNode_M1>
<Key>M1</Key>
<ShippingNumber/>
<ItemCode/>
<ShippedQuantity/>
<NetAmountOfLine/>
<Currency/>
<SalesOrderNumber/>
<SalesOrderInDMH/>
<YearOrderArco/>
<NumberOrderArco/>
<LineOrderArco/>
<GoodsDestination/>
<CurrencyCode/>
<RootNode_MA>
<Key>MA</Key>
<Division/>
<ItemCode/>
<Description/>
<WeightInKg/>
<UnitsForConfection/>
</RootNode_MA>
</RootNode_M1>
</RootNode_DT>

RootNode_DT.fieldNames Key,ShippingNumber,OutboundDeliveryNumber,GoodsIssueDate,AWBNumber

Could not go through entire stuff....the parameters for RootNode_DT seem to be wrong...there seem to be more elements in RootNode_DT than thos mentioned in FCC.

Recheck the config.

Regards,

Abhishek.

[Former Member · Accepted solution]

Hi, In my scenario RootNode_M1 is a subsegment of segment RootNodeDT.

Also RootNode_MA is a subsegment of RootNode_M1.

Like this:

RootNode_IS

RootNode_DT

field1

field2

. ...

-

---

RootNode_M1

-

---

field1

-

---

field2

-

---

RootNode_MA

-

---

field1

-

---

field2

RootNode_BB

RootNode_ZS

I don't know, maybe I have wrongly defined this situation in mapping or in contenct conversion?

[former_member200962 · Accepted solution]

RootNode_DT.fieldNames Key,ShippingNumber,OutboundDeliveryNumber,GoodsIssueDate,AWBNumber

Your FCC does not have mention of RootNode_M1 node and hence the error...it needs to be mentioned since it is a child node for RootNode_DT

Regards,

Abhishek.

[Former Member · Accepted solution]

Hi,

What is the way to correctly menction child elements in FCC?

Edited by: Fabio Boni on Dec 9, 2010 1:25 PM

[former_member200962 · Accepted solution]

RootNode_DT.fieldNames Key,ShippingNumber,OutboundDeliveryNumber,GoodsIssueDate,AWBNumber,RootNode_M1

I would suggest that you go through this blog (many other also available): /people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

just glanced through your FCC and think that even

In ContentConversion I have this recordset Structure:

RootNode_IS,RootNode_MS,RootNode_DT,RootNode_M1,RootNode_MA,RootNode_BB,RootNode_ZS

needs to be re-looked

Regards,

Abhishek.

[Former Member]

Hi Boni,

Check the data type and the FCC parameters as well as the file which has all the values.

Either file has less values as compated to ur data type and FCC conf value.

chirag

[Former Member]

Hi Fabio,

I see that the key field value for all the nodes are 2. The key field value should be different, Change them and run the scenario. It will work.

The conversion parameters you are used are OK to convert.

Thanks,

[Former Member]

sorry problem still remains

thanks

fabio