Performance Management/Spectrum integration failing with "Illegal character entity: expansion character (code 0x5)" error

Products

• Network Observability
• CA Performance Management

Issue/Introduction

The Spectrum Data Source sync is failing in Portal and the following exception is seen in the DMService.log file:

Data source DS(8) Spectrum@xxxxx encountered an error while processing a sync request. Check the logs for that product to determine the cause of the problem within the data source.  The following stack trace shows the context of the sync request:
jakarta.xml.ws.WebServiceException: [com.ctc.wstx.exc.WstxLazyException] com.ctc.wstx.exc.WstxParsingException: Illegal character entity: expansion character (code 0x5)
 at [row,col {unknown-source}]: [1,23221]
 at org.apache.cxf.jaxws.JaxWsClientProxy.mapException(JaxWsClientProxy.java:193) ~[cxf-rt-frontend-jaxws-4.1.0.jar:4.1.0]
 at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:145) ~[cxf-rt-frontend-jaxws-4.1.0.jar:4.1.0]
 at jdk.proxy4.$Proxy127.pullRequest(Unknown Source) ~[?:?]
 at com.ca.im.portal.api.services.datasource.ProductSync2WSProxyImpl.pullRequest(ProductSync2WSProxyImpl.java:113) ~[portal-api-impl.services.impl-24.3.8-RELEASE-5.jar:?]
 at com.ca.im.portal.dm.productsync.DataSourcePull.pullSync(DataSourcePull.java:141) ~[classes/:?]
 at com.ca.im.portal.dm.productsync.DataSourcePullPhase.executeInternal(DataSourcePullPhase.java:37) ~[classes/:?]
 at com.ca.im.portal.dm.productsync.DataSourceSyncPhase.execute(DataSourceSyncPhase.java:76) ~[classes/:?]
 at com.ca.im.portal.dm.productsync.PullSyncPhaseTask.pullDataSource(PullSyncPhaseTask.java:111) ~[classes/:?]
 at com.ca.im.portal.dm.productsync.PullSyncPhaseTask.execute(PullSyncPhaseTask.java:74) [classes/:?]
 at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:100) [classes/:?]
 at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:93) [classes/:?]
 at java.util.concurrent.FutureTask.run(Unknown Source) [?:?]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
 at java.lang.Thread.run(Unknown Source) [?:?]
Caused by: com.ctc.wstx.exc.WstxLazyException: [com.ctc.wstx.exc.WstxLazyException] Illegal character entity: expansion character (code 0x5)
 at [row,col {unknown-source}]: [1,23221]
 
In the catalina.out file on the OneClick server shows the following:
 
group | Global Collections | group | 633454478765557898765544565700
group | Global Collections | group |  )�es:%�

group | Global Collections | group | 64e174f666544645433567654020000
group | Global Collections | group | 65655455446566544490a1a21860000

Environment

DX NetOps Performance Management

Cause

This was caused by a "&" character in the global collection name. 

Resolution

1. Remove the "&" character in the global collection
2. Re-run the Spectrum Sync in Portal.