This section describes some issues you may encounter once Jaspersoft OLAP is installed. For troubleshooting instructions regarding installation, refer to the JasperReports Server Installation Guide. For troubleshooting instructions regarding JasperReports Server, refer to the JasperReports Server Administrator Guide.
If Jaspersoft OLAP (running in a WebSphere application server) returns an error when you attempt to open the SugarCRM OLAP view (that is installed with JasperReports Server's sample data), the problem may be an incorrect port number in the XML/A connection that the view relies on. You must edit the SugarCRM XML/A Connection sample XML/A connection and enter the correct port number.
To correct the port number:
| 1. | In the Search field, enter the name of the connection you want to edit, and click the Search icon. |
You can enter a partial name, instead.
• For example, enter sugar.
The Repository appears, displaying the repository objects that match the text you enter.
| 2. | Select the object to edit, right-click, and select Edit. |
The search page results are narrowed down to data sources.
| 3. | Click the Sugar CRM XML/A Connection data source and click Edit in the context menu. |
The XML/A Connection page appears.
| 4. | In the URI field, update the port number to the port being used by WebSphere. WebSphere's default port is 9080. |
For example, if the value in the URI field initially reads:
http://127.0.0.1:8080/jasperserver-pro/xmla
Change it to:
http://127.0.0.1:9080/jasperserver-pro/xmla
| 5. | Click Test Connection. |
JasperReports Server displays a message indicating that the test was successful. If the test fails, verify the settings, paying particular attention to the port number.
| 6. | Click Submit. |
| 7. | Click View> OLAP Views, and test the Sugar CRM OLAP view. If it returns data, the port is correct. |