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