AnsweredAssumed Answered

NSQL_SYNTAX_ERROR_TEXT_EMPTY

Question asked by urmas on Jan 22, 2016
Latest reply on Nov 7, 2018 by juanv

I am trying to modify one of the portlets in the PMO accelerator without much success.

 

One of the avenues is to XOG out the portlet and modify the xml. That part goes well,.

The problem is I cannot XOG back the xml file, furhter I cannot XOG back the xml file as read without any modifactions.

I get the same error in both cases.

I take the out indicates that the command line client in v13.3 is working OK.

 

Is there a trick to that?

<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">

  <Object type="contentPack"/>

  <Status elapsedTime="0.1 seconds" state="FAILURE"/>

  <Statistics failureRecords="1" insertedRecords="-1" totalNumberOfRecords="1" updatedRecords="1"/>

  <Records>

  <Record>

  <KeyInformation>

  <column name="externalSource">NIKU</column>

  <column name="source">customer</column>

  <column name="code">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</column>

  </KeyInformation>

  <ErrorInformation>

  <Severity>FATAL</Severity>

  <Description>XOG-3052: Query record has not been inserted com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_TEXT_EMPTY

at com.niku.union.persistence.nsql.NSQLQuery.checkSyntax(NSQLQuery.java:117)

at com.niku.union.persistence.nsql.NSQLQuery.initialize(NSQLQuery.java:220)

at com.niku.union.persistence.nsql.NSQLQuery.&lt;init&gt;(NSQLQuery.java:315)

at com.niku.union.persistence.nsql.NSQLController.getQueryForUpdate(NSQLController.java:124)

at com.niku.npt.xblhandlers.GGNSQLHandler.xogStoreQuery(GGNSQLHandler.java:773)

at com.niku.npt.xblhandlers.GGNSQLHandler.postProcess(GGNSQLHandler.java:111)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1411)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:260)

at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)

at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:197)

at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)

at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)

at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:599)

at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:359)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.valves.StuckThreadDetectionValve.invoke(StuckThreadDetectionValve.java:193)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:190)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2442)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2431)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:722)</Description>

  <Exception><![CDATA[

com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_TEXT_EMPTY

at com.niku.union.persistence.nsql.NSQLQuery.checkSyntax(NSQLQuery.java:117)

at com.niku.union.persistence.nsql.NSQLQuery.initialize(NSQLQuery.java:220)

at com.niku.union.persistence.nsql.NSQLQuery.<init>(NSQLQuery.java:315)

at com.niku.union.persistence.nsql.NSQLController.getQueryForUpdate(NSQLController.java:124)

at com.niku.npt.xblhandlers.GGNSQLHandler.xogStoreQuery(GGNSQLHandler.java:773)

at com.niku.npt.xblhandlers.GGNSQLHandler.postProcess(GGNSQLHandler.java:111)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1411)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:260)

at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)

at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:197)

at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)

at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)

at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:599)

at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:359)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.valves.StuckThreadDetectionValve.invoke(StuckThreadDetectionValve.java:193)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:190)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2442)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2431)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:722)

]]></Exception>

  </ErrorInformation>

  </Record>

  </Records>

</XOGOutput>

Outcomes