Strange problem in Dynamic File Name . XI behaving strangely

[Former Member]

My o/p is coming like this

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_PurchaseOrderChange xmlns:ns0="http://E2open.com/xi/IntercompanySCM_6.0/POChange">

- <recordset>

- <data>

<PoHeaderDomainName>broker_domain</PoHeaderDomainName>

<PoHeaderOrgName>broker_org</PoHeaderOrgName>

<PoHeaderPoState>$null</PoHeaderPoState>

<PoHeaderStateChangeDate>$null</PoHeaderStateChangeDate>

<PoHeaderPoNumber>4500000026</PoHeaderPoNumber>

<PoHeaderPoCreationDate>$null</PoHeaderPoCreationDate>

<PoHeaderLastModifiedDate>$null</PoHeaderLastModifiedDate>

<PoHeaderModelSubType>Discrete_Order</PoHeaderModelSubType>

<PoHeaderSupplierName>0000352119</PoHeaderSupplierName>

<PoHeaderSupplierDescription>$null</PoHeaderSupplierDescription>

<PoHeaderCustomerName>SSP_CUSTOMER</PoHeaderCustomerName>

<PoHeaderCustomerDescription>$null</PoHeaderCustomerDescription>

<PoHeaderCustomerMessage>$null</PoHeaderCustomerMessage>

<PoHeaderSupplierMessage>$null</PoHeaderSupplierMessage>

<PoHeaderBillToName>$null</PoHeaderBillToName>

<PoHeaderBillToAddressDescriptor>$null</PoHeaderBillToAddressDescriptor>

<PoHeaderBillToAddressAddress1>$null</PoHeaderBillToAddressAddress1>

<PoHeaderBillToAddressAddress2>$null</PoHeaderBillToAddressAddress2>

<PoHeaderBillToAddressCity>$null</PoHeaderBillToAddressCity>

<PoHeaderBillToAddressCountry>$null</PoHeaderBillToAddressCountry>

<PoHeaderBillToAddressCounty>$null</PoHeaderBillToAddressCounty>

<PoHeaderBillToAddressState>$null</PoHeaderBillToAddressState>

<PoHeaderBillToAddressZip>$null</PoHeaderBillToAddressZip>

<PoHeaderBuyerCode>$null</PoHeaderBuyerCode>

<PoHeaderFreight>$null</PoHeaderFreight>

<PoHeaderTerms>0001</PoHeaderTerms>

<PoHeaderOrderPriority>$null</PoHeaderOrderPriority>

<PoHeaderCommunicationMode>$null</PoHeaderCommunicationMode>

<PoHeaderAgreementStartDate>$null</PoHeaderAgreementStartDate>

<PoHeaderAgreementEndDate>$null</PoHeaderAgreementEndDate>

<UDFPoHeaderRevisionNumber>$null</UDFPoHeaderRevisionNumber>

<UDFPoHeaderERPPOCreationDate>01Sep2006000000</UDFPoHeaderERPPOCreationDate>

<UDFPoHeaderheaderUDF1>$null</UDFPoHeaderheaderUDF1>

<UDFPoHeaderheaderUDF2>$null</UDFPoHeaderheaderUDF2>

<UDFPoHeaderheaderUDF3>$null</UDFPoHeaderheaderUDF3>

<UDFPoHeaderheaderUDF4>$null</UDFPoHeaderheaderUDF4>

<UDFPoHeaderheaderUDF5>$null</UDFPoHeaderheaderUDF5>

<PoLineItemPoLineItemId>00020</PoLineItemPoLineItemId>

<PoLineItemCustomerItemName>E107434516</PoLineItemCustomerItemName>

<PoLineItemCustomerItemDesc>L1357 TOROID INDUCTOR</PoLineItemCustomerItemDesc>

<PoLineItemCustomerDomainName>SSP_CUSTOMER_domain</PoLineItemCustomerDomainName>

<PoLineItemSupplierItemName>E107434516</PoLineItemSupplierItemName>

<PoLineItemSupplierItemDesc>L1357 TOROID INDUCTOR</PoLineItemSupplierItemDesc>

<PoLineItemSupplierDomainName>0000352119_domain</PoLineItemSupplierDomainName>

