Could not connect to generate Ad Hoc report in JasperReports 6.3


Article ID: 5000


Updated On:


CA Spectrum


The following error is displayed when generating Ad Hoc Availability report:

Could not connect to address=(host=breeze-w2k8vm3)(port=3306)(type=master) : breeze-w2k8vm3 

You may also see the following error:

2021-03-24 11:10:38,011 ERROR EngineServiceImpl,http-apr-80-exec-2:2059 - error loading JRXML
net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 92; cvc-complex-type.2.4.a: Invalid content was found starting with element 'propertyExpression'. One of '{"":property, "":import, 


The spectrum_domain_ds Data source is pointing to the wrong SRM (Spectrum Report Manager) hostname.




CA Spectrum 10.2 and JasperReports 6.3


Manually change the spectrum_domain_ds Data source settings.


1. In the Home page of JasperReports, Data Sources, click on View list


2. Right-click the spectrum_domain_ds item and choose Edit.


3. Supply the Host, Port, and Database information.

Host: SRM hostname

Port: 3306

Database: srmdbapi


4. In case test connection fails, please reference knowledge document KB000004186 "MySQL Connector/ODBC Test fails while configuring the Ad Hoc Report ODBC driver" located at

5. Save the changes.


Additional Information

You may also need to re-deploy the integration components from the Report Manager page:


1558691837039000005000_sktwi1f5rjvs16gqm.png get_app
1558691835378000005000_sktwi1f5rjvs16gql.png get_app
1558691833593000005000_sktwi1f5rjvs16gqk.png get_app
1558691830689000005000_sktwi1f5rjvs16gqj.png get_app