Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience.You will not be able to leave comments.

Archiving data by using the console

This topic explains the use of console to execute the archival process for one-time run and to view the detailed status of the archival process.

Before you begin

Before you archive the reports data warehouse data by using the BMC Decision Support for Server Automation Console, ensure that the following prerequisites are met:

  • Ensure that you are using database versions supported by BMC Decision Support for Server Automation. See Oracle database requirements and SQL Server database requirements for supported database versions.
  • Back up your reports data warehouse to prevent data loss in case of failure during the archival process. For information about backing up your data warehouse, see your database documentation.
  • Ensure that you have read/write permissions in the directory in which you want to store the archived files.

  • Run extract, transform, and load (ETL) for all sites and ensure that the runs are complete. 

    Note

    Run ETL just before running the archive utility to ensure that no new ETL scripts are run.

  • (Oracle only) Ensure that the following privileges are assigned to the reports data warehouse user:

    • GRANT CREATE ANY DIRECTORY TO datawarehouseUser
    • GRANT DROP ANY DIRECTORY TO datawarehouseUser
    • GRANT EXP_FULL_DATABASE TO datawarehouseUser
    • GRANT IMP_FULL_DATABASE TO datawarehouseUser 
    • GRANT EXECUTE ON utl_file TO datawarehouseUser

    These privileges are required only during archival and restore processes for importing or exporting the warehouse database. The privileges can be revoked after the archival/restore process is completed.

  • (Microsoft SQL Server only) Assign the sysadmin role to the reports data warehouse user. You can revoke this role assignment when the archival and restore operations are complete.

  • (SQL Server 2005 and later only) If you are running the archive utility for the first time, ensure that you have enabled the xp_cmdshell server configuration option. This option enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system. By default, this option is disabled. It must be enabled to perform the delete operation on archived files. To enable the option, run the xp_configure system stored procedure on the reports data warehouse as a data warehouse user with the sysadmin role, as follows:   

    EXEC sp_configure 'show advanced options', 1

    GO


    -- To update the currently configured value for advanced options.

    RECONFIGURE

    GO


    -- To enable the feature.

    EXEC sp_configure 'xp_cmdshell', 1

    GO


    -- To update the currently configured value for this feature.

    RECONFIGURE

    GO

Note

On SQL Server 2012, the archival process fails with the following error message: Error = [Microsoft][SQL Server Native Client 11.0]Warning: BCP import with a format file will convert empty strings in delimited columns to NULL.

Workaround: This error occurs due to a limitation in SQL Server 2012. To resolve the issue, install SQL Server 2012 SP1.

To archive reports data warehouse data

  1. Log on to the BMC Decision Support for Server Automation Console, as described in Accessing-the-console.

  2. From the ETL Management menu, select Database Archive/Restore.

    Note

    The ETL Management menu appears in the user interface only if the product has been configured.

  3. On the Configure Archive Settings page, configure the archival settings.

    Notes

    The Configure Archival Settings page appears only when you run the archival process for the first time. For subsequent archival process runs, the Archival Settings page appears, on which you can change your archival settings again (see step 5).

    Click Reset to revert to the previous settings.

  4. Click Save. 

  5. On the Archival Settings page, verify the settings. 

    Note

    To change the settings, click the Change Retention Period link. The Configure Archival Settings page appears.

  6. Click the Run Archive Now link. 
  7. When you are prompted for confirmation, click Yes.
    An archival job is created that runs the archival process.  
  8. (Optional) View status information about an archival job:
    1. From the ETL Management menu, select Archival Status.
      The Archival Status Summary page displays the summarized status of the archival job.  
    2. (Optional) To view detailed status of an archival job, click the job name in the Archival Status Summary page.
      The Archival Status Details page displays the details.

Note

When you run the archival process by using the console, the messages are written to the BDSSAInstallationDirectory/logs/bds-ui.log file. When you run the archival process by using a BMC Server Automation job, the messages are written to the BDSSAInstallationDirectory/logs/archival.log file.

Related topics

Archiving-data-by-using-BMC-Server-Automation-jobs
Rerunning a failed archival or restore session
Stopping-an-archival-or-restore-process

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*