<PoLineItemUnitPrice>720</PoLineItemUnitPrice>

<PoLineItemBasisOfUnitPrice>$null</PoLineItemBasisOfUnitPrice>

<PoLineItemCurrency>EUR</PoLineItemCurrency>

<PoLineItemUnitOfMeasure>TNE</PoLineItemUnitOfMeasure>

<PoLineItemLineItemState>$null</PoLineItemLineItemState>

<PoLineItemStateChangeDate>$null</PoLineItemStateChangeDate>

<PoLineItemLastModifiedDate>$null</PoLineItemLastModifiedDate>

<UDFPoLineSupplierItemName>E107434516</UDFPoLineSupplierItemName>

<UDFPoLinelineUDF1>$null</UDFPoLinelineUDF1>

<UDFPoLinelineUDF2>$null</UDFPoLinelineUDF2>

<UDFPoLinelineUDF3>$null</UDFPoLinelineUDF3>

<UDFPoLinelineUDF4>$null</UDFPoLinelineUDF4>

<UDFPoLinelineUDF5>$null</UDFPoLinelineUDF5>

<PoScheduleId>1</PoScheduleId>

<PoScheduleLastAction>Insert_Or_Modify</PoScheduleLastAction>

<PoScheduleScheduleState>$null</PoScheduleScheduleState>

<PoScheduleStateChangeDate>$null</PoScheduleStateChangeDate>

<PoScheduleRequestQuantity>9.000</PoScheduleRequestQuantity>

<PoScheduleRequestDate>16Sep2006000000</PoScheduleRequestDate>

<PoScheduleRequestShipmentDate>16Sep2006000000</PoScheduleRequestShipmentDate>

<PoScheduleOriginalRequestQuantity>$null</PoScheduleOriginalRequestQuantity>

<PoScheduleOriginalRequestDate>$null</PoScheduleOriginalRequestDate>

<PoScheduleCarrier>$null</PoScheduleCarrier>

<PoScheduleCarrierMode>$null</PoScheduleCarrierMode>

<PoScheduleCarrierAccountNumber>$null</PoScheduleCarrierAccountNumber>

<PoScheduleCustomerSiteName>5302</PoScheduleCustomerSiteName>

<PoScheduleShipToAddressDescriptor>$null</PoScheduleShipToAddressDescriptor>

<PoScheduleShipToAddressAddress1>$null</PoScheduleShipToAddressAddress1>

<PoScheduleShipToAddressAddress2>$null</PoScheduleShipToAddressAddress2>

<PoScheduleShipToAddressCity>$null</PoScheduleShipToAddressCity>

<PoScheduleShipToAddressCountry>$null</PoScheduleShipToAddressCountry>

<PoScheduleShipToAddressCounty>$null</PoScheduleShipToAddressCounty>

<PoScheduleShipToAddressState>$null</PoScheduleShipToAddressState>

<PoScheduleShipToAddressZip>$null</PoScheduleShipToAddressZip>

<PoScheduleLastModifiedDate>$null</PoScheduleLastModifiedDate>

<PoScheduleCustomerMessage>$null</PoScheduleCustomerMessage>

<PoScheduleSupplierMessage>$null</PoScheduleSupplierMessage>

<PoScheduleRefdPoCustomerName>$null</PoScheduleRefdPoCustomerName>

<PoScheduleRefdPoS>$null</PoScheduleRefdPoS>

<PoScheduleRefdPoModelSubType>$null</PoScheduleRefdPoModelSubType>

<PoScheduleRefdPoNumber>$null</PoScheduleRefdPoNumber>

<PoScheduleRefdPoLineItemId>$null</PoScheduleRefdPoLineItemId>

<PoScheduleRefdPoScheduleId>$null</PoScheduleRefdPoScheduleId>

<UDFPoSchedulescheduleUDF1>$null</UDFPoSchedulescheduleUDF1>

<UDFPoSchedulescheduleUDF2>$null</UDFPoSchedulescheduleUDF2>

<UDFPoSchedulescheduleUDF3>$null</UDFPoSchedulescheduleUDF3>

