kgor
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: XML not getting populated with all Data from Source
Hi , Thank you for the reply. So, I gave it a XSD file created from XML file below. but the file generated is incorrect. where The GLENTRY node should get repeated but its not. after I gave it XSD schema and root node here is formatter screenshot not sure how can I send you the XSD don’t see a option to attach the XSD. Here is screenshot of what it generated where as it actually should generate per XML above Thank you, Kamlesh3.5KViews0likes2CommentsRe: XML not getting populated with all Data from Source
Hi, Thank you, So I did what you suggested, Below are the screenshots for your ref and I still get multiple documents Mapper XML Formatter Binary to document Error returned by XML formatter I am trying to achieve this , where all my lines should get populated in between tags. <create> <GLBATCH> <JOURNAL>PYRJ</JOURNAL> <BATCH_DATE>$BatchDate</BATCH_DATE> <BATCH_TITLE>$BatchTitle</BATCH_TITLE> <ENTRIES> <GLENTRY> <ACCOUNTNO>$GLAccount</ACCOUNTNO> <DEPARTMENT>$Dept</DEPARTMENT> <LOCATION>$Location</LOCATION> <PROJECTID>$Project</PROJECTID> <TR_TYPE>-1</TR_TYPE> <AMOUNT>$Credit</AMOUNT> <DESCRIPTION>$Description</DESCRIPTION> <GLDIMEVENT>$Event</GLDIMEVENT> <REFERENCENO>$ReferenceNo</REFERENCENO> </GLENTRY> </ENTRIES> </GLBATCH> </create>3.5KViews0likes1CommentXML not getting populated with all Data from Source
Hi, I have run into an interesting situation where my XML generator is not populating entire CSV file I reading. Basically, I am reading CSV file and trying to send that as one batch to SAGE Intacct using XML generator. but, in turn the XML generator is sending each line from CSV as separate XML document. Any help or insight is appreciated Thank you5.2KViews0likes6CommentsError List type cannot find data
Getting following error message when running the Snap (no errors thrown when validating) , and resolution is very generic (also I am new to snaplogic) Error message Expression worked for 739 previous documents, but failed on document #740 with the error: List type does not have a method named: status, found in: …n.result.status. Perhaps you meant: sort, shift, lastIndexOf, toString, hasOwnProperty, unshift Resolution: Please check expression syntax and data types. Hide Details… Transaction Failure Router[5d9daced2c06b7666704ec4b_4be57702-9261-436c-a3bd-1d9477c7e5e5 – 150ee38e-341b-432b-9fe2-1e385ceb9fd6] `com.snaplogic.snap.api.SnapDataException: Expression worked for 739 previous documents, but failed on document #740 with the error: List type does not have a method named: status, found in: …n.result.status. Perhaps you meant: sort, shift, lastIndexOf, toString, hasOwnProperty, unshift at com.snaplogic.util.ExpressionUtils$MyExpressionProperty.eval(ExpressionUtils.java:297) at com.snaplogic.snap.api.impl.PropertyValuesImpl$ValidatingExpressionProperty.eval(PropertyValuesImpl.java:1005) at com.snaplogic.snap.api.impl.PropertyValuesImpl$ValidatingExpressionProperty.eval(PropertyValuesImpl.java:993) at com.snaplogic.snaps.flow.Router.process(Router.java:218) at com.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:106) at com.snaplogic.snap.api.ExecutionUtil.executeForDocument(ExecutionUtil.java:118) at com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:81) at com.snaplogic.snap.api.SimpleSnap.execute(SimpleSnap.java:70) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:770) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:552) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:836) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:402) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:116) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Resolution: Please check expression syntax and data types. Error Fingerprint[0] = efp:com.snaplogic.util.RQqZCdjk` Transaction Failure Router[5d9daced2c06b7666704ec4b_4be57702-9261-436c-a3bd-1d9477c7e5e5 – 150ee38e-341b-432b-9fe2-1e385ceb9fd6] `com.snaplogic.cc.snap.common.ThreadDetails: prio=4 Id=54510 RUNNABLE at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.fetchStackFrames(Native Method) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.fetchStackFrames(StackStreamFactory.java:386) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.getNextBatch(StackStreamFactory.java:322) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.peekFrame(StackStreamFactory.java:263) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.hasNext(StackStreamFactory.java:351) at java.base@11.0.7/java.lang.StackStreamFactory$StackFrameTraverser.tryAdvance(StackStreamFactory.java:593) at java.base@11.0.7/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:127) at java.base@11.0.7/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:502) … at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.fetchStackFrames(Native Method) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.fetchStackFrames(StackStreamFactory.java:386) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.getNextBatch(StackStreamFactory.java:322) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.peekFrame(StackStreamFactory.java:263) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.hasNext(StackStreamFactory.java:351) at java.base@11.0.7/java.lang.StackStreamFactory$StackFrameTraverser.tryAdvance(StackStreamFactory.java:593) at java.base@11.0.7/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:127) at java.base@11.0.7/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:502) at java.base@11.0.7/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:488) at java.base@11.0.7/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474) at java.base@11.0.7/java.util.stream.FindOps$FindOp.evaluateSequential(FindOps.java:150) at java.base@11.0.7/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base@11.0.7/java.util.stream.ReferencePipeline.findFirst(ReferencePipeline.java:543) at org.apache.logging.log4j.util.StackLocator.lambda$calcLocation$12(StackLocator.java:78) at org.apache.logging.log4j.util.StackLocator$Lambda$99/0x0000000800256840.apply(Unknown Source) at java.base@11.0.7/java.lang.StackStreamFactory$StackFrameTraverser.consumeFrames(StackStreamFactory.java:534) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.doStackWalk(StackStreamFactory.java:306) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.callStackWalk(Native Method) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.beginStackWalk(StackStreamFactory.java:370) at java.base@11.0.7/java.lang.StackStreamFactory$AbstractStackWalker.walk(StackStreamFactory.java:243) at java.base@11.0.7/java.lang.StackWalker.walk(StackWalker.java:498) at org.apache.logging.log4j.util.StackLocator.calcLocation(StackLocator.java:75) at org.apache.logging.log4j.util.StackLocatorUtil.calcLocation(StackLocatorUtil.java:71) at org.apache.logging.log4j.core.impl.Log4jLogEvent.getSource(Log4jLogEvent.java:669) at com.snaplogic.cc.log.JsonLogLayout.writeFileInfo(JsonLogLayout.java:136) at com.snaplogic.cc.log.JsonLogLayout.writeAllFields(JsonLogLayout.java:109) at com.snaplogic.cc.log.JsonLogLayout.toSerializable(JsonLogLayout.java:91) at com.snaplogic.cc.log.JsonLogLayout.toSerializable(JsonLogLayout.java:43) at org.apache.logging.log4j.core.layout.AbstractStringLayout.toByteArray(AbstractStringLayout.java:304) at org.apache.logging.log4j.core.layout.AbstractLayout.encode(AbstractLayout.java:210) at org.apache.logging.log4j.core.layout.AbstractLayout.encode(AbstractLayout.java:37) at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.directEncodeEvent(AbstractOutputStreamAppender.java:197) at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.tryAppend(AbstractOutputStreamAppender.java:190) at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.append(AbstractOutputStreamAppender.java:181) at org.apache.logging.log4j.core.appender.RollingRandomAccessFileAppender.append(RollingRandomAccessFileAppender.java:252) at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:156) at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:129) at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:120) at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84) at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:464) at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:448) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:431) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:406) at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:63) at org.apache.logging.log4j.core.Logger.logMessage(Logger.java:146) at org.apache.logging.log4j.spi.AbstractLogger.tryLogMessage(AbstractLogger.java:2170) at org.apache.logging.log4j.spi.AbstractLogger.logMessageTrackRecursion(AbstractLogger.java:2125) at org.apache.logging.log4j.spi.AbstractLogger.logMessageSafely(AbstractLogger.java:2108) at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:2013) at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:1882) at org.apache.logging.slf4j.Log4jLogger.warn(Log4jLogger.java:254) at com.snaplogic.common.runtime.RuntimeStatus.setState(RuntimeStatus.java:275) at com.snaplogic.cc.snap.common.SnapContext.failing(SnapContext.java:632) at com.snaplogic.cc.snap.common.SnapRunnableImpl.failSnap(SnapRunnableImpl.java:996) at com.snaplogic.cc.snap.common.SnapRunnableImpl.handleException(SnapRunnableImpl.java:981) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:857) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:402) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:116) at java.base@11.0.7/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base@11.0.7/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base@11.0.7/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base@11.0.7/java.lang.Thread.run(Thread.java:834) Error Fingerprint[0] = efp:java.lang.oGpzqXfl`2.3KViews0likes1Comment