earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
How to

How to


Products: WebReports
Functionalities: Basic Functionality
Product version: 1.8, 1.9
10/28/2013

Restoring the WebReports Database

You restore the WebReports database to recover reports data from backup.

Show More
action_close

The WebReports Installer is a custom installer program that performs installation, prevalidation, and configuration of WebReports components. The WebReports Installer is delivered in an installation package, and the installation package has the format SE.SBO.WebReports-x.x.xxxxx.xxxx.exe. When you run the installation package, the WebReports Installer and accompanying files are placed in /Program Files (x86)/Schneider Electric StruxureWare/Building Operation WebReports Installation by default. The WebReports Installer will automatically run to install the WebReports when you run the installation package.

Four WebReports components are installed:

  • WebReports client

  • WebReports Web services

  • Reporting Agent Windows service

  • Schneider Electric Report Pack

The installation also checks and configures the following applications:

  • ASP.NET 4.5

  • IIS version 7.0 and later

  • SQL Server 2012 or SQL Server 2008 R2

  • SQL Server Reporting Services

The illustration shows these installation components and identifies the tasks performed by the WebReports Installer.

 
action_zoom_plus_stroke WebReports installation components
Figure: WebReports installation components
WebReports Client

The WebReports client performs the following tasks:

  • Sends requests for reports

  • Administers the Reports Server

  • Provides the user interface for viewing, customizing, and managing reports

During the installation, the WebReports Installer installs the WebReports client on the computer where IIS is installed.

WebReports Service

Authenticate and GetReportNames comprise the WebReports service. Authenticate provides a way for user logons to be authenticated against the user account information stored on the Enterprise Server. GetReportNames provides a way for report names to be retrieved from the Reports database. During the installation, the WebReports Installer installs the WebReports service with the WebReports client.

Reporting Agent

The Reporting Agent is a Windows service that performs reads of historical data, such as extended trends, events, and alarms. During the installation, the WebReports Installer prompts you to enter the number of seconds that you want the Reporting Agent to perform these reads. It is recommended that you accept the default value.

For more information, see Reporting Agent .

Report Pack

The installation installs the report pack that contains the Report Definition Layout files for the default reports and Production reports. During the installation, the WebReports Installer installs the report pack in the Reporting Services database.

For more information, see Report Packs .

ASP.NET and IIS

ASP.NET is the Web application framework used to develop the WebReports Web site, Web client, and Web service. IIS provides the mechanism for accessing WebReports using a Web browser. IIS also provides the mechanism for accessing the WebReports Web site and Web service using URLs. Enabling ASP.NET and IIS is a prerequisite for installing WebReports. During the installation, the WebReports Installer verifies that the correct versions of ASP.NET and IIS are enabled on your computer.

SQL Server 2012 or SQL Server 2008 R2 SP2

SQL Server 2012 or SQL Server 2008 R2 SP2 provides the platform for the Reports database and the Reporting Services database, and must be installed as a prerequisite for installing WebReports. If you are installing WebReports with version 1.5 (or later) of Building Operation, ensure that you install SQL Server 2012 Standard (or Express with Advanced Edition) or SQL Server 2008 R2 SP2 Standard (or Express with Advanced Edition). During the installation, the WebReports Installer verifies that SQL Server is installed on the Reports server. The WebReports Installer also ensures that the correct users and permissions are defined for access to the Reports database and the Reporting Services database.

SQL Server Reporting Services and Reporting Services Database

SQL Server Reporting Services is the report generation environment for data gathered from the Reporting Services database. Both the Reporting Services component and the Reporting Services database are installed when you install SQL Server. During the WebReports installation, the WebReports Installer performs the following tasks:

  • Verifies that Reporting Services is installed on the Reports server

  • Creates the data source that identifies the location of the data

  • Adds the RDLs to the Reporting Services database

  • Synchronizes the data between the Reporting Services database and the Reports database

  • Configures Reporting Services to have access to the Reporting Services database and the WebReports Web service

Reports Database

The Reports database stores the trend, alarm, user account, and SmartStruxure server information that is used in WebReports. The data are used in conjunction with the RDLs that reside in the Reporting Services database to create your reports. During the installation, the WebReports Installer performs the following tasks:

  • Creates the Reports database on the Reports server

  • Installs the SQL .mdf and .ldf database files that comprise StruxureWareReportsDB

Note:

If you are upgrading WebReports, it is recommended that you first back up the Reports database. For more information, see Backing Up the WebReports Database .

To restore the WebReports database

  1. In Windows Server 2012, open Start screen , and then click SQL Server Management Studio .

  2. Click Connect .

     
    action_zoom_plus_stroke

  3. Expand the Databases folder.

  4. Right-click StruxureWareReportsDB and select Tasks , then select Restore , then select Database.

     
    action_zoom_plus_stroke

  5. In the Restore Database dialog box, select the database set(s) that you want to restore.

     
    action_zoom_plus_stroke

  6. Click OK .

     
    action_zoom_plus_stroke

  7. Click OK .

See Also

  • WebReports Installer and WebReports Components
  • Backing Up the WebReports Database