Question about Outbound XML size

[baji]

Hi

Do we have any limit for outbound XML file size limit in OTM.When am sending voucher/bill to external system the outbound XML getting generated always have size <1100 lines. Is there any limit in size for outbound XML?

Thanks
Baji

[chrisplough]

Re: Question about Outbound XML size

Baji,

I'm not aware of any way to arbitrarily limit the outbound XML size - say to a certain number of lines, but you can use XML Profiles to limit the fields and information which are included in the outbound XML - thereby greatly reducing the total XML size. This also allows you to include only the information which is important to you in the outbound XMLs.

--Chris

[ianlo]

Re: Question about Outbound XML size

Hi Baji,

I have also noticed that all my outbound shipment XMLs have a rough limit of 5 MB. Because I have alot of outbound shipments to be sent in 1 go, I noticed that for every Send Integration process, I sometimes have 2 or more Outbound Transmissions and they are of 4 to 5 MB in size.

This may cause problems to the some systems receiving multiple outbound transmissions (at such short time apart) - I have personally seen some issues with IIS 6.0.

So what we did to *limit* the outbound XML file sizes was to add a ROWNUM < xxx clause in our saved queries.

This effectively limits the number of records selected for an Send Integration process - and indirectly limiting the outbound XML file size.

Hope this helps!

Ian

[baji]

Re: Question about Outbound XML size

Hi Ian/Chris,

Here is the problem that am facing

In out XML profile -> GLOG_MIN (default=MIN) i have added following xpath values

1)PaymentSummary/FreightCharge
2)PaymentSummary/WeightVolume
3)PaymentSummary/*
4)PaymentModeDetail/GenericDetail/PickupDate

But outbound XML transmission does not have any of these tags in it.It does does show this tags at all.I have checked in Integration->Integration Manager->Perform Integartion command -> command=viewTransmissionXML ,its not showing any tags that i have added in GLOG_MIN profile.and always see that Outbound xml size is <1100 lines.

Any suggestion.............

Thanks
Baji

[ianlo]

Re: Question about Outbound XML size

Hi Ian/Chris,

Here is the problem that am facing

In out XML profile -> GLOG_MIN (default=MIN) i have added following xpath values

1)PaymentSummary/FreightCharge
2)PaymentSummary/WeightVolume
3)PaymentSummary/*
4)PaymentModeDetail/GenericDetail/PickupDate

But outbound XML transmission does not have any of these tags in it.It does does show this tags at all.I have checked in Integration->Integration Manager->Perform Integartion command -> command=viewTransmissionXML ,its not showing any tags that i have added in GLOG_MIN profile.and always see that Outbound xml size is <1100 lines.

Any suggestion.............

Thanks
Baji

Hi Baji,

I may not have the same setup as you have and I don't have much experience on this but what I did is as follows (at least it worked for me). In the customer out XML profile defined:
1) Default Mode = MAX
2) Validate For MAX is checked
3) Use Template unchecked
4) Create the list EXCLUDE XML builder IDs

So this is the opposite of what you are doing - set for MAX and then remove all that you don't need. I have not tried setting for MIN and then adding what you need.

Hope this helps!
Ian

[chrisplough]

Re: Question about Outbound XML size

To Ian's point, I can confirm that we've done it the same way. Added MAX and subtracted what wasn't necessary or relevant.

--Chris

[bmclamb]

Re: Question about Outbound XML size

Hi All -
Along this same note, we experienced an issue with the online booking and tendering screen in 5.5 CU4.
The Loaded distance was not being populated on the screen. Oracle instructed us to create a custom xml profile with the max setting and assign it to the carrier. We then had to withdraw the tender and retender to get the info to show up.

Even though the fix worked, I don't understand why an out of the box screen would not show all of the data until we created a custom xml profile. Just an observation.
Beth