BookmarkSubscribeRSS Feed
PhaniChamarthy
Calcite | Level 5

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.  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.

Thanks

1 REPLY 1
Rama_V
Obsidian | Level 7

Hi, I know this post is too old, thought it might help someone else in future. I had a similar issue.

 

1. Update the app.cfg located at "C:\Program Files\SASHome\DataFluxDataManagementStudio\2.6\etc" with below line

java/command="C:\Program Files\Java\jre1.8.0_172\bin\java.exe" -Xms108M -Xmx250M

 

For options looks at the documentation XML node section https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.7/dmpdmsug/Content/dfU_FAQ.html

 

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.

 

image.png

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1622 views
  • 1 like
  • 2 in conversation