# Join multiple XMLWrapper gateway results **URL:** \ **Category:** Forum\ **Tags:** Former-Crossvision-Products, Service-Orchestrator\ **Created:** [May 30, 2008, 7:58pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844 "2008-05-30T19:58:15Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![jgoodwin](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jgoodwin](https://techcommunity.softwareag.com/u/jgoodwin)\ **Post date:** [May 30, 2008, 7:58pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/1 "2008-05-30T19:58:15Z")
I have a sequence that uses the XMLWrapper gateway to call into a natural sub program to retreive some data on the mainframe. The result of the sub program is sometimes just a subset of the total amount of data that should be returned. I’m new to Natural but I was told there was a limit on the Natural return buffer. In the past we’ve place the burden on the consumer of the webservice to call back into the service to retreive the additional data (sometimes as many as ten times), however, now I’d like to be able to return all of the data in one web service call. Is there a way that I can join the results of the calls to the XMLWrapper gateway and return those as one consolidated result set in the sequence? Examples would be great. Thanks in advance. ---
**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\ **Post date:** [May 31, 2008, 1:39pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/2 "2008-05-31T13:39:52Z")
If you are calling a mainframe Natural service, it is possible for the mainframe to return as much data as is available - the protocol needs to be upgraded to either use the Adabas 8 SVC interface or to use the TCP/IP interface. Both allow message sizes to increase from the 32k limit you are currently dealing with up to 2GB message size. ---
**Author:** ![jgoodwin](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jgoodwin](https://techcommunity.softwareag.com/u/jgoodwin)\ **Post date:** [June 5, 2008, 2:49am UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/3 "2008-06-05T02:49:11Z")
It is a mainframe natural service and we are indeed using Adabas SVC 8. I have verified that the error occurs when a result set of over 30K is returned. Here is the actual error I’m getting: Broker Error 1014 6974: Natural RPC Server returns: I00013N1 9999 NAT6974 Conversion error on Server, reason 5 ,039., NE=01,I00013N1999901O The RPC Server has these properties set: AUTO=ON,ETID=\* STACK=(LOGON SERVRLIB) RPC=(SERVER=ON,LOGONRQ=OFF,ACIVERS=4,NTASKS=1, SRVNODE=ETB161,SRVNAME=NATQ10SV,SRVUSER=‘\*NSC’,TRACE=1, TRANSP=ACI,RPCSIZE=128,MAXBUFF=64) Broker properties: Long Message Buffer NUM-LONG-BUFFER.: 2504 Length…: 4096 Active…: High water mark.: 56 Short Message Buffer NUM-SHORT-BUFFER: 2504 Length…: 256 Active…: 3 High water mark.: 90 ---
**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\ **Post date:** [June 5, 2008, 10:56am UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/4 "2008-06-05T10:56:34Z")
What version of Natural are you using? There is a fix for NAT423 that might be relevant - check ServLine24 for “NAT6974” or docid 549652. ---
**Author:** ![jgoodwin](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jgoodwin](https://techcommunity.softwareag.com/u/jgoodwin)\ **Post date:** [June 5, 2008, 7:40pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/5 "2008-06-05T19:40:04Z")
We are using Natural 4.2.4 ---
**Author:** ![Javier\_C](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Javier\_C](https://techcommunity.softwareag.com/u/Javier_C)\ **Post date:** [June 5, 2008, 8:41pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/6 "2008-06-05T20:41:12Z")
In case you still need to accumulate several responses into a single document, there are different ways this can be done in Service Orchestrator. For start, you should append the result of every XMLWrapper call to the payload, e.g. by using multiple parts, or by means of replicate/replicants. Then, the most standard way would be to use an XSLT which transform this payload into the document you want. There are other options, through a couple of non-official reusable components used internally at Software AG: - One that allows to use JavaScript to access and manipulate the payload - Another one (XMLRefactoring) that allows to perform easy copy/paste operations in the payload However I am not sure about its real availability in your case. Hope this helps ---
**Author:** ![Rolf\_Bahlke](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/rolf_bahlke/32/109_2.png) [@Rolf\_Bahlke](https://techcommunity.softwareag.com/u/Rolf_Bahlke)\ **Post date:** [June 6, 2008, 5:17pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/7 "2008-06-06T17:17:31Z")
> [@jgoodwin](#): > > Here is the actual error I’m getting: > Broker Error 1014 6974: Natural RPC Server returns: I00013N1 9999 NAT6974 Conversion error on Server, reason 5 ,039., NE=01,I00013N1999901O According to the manual you should increase MAXBUFF. ---
**Author:** ![jgoodwin](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jgoodwin](https://techcommunity.softwareag.com/u/jgoodwin)\ **Post date:** [June 6, 2008, 11:07pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/8 "2008-06-06T23:07:50Z")
Yes, I thought that might be that case. However, I have increased MAXBUFF from 30 to 64 with no change in behavior. ---
**Author:** ![jgoodwin](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jgoodwin](https://techcommunity.softwareag.com/u/jgoodwin)\ **Post date:** [June 6, 2008, 11:09pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/9 "2008-06-06T23:09:40Z")
Yes, I thought that might be that case. However, I have increased MAXBUFF from 30 to 64 with no change in behavior. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:49pm UTC](https://techcommunity.softwareag.com/t/join-multiple-xmlwrapper-gateway-results/76844/10 "2021-04-02T14:49:31Z")