Article - CS286808
Cognos report failed to launch with error UDA-SQL-0528 The XML parser returned the following message: 'An exception occurred! Type:NetAccessorException, Message:Could not open file: <URL Report>
Modified: 05-Jun-2018
Applies To
- Windchill PDMLink 10.2 to 11.1 M020
Description
- Cognos report failed to launch with error:
- in Cognos logs :
- RQP-DEF-0177 An error occurred while performing operation "sqlOpenResult" status="-28".
UDA-SQL-0114 The cursor supplied to the operation 'sqlOpenResult' is inactive.
UDA-SQL-0528 The XML parser returned the following message: 'An exception occurred! Type:NetAccessorException, Message:Could not open file: <URL Report>'
- RQP-DEF-0177 An error occurred while performing operation "sqlOpenResult" status="-28".
- In Windchill logs:
- java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at com.infoengine.jndi.JNDIAdapterImpl.processRequest(JNDIAdapterImpl.java:181)
at com.infoengine.procunit.adapter.Adapter.send(Adapter.java:198)
at com.infoengine.SAK.ObjectWebject.invoke(ObjectWebject.java:262)
at com.infoengine.compiledTasks.file.plm.wcadmin.windchill.tasks.com.ptc.windchill.enterprise.report.executereporttemplate$2exml.invoke(executereporttemplate$2exml.java:121)
at com.infoengine.SAK.Task.invoke(Task.java:1806)
at com.infoengine.SAK.Task.invokeAndCheckExternalAccess(Task.java:1703)
at wt.method.WTAdapterImpl.processTask(WTAdapterImpl.java:711)
at wt.method.WTAdapterImpl.processRequest(WTAdapterImpl.java:481)
at com.infoengine.procunit.adapter.Adapter.send(Adapter.java:198)
at com.infoengine.SAK.Task.executeTaskRemotely(Task.java:2083)
at com.infoengine.SAK.Task.invoke(Task.java:1739)
at com.infoengine.SAK.Task.invoke(Task.java:1714)
at com.infoengine.SAK.Task.executeTask(Task.java:1968)
at com.infoengine.webject.mgt.DispatchTasks.invoke(DispatchTasks.java:631)
at com.infoengine.SAK.ManagementWebject.invoke(ManagementWebject.java:81)
at com.infoengine.soap.RPCHandler.execute(RPCHandler.java:1730)
at com.infoengine.soap.RPCHandler.execute(RPCHandler.java:1557)
at com.infoengine.soap.RPCHandler.internalExecute(RPCHandler.java:1543)
at com.infoengine.soap.RPCHandler.externalExecute(RPCHandler.java:1428)
at sun.reflect.GeneratedMethodAccessor287.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.infoengine.connector.InternalConnection$InternalInteraction.execute(InternalConnection.java:174)
at com.infoengine.connector.DataAccessObject.execute(DataAccessObject.java:187)
at com.infoengine.connector.DataAccessObject._execute(DataAccessObject.java:233)
at com.ptc.windchill.jdbc.client.cci.DataAccess.execute(DataAccess.java:76)
at com.ptc.windchill.jdbc.client.cci.CCIQuery.buildResultGroup(CCIQuery.java:130)
at com.ptc.windchill.jdbc.client.cci.CCIQuery.buildResult(CCIQuery.java:60)
at com.ptc.windchill.jdbc.client.util.AbstractSingleResultQuery.execute(AbstractSingleResultQuery.java:26)
at com.ptc.windchill.jdbc.client.impl.WindchillJdbcStatement.execute(WindchillJdbcStatement.java:294)
at com.ptc.windchill.jdbc.client.impl.WindchillJdbcStatement.executeQuery(WindchillJdbcStatement.java:304)
at com.ptc.windchill.enterprise.report.CognosXMLServlet.processRequest(CognosXMLServlet.java:254)
at com.ptc.windchill.enterprise.report.CognosXMLServlet.doGet(CognosXMLServlet.java:172)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.ptc.jws.servlet.filter.WsdlServletFilter.doFilter(WsdlServletFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:104)
at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at wt.httpgw.filter.TrustedAuthFilter.delegateWrappedRequest(TrustedAuthFilter.java:293)
at wt.httpgw.filter.AbstractRemoteUserFilter.doFilter(AbstractRemoteUserFilter.java:142)
at wt.httpgw.filter.AbstractRemoteUserFilter.doFilter(AbstractRemoteUserFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:294)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at wt.servlet.BufferToFileFilter.doFilter(BufferToFileFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:335)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1652)
at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:56)
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.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:65)
at java.lang.Thread.run(Thread.java:745)
at org.apache.tomcat.util.threads.TaskThread.run(TaskThread.java:103)
- java.lang.NullPointerException
- in Cognos logs :
This is a printer-friendly version of Article 286808 and may be out of date. For the latest version click CS286808