otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
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.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 24th, 2008, 04:41
Junior Member
 
Join Date: Dec 2007
Posts: 16
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 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, 08:40
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 1,167
Blog Entries: 8
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 143
Thanked 258 Times in 161 Posts
Rep Power: 10
chrisplough is a jewel in the roughchrisplough is a jewel in the roughchrisplough is a jewel in the rough
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, 08:56
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 179
Blog Entries: 5
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 6
Thanked 13 Times in 12 Posts
Rep Power: 4
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, 09:18
Junior Member
 
Join Date: Dec 2007
Posts: 16
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 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, 00:24
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 179
Blog Entries: 5
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 6
Thanked 13 Times in 12 Posts
Rep Power: 4
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, 14:26
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 1,167
Blog Entries: 8
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 143
Thanked 258 Times in 161 Posts
Rep Power: 10
chrisplough is a jewel in the roughchrisplough is a jewel in the roughchrisplough is a jewel in the rough
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, 16:25
OTMSIG Board Member
 
Join Date: Oct 2006
Posts: 9
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 2 Times in 2 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

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
OTM Outbound Integration anirban1982 Integration and Data Mapping 2 May 21st, 2009 08:35
Size of OTM screens too heavy Jasont Performance, Scalability and HA 6 May 19th, 2009 18:29
DB Security Question Joe Patton Database Administration 4 September 29th, 2008 20:42
Throwing OutOfMemory: allocLargeArray - Object size: 5766688, Num elements: 2883334 Kristof Stevens Hardware and Platforms 9 August 14th, 2008 09:50
[SOLVED] newbie question idqpbi Email List Archive 0 December 12th, 2006 01:46



All times are GMT. The time now is 06:41.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

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 38 39 40