search cancel

Service Point fails with a net::ERR_ABORTED 500 error when running a data object from Service Catalog

book

Article ID: 190357

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

In Service Point, when expanding a select box in a Catalog form, which calls a data object, the data object calls a Standard Procedure, The standard procedure calls a view and the view runs a query against a database different from the mdb, then it hangs and keeps loading showing the spinning wheel.

The console shows:
jquery.js:1 GET http://catalog_hostname:9090/usm/wpf?Node=icguinode.jsonpformrenderer&Args=objd-consultar-info-departamento&Args=
net::ERR_ABORTED 500

network tab shows:

HTTP 500 for: http://catalog_hostname:9090/usm/wpf?Node=icguinode.jsonpformrenderer&Args=objd-consultar-info-departamento&Args=


view.log shows:

ERROR [http-nio-9090-exec-1] [XmltDomImp] Exception TranslatingToValidXML in node:option, Last Tag=*
org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.
 at org.apache.xerces.dom.CoreDocumentImpl.createElement(Unknown Source)
 at com.ca.usm.xmlt.XmltDomImp.openTag(XmltDomImp.java:210)
 at com.ca.usm.xmlt.XmltDomImp.openTag(XmltDomImp.java:233)
 at com.ca.usm.xmlt.XmltDomImp.addObject(XmltDomImp.java:729)
 at com.ca.usm.xmlt.XmltDomImp.addObject(XmltDomImp.java:707)
 at com.ca.usm.xmlt.XmltDomImp.addObject(XmltDomImp.java:727)
 at com.ca.usm.xmlt.XmltDomImp.addObject(XmltDomImp.java:751)
 at com.ca.usm.xmlt.XmltDomImp.translateToValidXMLDoc(XmltDomImp.java:1014)
 at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:58)
 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:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.system.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:47)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:364)
 at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:170)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.HttpHeaderNullifierFilter.doFilter(HttpHeaderNullifierFilter.java:99)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.auth10.federation.WSFederationFilter.doFilter(WSFederationFilter.java:64)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.NtlmAuthenticationFilter.doFilter(NtlmAuthenticationFilter.java:136)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.SsoAuthFilter.doFilter(SsoAuthFilter.java:57)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.SecurityHandleFilter.doFilter(SecurityHandleFilter.java:201)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.SecurityHeadersFilter.doFilter(SecurityHeadersFilter.java:78)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.ClickjackFilter.doFilter(ClickjackFilter.java:94)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Unknown Source)
2020/04/30 08.47.32.316 ERROR [http-nio-9090-exec-1] [DefaultContentEngine] Exception occured processing request for plugin: com.ca.usm.billing.ContentEngine.CFormRenderer null
2020/04/30 08.47.32.316 DEBUG [http-nio-9090-exec-1] [DocumentGenerator] Backend threw an [email protected]
java.lang.Exception: com.ca.usm.contentInterface.contentProcessRequestException
 at com.ca.usm.util.ViewManager.doRequest(ViewManager.java:56)
 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:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.system.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:47)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:364)
 at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:170)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.HttpHeaderNullifierFilter.doFilter(HttpHeaderNullifierFilter.java:99)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.auth10.federation.WSFederationFilter.doFilter(WSFederationFilter.java:64)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.NtlmAuthenticationFilter.doFilter(NtlmAuthenticationFilter.java:136)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.SsoAuthFilter.doFilter(SsoAuthFilter.java:57)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.SecurityHandleFilter.doFilter(SecurityHandleFilter.java:201)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.SecurityHeadersFilter.doFilter(SecurityHeadersFilter.java:78)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.ca.usm.httpfilter.ClickjackFilter.doFilter(ClickjackFilter.java:94)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.ca.usm.contentInterface.contentProcessRequestException
 at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:75)
 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)
 ... 58 more
Exception message: com.ca.usm.contentInterface.contentProcessRequestException
Generating a default document...
Getting the guinode from registry: icguinode.error

No error in IncidentMS.log and searchMS.log in DEBUG level.


Environment

Release : 17.2 RU 6

Component : XFLOW INTERFACE FOR SDM

Cause

Defect with Catalog/Service Point 17.2 RU 6 and previous rollups.

Resolution


This is solved in 17.2 RU 7.


To download 17.2 RU 7:
https://techdocs.broadcom.com/us/product-content/recommended-reading/technical-document-index/ca-service-management-solutions-patches.html?intcmp=searchresultclick&resultnum=1?intcmp=searchresultclick&resultnum=1?intcmp=searchresultclick&resultnum=1?intcmp=searchresultclick&resultnum=1&r=1

To install 17.2 RU 7:
http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-2/installing/Installing-CA-Service-Management-17_2_0_7.html