AnsweredAssumed Answered

Could not find NSQL id error

Question asked by MirleniaMendoza on Aug 23, 2012
Latest reply on Aug 31, 2012 by shalinee
We are trying to finally set up our test Clarity environment. Everything runs good but a Contact your System Administrator error arises ONLY in the project General Properties screen where the Project info: (Description, ID, PM, etc) is.
For example, the Budget section and the other ones related to the same project is working. This happens for all investments (projects) on the test environment....

Please, we are clueless on how to debug or solve this.

**Our DBA tried several times to do EXPORT/IMPORT from our production database with no luck at all....


This is an extract for the error we found at app3-niku.log:

ERROR 2012-08-23 10:52:31,493 [http-80-Processor5] niku.xql2 (ET34797:8892856__-2e504319:projmgr.projectProperties) Internal Processing exception
com.niku.union.odf.lookup.LookupException: com.niku.union.persistence.nsql.NSQLException: Could not find NSQL with ID: 5009004
at com.niku.odf.lookup.LookupControllerImpl.getLookupValue(LookupControllerImpl.java:419)
at com.niku.odf.object.xbl.ODFPropertyHandler.loadViewData(ODFPropertyHandler.java:662)
at com.niku.odf.object.xbl.ODFPropertyHandler.getProperties(ODFPropertyHandler.java:234)
at com.niku.odf.object.xbl.ODFPropertyHandler.postProcess(ODFPropertyHandler.java:82)
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:393)
at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:258)
at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:142)
at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:759)
at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:213)
at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:188)
at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1322)
at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:861)
at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:381)
at com.niku.union.web.PortletController.processRequest(PortletController.java:160)
at com.niku.union.web.WebActionController.processAction(WebActionController.java:1087)
at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)
at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:319)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.niku.union.persistence.nsql.NSQLException: Could not find NSQL with ID: 5009004
at com.niku.union.persistence.nsql.NSQLQuery.loadNSQLAttributes(NSQLQuery.java:696)
at com.niku.union.persistence.nsql.NSQLQuery.<init>(NSQLQuery.java:290)
at com.niku.union.persistence.nsql.NSQLQuery.<init>(NSQLQuery.java:313)
at com.niku.union.persistence.nsql.NSQLController.getQuery(NSQLController.java:98)
at com.niku.odf.lookup.LookupControllerImpl.getLookupValue(LookupControllerImpl.java:368)

Outcomes