Report Data object is failing after upgrade

[Rajasheker Chittanur]

Hello,

we upgraded from 12.9 to 17.1 after which we are seeing issue with one of the report data object. 
Below is the screenshot of the report data object and the error that we get,

Can anyone please suggest a solution for this issue.

Below are the errors from the logs,

2020/01/08 13.15.29.668 INFO  [http-nio-80-exec-14] [WPFServlet] END: Time taken for GET request, Node=icguinode.requestgetdynamicreport&callback=jQuery16405839320303715636_1578510897901&Args=f4227bfa083c1-205413f814796eaef361c3b1407160381969&Args=cntryName%3Aundefined&Args=CHART_XFIELDS%3A!CHART_YFIELDS%3A!TABLE_FIELDS%3A*&Args=&Args=-1&Args=1&Args=&Args=&Args=&Args=&Args=&Args=&Args=&Args=&b2b=json&_lessInfo=true&_=1578510929841 is:1432020/01/08 13.15.29.668 INFO  [http-nio-80-exec-14] [WPFServlet] END: Time taken for GET request, Node=icguinode.requestgetdynamicreport&callback=jQuery16405839320303715636_1578510897901&Args=f4227bfa083c1-205413f814796eaef361c3b1407160381969&Args=cntryName%3Aundefined&Args=CHART_XFIELDS%3A!CHART_YFIELDS%3A!TABLE_FIELDS%3A*&Args=&Args=-1&Args=1&Args=&Args=&Args=&Args=&Args=&Args=&Args=&Args=&b2b=json&_lessInfo=true&_=1578510929841 is:1432020/01/08 13.15.29.668 INFO  [http-nio-80-exec-14] [WPFServlet] NUmber of sqls=52020/01/08 13.15.30.259 INFO  [http-nio-80-exec-25] [WPFServlet] END: Time taken for GET request, Node=icguinode.launchsdmclient&sh=qNy8Ie8rDjvvZSc%2Bx6mBeOmYCRE%3D&Args=http&Args=ui1pcaap007x&Args=8096&Args=/CAisd/pdmweb.exe&Args=OP%3DSHOW_DETAIL%2BPERSID%3Dcr%3A9318556 is:6482020/01/08 13.15.30.259 INFO  [http-nio-80-exec-25] [WPFServlet] NUmber of sqls=262020/01/08 13.15.30.531 ERROR [http-nio-80-exec-80] [CGenReport] Exception occured in ProcessQuery. Rollback transaction and continuingjava.lang.NullPointerException2020/01/08 13.15.30.531 ERROR [http-nio-80-exec-80] [CGenReport] Exception occured in ReportDataViewExecute. Rollback transaction and continuingjava.lang.NullPointerException at java.util.Hashtable.put(Unknown Source) at com.ca.usm.reporting.ContentEngine.CGenReport.processQuery(CGenReport.java:2970) at com.ca.usm.reporting.ContentEngine.CGenReport.reportDataViewExecute(CGenReport.java:2735) at com.ca.usm.reporting.ContentEngine.CGenReport.reportDataViewExecute(CGenReport.java:2443) at sun.reflect.GeneratedMethodAccessor241.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.ca.usm.contentInterface.PluginMethod.invoke(DefaultContentEngine.java:172) at com.ca.usm.contentInterface.DefaultContentEngine.invokeMethod(DefaultContentEngine.java:98) at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:57) at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:17) at com.ca.usm.util.ViewManager.executeRequest(ViewManager.java:92) at com.ca.usm.util.ViewManager.doRequest(ViewManager.java:51) at com.ca.usm.util.ViewManager.processRequest(ViewManager.java:28) at com.ca.usm.producer.DocumentGenerator.processRequest(DocumentGenerator.java:563) at com.ca.usm.producer.DocumentGenerator.generateDocument(DocumentGenerator.java:270) at com.ca.usm.producer.DocumentGenerator.generateDocument(DocumentGenerator.java:241) at com.ca.usm.producer.DomProcessor.renderPage(DomProcessor.java:204) at com.ca.usm.producer.DomProcessor.service(DomProcessor.java:123) at com.ca.usm.producer.WPFServlet.service(WPFServlet.java:338) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.system.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:419) at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:169) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.HttpHeaderNullifierFilter.doFilter(HttpHeaderNullifierFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.NtlmAuthenticationFilter.doFilter(NtlmAuthenticationFilter.java:239) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.SsoAuthFilter.doFilter(SsoAuthFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.SecurityHandleFilter.doFilter(SecurityHandleFilter.java:201) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.ClickjackFilter.doFilter(ClickjackFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)2020/01/08 13.15.30.532 ERROR [http-nio-80-exec-80] [DefaultContentEngine] Exception occured invoking method on plugin:reportDataViewExecutejava.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor241.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.ca.usm.contentInterface.PluginMethod.invoke(DefaultContentEngine.java:172) at com.ca.usm.contentInterface.DefaultContentEngine.invokeMethod(DefaultContentEngine.java:98) at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:57) at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:17) at com.ca.usm.util.ViewManager.executeRequest(ViewManager.java:92) at com.ca.usm.util.ViewManager.doRequest(ViewManager.java:51) at com.ca.usm.util.ViewManager.processRequest(ViewManager.java:28) at com.ca.usm.producer.DocumentGenerator.processRequest(DocumentGenerator.java:563) at com.ca.usm.producer.DocumentGenerator.generateDocument(DocumentGenerator.java:270) at com.ca.usm.producer.DocumentGenerator.generateDocument(DocumentGenerator.java:241) at com.ca.usm.producer.DomProcessor.renderPage(DomProcessor.java:204) at com.ca.usm.producer.DomProcessor.service(DomProcessor.java:123) at com.ca.usm.producer.WPFServlet.service(WPFServlet.java:338) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.system.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:419) at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:169) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.HttpHeaderNullifierFilter.doFilter(HttpHeaderNullifierFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.NtlmAuthenticationFilter.doFilter(NtlmAuthenticationFilter.java:239) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.SsoAuthFilter.doFilter(SsoAuthFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.SecurityHandleFilter.doFilter(SecurityHandleFilter.java:201) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.ClickjackFilter.doFilter(ClickjackFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)Caused by: java.lang.NullPointerException at java.util.Hashtable.put(Unknown Source) at com.ca.usm.reporting.ContentEngine.CGenReport.reportDataViewExecute(CGenReport.java:2772) at com.ca.usm.reporting.ContentEngine.CGenReport.reportDataViewExecute(CGenReport.java:2443) ... 61 more2020/01/08 13.15.30.532 ERROR [http-nio-80-exec-80] [DefaultContentEngine] Exception occured processing request for plugin: com.ca.usm.reporting.ContentEngine.CGenReport null2020/01/08 13.15.30.650 INFO  [http-nio-80-exec-80] [WPFServlet] END: Time taken for POST request, icguinode.reportsgenericdataviewdisplay is:2128

Thanks,
Rajasheker Chittanur

[Lindsay Estabrooks]

The first thing that looks strange is the * at the end of your fields.

I have always made sure that the list of fields matches the SELECT attributes in name, number and order.

------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------

[Rajasheker Chittanur]

The same query was working in 12.9 so we didn't change anything after upgrading to 17.1 cp05

 

 

Thanks and Regards,

 

Rajasheker Chittanur

Service Catalog, Service Desk - Development and Support

Digital Technology

Baker Hughes

T [phone] | M [phone]

 

[Alen Sinanovic]

Hi,
Can you try to create a new query for the same purpose, edit it in the way Lindsay suggested and let us know if same thing happens?


------------------------------
Alen Sinanovic
Senior System Engineer Specialist
Sedam IT d.o.o.
Croatia
------------------------------

[Paul Coccimiglio]

Rajasheker..........

Did you apply any rollup patches to 17.1?

Were all the post upgrade tasks followed?


------------------------------
Paul Coccimiglio
Principal Support Engineer
Broadcom Inc.
------------------------------

[Rajasheker Chittanur]

Yeah – we applied 5 rollup patches and performed all taks

 

 

Thanks and Regards,

 

Rajasheker Chittanur

Service Catalog, Service Desk - Development and Support

Digital Technology

Baker Hughes

T [phone] | M [phone]