topic XML Input in DataFlux in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/XML-Input-in-DataFlux/m-p/133018#M1858 <HTML><HEAD></HEAD><BODY><P>I am new to the tool and would like to read and XML file. I have worked on other tools where we could parse an XML with XSD.&nbsp; I have attached the XML file, XML Map and XQUERY generated form the node. Can someone help me why i am unable to parse the XML? The node just says Error in PreExec step. The help wasn't much useful either on the Tool.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 09 May 2013 11:24:48 GMT PhaniChamarthy 2013-05-09T11:24:48Z XML Input in DataFlux https://communities.sas.com/t5/SAS-Data-Management/XML-Input-in-DataFlux/m-p/133018#M1858 <HTML><HEAD></HEAD><BODY><P>I am new to the tool and would like to read and XML file. I have worked on other tools where we could parse an XML with XSD.&nbsp; I have attached the XML file, XML Map and XQUERY generated form the node. Can someone help me why i am unable to parse the XML? The node just says Error in PreExec step. The help wasn't much useful either on the Tool.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 09 May 2013 11:24:48 GMT https://communities.sas.com/t5/SAS-Data-Management/XML-Input-in-DataFlux/m-p/133018#M1858 PhaniChamarthy 2013-05-09T11:24:48Z Re: XML Input in DataFlux https://communities.sas.com/t5/SAS-Data-Management/XML-Input-in-DataFlux/m-p/597260#M18214 <P>Hi, I know this post is too old, thought it might help someone else in future. I had a similar issue.</P> <P>&nbsp;</P> <P>1. Update the app.cfg located at "<EM>C:\Program Files\SASHome\DataFluxDataManagementStudio\2.6\etc"&nbsp;</EM>with below line</P> <P>java/command=<STRONG>"C:\Program Files\Java\jre1.8.0_172\bin\java.exe" -Xms108M -Xmx250M</STRONG></P> <P>&nbsp;</P> <P>For options looks at the documentation XML node section&nbsp;<A href="https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.7/dmpdmsug/Content/dfU_FAQ.html" target="_blank">https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.7/dmpdmsug/Content/dfU_FAQ.html</A></P> <P>&nbsp;</P> <P>2.But I found that once you add fields and by changing Maximum number of row on return from 0 some number or blank. It works.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33192i24C1376E09A3B07D/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Tue, 17 Mar 2020 05:54:54 GMT https://communities.sas.com/t5/SAS-Data-Management/XML-Input-in-DataFlux/m-p/597260#M18214 Rama_V 2020-03-17T05:54:54Z