Skip to content
+1-888-319-3663

COMMUNITY FORUM

XML File Source

Mick asked 7 years ago
I have an XML Query File as a Source and receive and “Out Of memory error when attempting to validate the source when using XML Query.  Are there particular standards required.  The XML file seem to have been from a JSON format originally.
<ServiceOrderSet xmlns:json=”http://james.newtonking.com/projects/json”>
  <QueryControl>
    <QueryMatchCount>1</QueryMatchCount>
    <OrderBy></OrderBy>
    <Skip>0</Skip>
    <Take>-1</Take>
 </QueryControl>
  <ServiceOrders xmlns:json=”http://james.newtonking.com/projects/json” json:Array=”true”>
    <ServiceOrder_ID>8124093</ServiceOrder_ID>
    <NewRecordCorrelation />
    <Interface_Version_ID>3008213</Interface_Version_ID>
    <JobLocation xmlns:json=”http://james.newtonking.com/projects/json”>
 
More info in middle:
 
    </HistorySet>
    <ClaimSet xmlns:json=”http://james.newtonking.com/projects/json”>
      <Claims json:Array=”true” />
    </ClaimSet>
    <MessageSet xmlns:json=”http://james.newtonking.com/projects/json”>
      <Messages json:Array=”true” />
    </MessageSet>
    <ErrorMessageSet xmlns:json=”http://james.newtonking.com/projects/json”>
      <ErrorMessages json:Array=”true” />
    </ErrorMessageSet>
  </ServiceOrders>
</ServiceOrderSet>
 
Answers
patrick answered 7 years ago
Mick,
I’ve run across this one other time I think.  The customer didn’t have too much data in the XML but there quite a few levels deep.
The issue comes in that with the number of records in the source file and the multiple deep nodes, the number of records that SmartConnect has to generate gets huge and we run out of memory in the heap for the application.  Development hinted there might also be a bug somewhere in there as well.
Net result though is that you won’t be able to use this file as-is.
You’d have to remove some data or some of the further-down XML nodes.
Patrick
eOne
Mick replied 7 years ago

Patrick,
Thanks for the reply, thought there may be an issue with the amount of levels being read.
Mick


If you would like to submit an answer or comment, please sign in to the eOne portal.