AnsweredAssumed Answered

Error when applying solution pack 3

Question asked by k.durshanapally on Dec 18, 2012
Latest reply on Dec 18, 2012 by k.durshanapally
Hi,

i have successfully installed the solution pack 3 add in in the 13.1.0.2 version but i am facing the below error when i am trying to apply that add-in from the administrator section in the clarity:

ERROR 2012-12-18 17:02:25,056 [http-bio-8080-exec-8] niku.xql2 (clarity:admin:5704042__01947AC2-FF6D-4803-A0EE-F827C54BC717:content.applyPack) Internal Processing exception
com.niku.xog.XOGException: Failed to parse input null with resource component csp path /apps/installs/clarity/META-INF/content/xog/csp/queries/csp.prjStatusProjects.xml
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:647)
at com.niku.content.xbl.handlers.ApplyXogHandler.postProcess(ApplyXogHandler.java:49)
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:257)
at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:283)
at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:388)
at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:271)
at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:155)
at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:749)
at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:211)
at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:199)
at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1405)
at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:232)
at com.niku.union.web.PortletController.processRequest(PortletController.java:159)
at com.niku.union.web.WebActionController.processAction(WebActionController.java:1218)
at com.niku.union.web.WebActionController.processRequest(WebActionController.java:185)
at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:413)
at com.ca.clarity.uif.UIServlet.service(UIServlet.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:130)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefau
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedi
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.NullPointerException
at java.io.Reader.<init>(Reader.java:78)
at java.io.InputStreamReader.<init>(InputStreamReader.java:97)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminCli
... 48 more



well i noticed an interesting thing in this error. The file it is referring to in th error does not exist but there is a file with the almost same name, just an underscore is the difference.

the error shows the filename as csp.prjStatusProjects.xml at the path /apps/installs/clarity/META-INF/content/xog/csp/queries/csp.prjStatusProjects.xml but i can see a file with name csp_prjStatusProjects.xml (difference is an underscore after the csp in the first part of the file name)

So i am not sure what this error is and thought of asking in this forum since there might be someone who have successfully installed the solution pack. Anyway here is the content of the file mentioned in the error:

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_contentPack.xsd">
<Header action="write" externalSource="NIKU"
objectType="contentPack" version="12.0"/>
<contentPack update="true">
<queries update="true">
<query category="PRODUCTIVITY" code="csp.prjStatusProjects"
isUserPortletAvailable="0" source="csp.ca.com">
<nls description="Xcelsius: Project Status"
languageCode="en" name="Project Status Projects Filter"/>
<nsql dbId="Niku" dbVendor="all"><![CDATA[SELECT DISTINCT
       @SELECT:DIM:USER_DEF:IMPLIED:STATUS:inv.name:inv_name@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:STATUS:inv.id:inv_id@
FROM   INV_INVESTMENTS inv
INNER  JOIN INV_PROJECTS p ON inv.id = p.prID
INNER  JOIN ODF_CA_COP_PRJ_STATUSRPT sr ON inv.id = sr.odf_parent_id
WHERE  inv.is_active = 1
AND    p.is_template <> 1
AND    @WHERE:SECURITY:PROJECT:inv.id@
AND    @FILTER@]]></nsql>
<attribute id="inv_name" required="false"/>
<attribute id="inv_id" required="false"/>
</query>
</queries>
</contentPack>
</NikuDataBus>

Outcomes