{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.

Search FAQs

Step by step procedure for fixing a failed WebReporter install running on Windows XP with SQL Server 2005 Express edition

Goals and Symptoms

A typical scenario for a failed WebReporter installation involves a Windows XP operating system with SQL Server 2005 Express edition. TO accurately diagnose what the exact problem may be you should refer to the diagnostic information in the SystemLog or examine the specific errors noted in the EventExceptions table in the ION_SystemLog database. The may have been some failure as some unknown point that is causing WebReporter to fail. A single problem may have resulting in some cascading configuration problems.

Facts and Changes

Internal only: The procedure/process outlined in this document is intended to assist Schneider Electric employees in assisting with the troubleshooting of ION Enterprise installations. It is not intended to be shared directly with customers. Only portions of this document can be shared with customers.

Causes and Fixes

The tasks below are step by step by procedures that MUST be followed in the exact order to correct the most common issues.
Make sure that any antivirus program currently running has been disabled and that the use logged is has administrative rights to the computer

=-=-=-=-=-=-=-=-=-=

Open IIS(Internet Information Services)

Delete the Reporting Services Virtual Roots (Note: there should normally only be 2. If virtual roots like Report$ION/ReportServer$ION, and ReportsION/ReportServerION exist this may cause a conflict. Delete all as these will be recreated by a utility in the following steps.

=-=-=-=-=-=-=-=-=-=

Stop the SQL Server Reporting Services service

Open the SQL Server Management Studio interface and delete the 2 Reporting Services databases.


  • · ReportServer$ION

    · ReportServer$IONTempDB


If you see other reporting services databases such as:

  • · ReportServer

    · ReportServerTempDB


Delete these databases too

=-=-=-=-=-=-=-=-=-=

Check if RPT tables populated in ION_Network DB

If yes run the following query to remove items from this database.

Use ION_Network

Delete from RPT_ReportPack

Delete from RPT_ReportTemplateReportMap

Delete from RPT_ReportTemplate

Delete from RPT_Report

Close the SQL Server Mangement Studio interface.

=-=-=-=-=-=-=-=-=-=

Re-install /re-configure ASP.net by and restart IIS by running the following command via the DOS command prompt. The ga switch grants the user accounts mentioned below access tot eh IIS metabase table. Note: account names may vary per language and region of the OS. Example LOCAL , for Local System account, is LOKAAL in the Netherlands.

To run open the command prompt and change directory to C:\Windows\Microsoft.net\Framework\V2.0.50727 Then run the following commands:


  • - aspnet_regiis.exe i

    - aspnet_regiis.exe ga ASPNET

    - aspnet_regiis.exe ga LOCAL

    - iisreset.exe


=-=-=-=-=-=-=-=-=-=

Run the following utility …\ION Enterprise\system\bin\ RSConfigurationwizard.exe in FORCE mode.

Specify the following:

ReportServerION as the Reporter Server Virtual Directory

ReportsION as the Reporter Manager Virtual Directory

ReportServerION as the Reporter Server DB

=-=-=-=-=-=-=-=-=-=

Configure the SQL Server Reporting Services (Computer Management > Services > Right click on the service) service account to run under the Local System account. It may have been set to run under the Network Service account. This particular account may not have sufficient permission's on the system.

=-=-=-=-=-=-=-=-=-=

Go to Add/Remove Programs, select ION Enterprise, and run then Modify maintenance task.

=-=-=-=-=-=-=-=-=-=

Open the SQL Server Management Studio interface. Expand Database/ION_Network, and open the CFG_ItemValue table. Verify that the server names and report server name values are correct for items IDs 6, 34, 35, 37.

If …\ReportServer$ION is present yet the correct name is …\ReportServerION this may prevent WebReporter for opening correctly.

=-=-=-=-=-=-=-=-=-=

This step is specific to Windows XP with SQL Server Express. Open the Reporting Services web console:


  • - http://localhost/reportsION or http://localhost/reports$ION

    - Open ION Reports, the open the data source IONReportDataSource

    - In the connection String enter in the following information and replace <computer name>with the actual name of the server:

    Data Source=<computer name>\ION; Initial Catalog=ION_Network,;User Id=ION; Password=exw1BStL@mzokMLd4uiXLouELu#l037YUD

    - Set Connection Type: Microsoft SQL Server


You may need to re-run the Modify maintenance task again after do just for good measure. Again make sure all entries in the CFG_ItemValue table are correct after.

=-=-=-=-=-=-=-=-=-=

Report Packs should now be installed and WebReporter should be up and running. If they are not installed try to Install report packs manually:

Open the command prompt and change the directory to C:\Program Files\Schneider Electric\ION Enterprise\System\Bin

Then type: ReportPackUtil.exe -root [path] -install [pack]

By default [path] = "C:\program files\Schneider Electric\ION Enterprise\Web"

By default [pack] = "Default Reports 6.0"

If install paths are default the command would look as follows after the initial directory change:

ReportPackUtil.exe -root "C:\Program Files\Schneider Electric\ION Enterprise\Web" -install "Default Reports 6.0"


Legacy KB System (APS) Data: RESL203518 V3.0, Originally authored by DaMi on 09/23/2010, Last Edited by MaTh on 09/26/2012
Related ranges: OS & related Third Party Products for Power Mangement Systems, ION Enterprise V6.0

Schneider Electric Canada

Explore more
Range:
ION Setup
Explore more
Range:
ION Setup
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.