<UDFPoSchedulescheduleUDF4>$null</UDFPoSchedulescheduleUDF4>

<UDFPoSchedulescheduleUDF5>$null</UDFPoSchedulescheduleUDF5>

<PoPromiseScheduleId>1</PoPromiseScheduleId>

<PoPromiseScheduleAddressDescriptor>$null</PoPromiseScheduleAddressDescriptor>

<PoPromiseScheduleAddress1>$null</PoPromiseScheduleAddress1>

<PoPromiseScheduleAddress2>$null</PoPromiseScheduleAddress2>

<PoPromiseScheduleAddressCity>$null</PoPromiseScheduleAddressCity>

<PoPromiseScheduleAddressCountry>$null</PoPromiseScheduleAddressCountry>

<PoPromiseScheduleAddressCounty>$null</PoPromiseScheduleAddressCounty>

<PoPromiseScheduleAddressState>$null</PoPromiseScheduleAddressState>

<PoPromiseScheduleAddressZip>$null</PoPromiseScheduleAddressZip>

<PoPromiseScheduleQuantity>9.000</PoPromiseScheduleQuantity>

<PoPromiseScheduleDate>16Sep2006000000</PoPromiseScheduleDate>

<PoPromiseScheduleShipmentDate>$null</PoPromiseScheduleShipmentDate>

<UDFPoPromiseScheduleUDF1>$null</UDFPoPromiseScheduleUDF1>

<UDFPoPromiseScheduleUDF2>$null</UDFPoPromiseScheduleUDF2>

<UDFPoPromiseScheduleUDF3>$null</UDFPoPromiseScheduleUDF3>

<UDFPoPromiseScheduleUDF4>$null</UDFPoPromiseScheduleUDF4>

<UDFPoPromiseScheduleUDF5>$null</UDFPoPromiseScheduleUDF5>

</data>

- <FileNameNode>

<FileName>111111111_222222223_purchase-orders_20060901065147_</FileName>

</FileNameNode>

</recordset>

</ns0:MT_PurchaseOrderChange>

I have specifed

Payload:MT_PurchaseOrderChange,1,FileNameNode,1,FileName,1

in variable substitution

I am on SP 14 and it the dynamic file is working for other scneario

bt in this scneario i am getting the error

Receiver Adapter v2405 for Party '', Service 'com_E2open_qas':

Configured at 2006-09-01 18:42:32 GMT+05:30

History:

- 2006-09-01 19:11:48 GMT+05:30: Message processing failed: Error during variable substitution: com.sap.aii.adapter.file.varsubst.VariableDataSourceException: The following variable was not found in the message payload: amit

- 2006-09-01 19:11:48 GMT+05:30: Processing started

- 2006-09-01 19:06:47 GMT+05:30: Message processing failed: Error during variable substitution: com.sap.aii.adapter.file.varsubst.VariableDataSourceException: The following variable was not found in the message payload: amit

- 2006-09-01 19:06:47 GMT+05:30: Processing started

- 2006-09-01 19:01:47 GMT+05:30: Message processing failed: Error during variable substitution: com.sap.aii.adapter.file.varsubst.VariableDataSourceException: The following variable was not found in the message payload: amit

amit is the variable i have given for substitution.

[MichalKrawczyk · Accepted solution]

Hi,

if you have SP14 stop using variable substitiuion:)

you can do it much easier with dynamic configuraiton

/people/william.li/blog/2006/04/18/dynamic-configuration-of-some-communication-channel-parameters-using-message-mapping

so you can easily set it for file adapter to set the file name

you can also have a look at my weblog:

/people/michal.krawczyk2/blog/2005/11/10/xi-the-same-filename-from-a-sender-to-a-receiver-file-adapter--sp14

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

Hi,

Based on the XML you supplied, the structure is:

MT_PurchaseOrderChange

recordset

FileNameNode

FileName

You left out the "recordset" in your configuration of the substitution.

Regards,

Bill

[Former Member · Accepted solution]

Hi Bill ,

Thanks for the hint. It Worked with recordset thing

but the same settings i have done for another scneario.

I have the same structure but i didnt use recordset in my file conversion .

Still it worked fine .

Any comments why doees XI behave in this manner