Troubleshooting TrueSight Smart Reporting integration

The integration of TrueSight Capacity Optimization with TrueSight Smart Reporting - Platform enables you to create, administer, and publish custom advanced reports for your entities seamlessly.

This section describes some common issues that you might encounter while integrating with and using TrueSight Smart Reporting - Platform, and provides suggested resolutions for the issues. Most of the issues occur due to incorrect configuration or lack of report data.

You can also create a BMC support case for further assistance.

Check whether TrueSight Smart Reporting - Platform is integrated with TrueSight Capacity Optimization

In TrueSight Capacity Optimization:

1. Log into the TrueSight Capacity Optimization console.
2. Click Administration > System > Status.
3. In the Status page, verify that the entry for TrueSight Smart Reporting - Platform is displayed.
In case of a communication issue or error, the component is displayed in Red.
Registration of TrueSight Smart Reporting - Platform is also audited in TrueSight Capacity Optimization.

Working with logs

This section describes log files that are available for this integration.

Relevant log files

Activating the debug log mode for TrueSight Smart Reporting - Platform API

If the registration error is not listed in the documentation or is a generic one (for example, TSR-CO30004, TSR-CO30009, TSR-CO30010), a debug log can be activated to trace all the API calls received from TrueSight Smart Reporting - Platform.

To activate the debug level for TrueSight Smart Reporting - Platform API:

Open the cpit-logger.conf file located at <CPITBASE>/datahub/tomcat/webapps/dh-services#data-prv/WEB-INF/classes.
Add the following line and save the file:
log4j.logger.com.bmc.bco.dataprv.service.v2.smartreporting=DEBUG, cpit
Restart the datahub.

Common issues

Issue	Cause	Resolution
TrueSight Smart Reporting - Platform is disconnected from TrueSight Capacity Optimization. TrueSight Smart Reporting - Platform is displayed in red in the Status page.	TrueSight Smart Reporting - Platform periodically (in 5 minutes) sends an heartbeat to check that TrueSight Capacity Optimization component is up and running. If TrueSight Capacity Optimization Status page displays TrueSight Smart Reporting - Platform in red color (error status), it means that no heartbeat calls have been received for a certain period (approximately 30 minutes). This can be caused by one of the following issues: Network issue TrueSight Smart Reporting - Platform instance is not running correctly TrueSight Capacity Optimization component status checker is not updating the status of the component.	Check that TrueSight Capacity Optimization and TrueSight Smart Reporting - Platform can reach each other through the network via telnet and ping. Check TrueSight Smart Reporting - Platform logs for errors. Check component status checker task logs in TrueSight Capacity Optimization console.
TrueSight Smart Reporting - Platform cannot be registered with TrueSight Capacity Optimization. The following error code is displayed in the Capacity Optimization log: TSR-CO030005	This error can be caused by one of the following scenarios: TrueSight Smart Reporting - Platform was installed in the same VM of another Capacity Optimization component (not a supported configuration). A previous registration was not completed successfully.	Make sure that TrueSight Smart Reporting - Platform is not installed in the same VM of another Capacity Optimization component. Contact the BMC Support team to clean up the registration data from database.
A report created based on access filter is empty for certain users.	This error can be caused by one of the following scenarios: Access filter refresh is disabled. The user who is viewing the report does not have access to the entities extracted by the report.	Ensure that the access filter refresh is enabled for the Capacity Optimization datasource configuration. For details, see Configuring TrueSight Smart Reporting - Platform settings. If the refresh option is enabled, check that the user who is viewing the report has the right permissions (acgroup) in Capacity Optimization to view the entities (for example, systems, domains) extracted by the report. For details, see User-permissions-for-TrueSight-Smart-Reporting.
While creating a view in TrueSight Smart Reporting - Platform, the TSCO-DataSource displays all capacity optimization tables instead of only data marts and public views. In this case, if the user selects any private table to compose a report, no data is displayed in the report.	This issue is caused only when TrueSight Capacity Optimization is using a PostgreSQL database. All Capacity Optimization internal tables are listed as the available tables in the datasource.	Ignore the internal tables and use only data marts and public views.