This issue has been addressed in Spectrum 10.2.3 with the 10.02.03.PTF_10.3.336 patch.
This issue has also been addresses in Spectrum 10.4.1.
This issue can also be addressed by doing the following:
-
- Login to Jasperreport Server
- In the menu bar select: View -> Repository
- Open the folder: root -> Public -> ca -> Spectrum -> datasources
- Right click on spectrum_domain_ds in the Repository area and select Edit
- In the upcoming screen (Edit Data Source: spectrum_domain_ds) edit the URL to fit your SRM (Spectrum Report Manager) name:
- jdbc:mysql://<<your_SRM_Server_Name>>:3306/srmdbapi
- Note : Do not Enter FQDN in the SRM Server Name, just enter Host Name
- Click Save to leave the screen and click Save on the upcoming popup, too.
- Repeat steps 4 to 6 for spectrum_ds
Note : Please restart the Apache Tomcat on the Jaspersoft Server & Relaunch the browser.
If you test the connection and you are still unable to connect, try adding the fully qualified domain name to the name of the SRM machine. For example instead of:
mysql://spec_mls:3306/srmdbapi
Add the FQDN:
mysql://spec_mls.broadcom.com:3306/srmdbapi