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 TrueSight Server Automation - Data Warehouse console, ensure that these prerequisites are met.

Important: Applicable only for TrueSight Server Automation - Data Warehouse version 8.9.04.002

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. Launch the TrueSight Server Automation - Data Warehouse console.

    Perform the following steps to access the console:
    1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
      https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
    2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
      Default user name: DWAdmin
      By default, the password is hidden. To view the password, click ViewPassword.png.
    3. In Site, select a site. The Primary Site is the default site.
    4. In Authentication Method, select a authentication method. SRP is the default authentication method.
    5. Click LOG IN.
  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.

    Click Reset to revert to the previous settings.

    The Configure Archival Settings page enables you to configure the following parameters to run the archival process. 

    Field definitions

    Field

    Description

    Archive Directory Location

    Directory on the Database Server hosting the Reports Data Warehouse Database where you want to store the archived data.

    The archive directory location must exist on a local drive.

    Domain name

    Domain for which you want to archive data

    Retention Period (Months)

    Number of months for which you want to retain data for a domain

    Notes:

    • The retention period for the JOB ACTIVITY domain must be the maximum. All other domains can have their retention period equal to or smaller than this domain.
    • You must consider the space available in the secondary storage location while setting the retention periods for the domains. For example, if you want to retain data only for a short period, such as 3 months, you must ensure that the secondary storage location has adequate space to store the archived files.

    The settings saved on this page are also used by the archival job when you run that job from TrueSight Server Automation. For more details, see Archiving-data-by-using-TrueSight-Server-Automation-jobs.

  4. Click Save
  5. On the Archival Settings page, verify the settings. 

    The Archival Settings page shows the archival settings that you configured on the Configure Archival Settings page. Also, this page provides the following links:

    Link definition

    Link

    Description

    Run Archive Now

    Enables you to run the archival process immediately

    To schedule an archival process, see running archival using TrueSight Server Automation jobs.

    Change Retention Period

    Enables you to change the retention period and archive directory location

    Run Restore

    Enables you to configure restore settings, such as the domain name and its restore period

    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 the status of the archival job using the TrueSight Server Automation - Data Warehouse console, as described in Viewing-the-status-of-an-archival-job.

Note

When you run the archival process by using the console, the messages are written to the <TSSA-DWInstallationDirectory>/logs/bds-ui.log file. When you run the archival process by using a TrueSight Server Automation job, the messages are written to the <TSSA-DWInstallationDirectory>/logs/archival.log file.

Related topics

Archiving-data-by-using-TrueSight-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*