otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion.

Tags:

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 24th, 2008, 05:41
Junior Member
 
Join Date: Dec 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
baji is on a distinguished road
Question about Outbound XML size

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old January 24th, 2008, 09:40
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 821
Blog Entries: 7
Thanks: 53
Thanked 201 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to 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
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old January 24th, 2008, 09:56
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 149
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 1 Time in 1 Post
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old January 24th, 2008, 10:18
Junior Member
 
Join Date: Dec 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
baji is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old January 25th, 2008, 01:24
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 149
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 1 Time in 1 Post
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Re: Question about Outbound XML size

Quote:
Originally Posted by baji View Post
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old January 25th, 2008, 15:26
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 821
Blog Entries: 7
Thanks: 53
Thanked 201 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to 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
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old February 5th, 2008, 17:25
OTMSIG Board Member
 
Join Date: Oct 2006
Posts: 9
Thanks: 0
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
bmclamb is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Throwing OutOfMemory: allocLargeArray - Object size: 5766688, Num elements: 2883334 Kristof Stevens Hardware and Platforms 9 August 14th, 2008 10:50
Problem with External System Translations for OUTBOUND/INBOUND Stefano Integration and Data Mapping 4 June 2nd, 2008 14:03
Question about voucher baji Integration and Data Mapping 2 January 22nd, 2008 15:37
Outbound Queue in OTM rkuruba Integration and Data Mapping 0 September 18th, 2007 22:01
[SOLVED] Re: newbie question Alan Cuartero Email List Archive 1 December 12th, 2006 02:46



All times are GMT. The time now is 21:16.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37