Patch 1 for Service Pack 3 (8.2.03.01)
This section contains information about fixes and updates in this patch, and provides information about downloading and installing the patch.
About Patch 1 for Service Pack 3
This patch includes a full installer for the product. You can download the patch files from the BMC Electronic Product Distribution (EPD) website at http://webapps.bmc.com/epd. The version number shown on EPD is SP3-P1.
Supported versions of BMC Server Automation
This patch supports the following versions of BMC Server Automation:
- 8.1 and all 8.1 service packs;
- 8.2, 8.2 SP1, 8.2 SP2, 8.2 SP3, 8.2 SP3 Patch 1
Updates
There are no updates in Patch 1 for Service Pack 3.
Corrected issues
The following issues have been corrected in this patch:
Tracking ID | Description |
|---|---|
QM001769665 | Out-of-the-box reports were not available for the PCIv2 templates. |
QM001769716 | The Job Activity ad hoc reports displayed data only for the Error and Warning job run events. |
QM001774227 | ETL process resulted in performance issues because of huge amount of old property data in the BSARA_DW.SERVER_PROPERTY table. |
QM001774665 | The stop_etl.nsh script was not working correctly for version 8.2 Service Pack 3. |
Enabling data loading for additional job run events
In earlier versions, in ad hoc Job Activity reports, data is loaded only for the following event types from the BMC Server Automation database to the reports data warehouse:
- Error
- Warning
Starting from version 8.2 SP3 Patch 1, you can enable data loading for additional job run events such as Info and Success along with Error and Warning.
To enable the data loading for additional job run events you must run the scripts.
Enabling data loading for additional job run event types for Oracle
- Log on to SQL Plus as BSARA_DW (or the name you choose for this user).
- If you haven't already done so, extract the scripts from the BDSSA82-servicepackVersion-external-files.zip file (see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files).
- From the command line, navigate to the BDSSA82-servicepackVersion-external-files\BDSSA\Db_Scripts\oracle\schema directory.
Run the following command:
sqlplus bsara_dw/<password>@<TNS_ENTRY>@enable_jobruneventinfo.sql
Enabling data loading for additional job run event types for Microsoft SQL Server
- If you haven't already done so, extract the scripts from the BDSSA82-servicepackVersion-external-files.zip file (see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files).
- Log on to the SQL Server database as BSARA_DW (or the name you choose for this user) using the sqlcmd utility for SQL Server 2005 and navigate to the BDSSA82-servicepackVersion-external-files\BDSSA\Db_Scripts\sqlserver\schema directory.
Run the following command:
sqlcmd -d <databaseName> -U DWUser -P <BDSSAPassword> -S <serverName> -i enable_jobruneventinfo.sql -o <logFile>where,
- <DWUser> and <BDSSAPassword> are the database user name and password.
- <databaseName> is the name of the database.
- <serverName> is the server on which the database resides.
- <logFile> is the log file to which you want to send the results of running the script.
Upgrading to the patch
To upgrade to this patch, complete the tasks described in the following topics:
Review the supported upgrade paths
Download the files
Run the patch installer