AnsweredAssumed Answered

Error message appears after XOG in data to the project

Question asked by Peter_B. on Nov 5, 2012
Latest reply on Nov 22, 2012 by Peter_B.
Hi All,

we have issue with xog in data to the some of projects.
here are steps which i've done:
1. xog out project
2. result of 1 i'm trying xog in with changed data or even same data and i'm getting error message below:

<Exception><![CDATA[
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row


at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.oracle.OracleImplStatement.execute(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)

at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)

at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$bd701540.execute(<generated>)

at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2320)

at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:702)

at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:611)

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:451)

at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:222)

at com.niku.xql2.pmd.PMDRecordSet.executePMDStatement(PMDRecordSet.java:253)

at com.niku.xql2.pmd.PMDRecordSet.<init>(PMDRecordSet.java:85)

at com.niku.xql2.pmd.PMDDataSource.select(PMDDataSource.java:93)

at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:826)

at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1371)

at com.niku.xql2.eval.XQLPropertyNode.eval(XQLPropertyNode.java:92)

at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)

at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1043)

at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1017)

at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:59)

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

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:1342)

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:161)

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

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

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:161)

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

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

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:161)

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

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

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:245)

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

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

at com.niku.xog.handler.XOGProcessHandler.postProcess(XOGProcessHandler.java:44)

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

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.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.xql2.XQLProcessor.process(XQLProcessor.java:239)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:280)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:412)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:277)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:161)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:760)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:214)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:196)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1371)

at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:891)

at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:385)

at com.niku.union.web.PortletController.processRequest(PortletController.java:160)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1090)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)

at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:322)

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

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

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

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:121)

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

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

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:29)

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

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

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

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

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

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

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

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

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

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Thread.java:662)
]]></Exception>

Problem is that this issue appears not in all projects but only in some of them and we coulnd find anything which could cause this issue.
Followed error message it seems that it is not possible unique identification of this particular project but i'm trying xog in also same data as i got as a result and still getting same error.

Could you please advice anybody?

Many thanks,
Peter

Outcomes