Configuring TrueSight Operations Management Report Engine
Perform the following procedures to configure TrueSight Operations Management Report Engine:
Configuring TrueSight Operations Management Report Engine for performance reports
Perform the following configurations for proper operation of the performance reports.
Creating an External Report attribute set
An External Report attribute set enables the following:
- Filtering capabilities — performance data is transferred from TrueSight Infrastructure Management Server to the report engine, and performance reports are generated only on those attributes you have selected.
- Normalization of attributes across platforms — you can group similar attributes across platforms in one attribute set. For example, the "% CPU Utilization In System Mode (%)" attribute is used for UNIX, while the "System CPU Utilization (%)" is used for Windows monitors. You can group both attributes under one "CPU" attribute and generate performance reports using the "CPU" attribute set.
A non-super admin user can create External Report attribute sets. To do this, the non-super admin user must have the following TrueSight Infrastructure Management permissions:
- Allow manage External Reports attribute set used in transferring data to external reporting DB - attribute set option locked
- Allow manage reports
For more information, see the following documentation:
- For TrueSight Presentation Server version 11.3.04, see Permissions reference
- For TrueSight Presentation Server versions 11.3.01 through 11.3.03, see Permissions reference
To create an External Report attribute set:
Configuring the Report Engine properties
Changing the report engine properties is not required. If you must change the report engine properties, the properties are located in the perfsladatatransfer.properties file, located in the appropriate directory for your operating system:
- For Windows: reportEngineInstallDirectory\ReportEngine\conf\properties
\perfsladatatransfer - For Linux: ReportEngine/conf/properties/perfsladatatransfer
To change the Report Engine properties:
Open the perfsladatatransfer.properties file using a text editor. The following properties are included in the file:
Property type
Parameter
Description
Data transfer schedule
reportengine.datatransfer.
schedule.intervalSchedule interval in seconds of the performance data transfer job. Valid values are positive whole numbers.
Default value (recommended): 3600reportengine.configjob
.schedule.intervalSchedule interval in seconds for configuration job which transfers configuration data. Valid values are positive whole numbers.
Default value (recommended): 3600
BMC recommends to set config job schedule to be equal or in multiple of the main data transfer job.reportengine.deleteconfigjob
.schedule.intervalSchedule interval for Delete job.
Default value (recommended): 3.00 AM UTC/GMTreportengine.datagapfillerjob
.schedule.intervalSchedule interval for Delete job.
Default value (recommended): 1.00 AM UTC/GMTreportengine.datatransfer.
pentaho.job.thread.countDefines the number of threads to read data from the TrueSight Infrastructure Management database. Default value (recommended): 10
Maximum history
reportengine.datatransfer.
maxhistoryretrieval.statdata.daysMaximum stats history data in days to be transferred from TrueSight Infrastructure Management server to report engine.
Valid values are positive whole numbers.
Default value (recommended): 0reportengine.datatransfer
.maxhistoryretrieval.ratedata.daysMaximum rate history data in days to be transferred from TrueSight Infrastructure Management server to report engine.
Valid values are positive whole numbers.
Default value (recommended): 90Chunk size
reportengine.datatransfer
.ratestat.chunksizeStats and rate data in hours that is transferred in one data transfer job cycle. To collect history, the chunk size must be greater than the job schedule interval. Valid values are positive whole numbers.
Default value (recommended): 3CSV file generation reportengine.csvfilegeneration
.enableGenerates .csv files in case of a data gap. If you do not want the Report Engine to generate .csv files during a data gap, set this parameter to false.
Default value: trueCollection of rate data reportengine.ratedatatransfer
.enableCollects the rate data. If you want the Report Engine to collect rate data, set this parameter to true.
Default value: falseBoolean reportengine.pentaho.logging.level
Indicates the value for default logging for performance data transfer in reportengine.log file. Default is ERROR. Recommended value is ERROR. If this is upgraded setup, change the value to ERROR Note
To change the Retention Age property, use the ConfigureRetention CLI command.
- Save the perfsladatatransfer.properties file.
- Restart the TrueSight Operations Management Report Engine service. See, Starting and Stopping the Report Engine service.
Configuring maximum history of performance data
This section describes the configuration for transferring performance data from TrueSight Infrastructure Management database to reporting engine database. Reporting Engine can be configured to transfer history data present in TrueSight Infrastructure Management Server before it has been registered with reporting engine.
You can configure the maximum history of performance data to be retrieved from TrueSight Infrastructure Management server over multiple cycles by modifying the following parameters.
reportengine.datatransfer.maxhistoryretention.statdata.days=0
reportengine.datatransfer.maxhistoryretention.ratedata.days=90
Maximum history is relative to current time. Default is set to 30 days.
Configuring TrueSight Operations Management Report Engine for Oracle Real Application Cluster
Note
After the Report Engine installation is finished, complete the following procedure to update the Oracle Real Application Cluster (RAC) JDBC URL:
In a text editor, create a URL based on the number of host names and instances.
The syntax is:jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fullyQua lifiedHostName1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= fullyQualifiedHostName2)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= fullyQualifiedHostName3)(PORT=1521))(LOAD_BALANCE=OFF)(FAILOVER=ON)( CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)(FAILOVER_M ODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=10)(DELAY=10))))
where,
fullyQualifiedHostName1 is the full name of node1 in the Oracle RAC.
fullyQualifiedHostName2 is the full name of node2 in the Oracle RAC.
fullyQualifiedHostName3 is the full name of node3 in the Oracle RAC.
serviceName is the connector to one or more instances.Note
The URL must be a single string and should not contain any new line characters in between the URL. The number of node entries can be modified based on the number of nodes in the RAC.
You can also provide virtual IP in the RAC URL.
Example:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac112-scan1.bmc.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORA95NEW)))
where,
rac112-scan1.bmc.com
is the virtual IP.- Stop the TrueSight Operations Management Report Engine service. For details, see Starting/Stopping of the BMC TrueSight Operations Management Report Engine service.
Create a backup of the database_config.xml file located at ReportEngineInstallDir\ReportEngine\bin\reportsCL.
Note
If you create the backup file in the same directory, ensure the backup file does not have the .xml extension. Create the back up outside the BMC_PROACTIVENET_REPORTENGINE_HOME directory.
- Using a text editor, open database_config.xml, and search for the <url> tag.
Update the following value with the URL that you created.
jdbc:oracle:thin:@hostName:1521:instanceName
- Save and close the file.
Start the TrueSight Operations Management Report Engine service. For details, see Stopping and starting the Report Engine Service.
Comments
Log in or register to comment.