Technical FAQs

Ask a Question

WebReach Historical Access Error on XP SP2

Goals and Symptoms

Summary
Permission Denied error when attempting to view historical data through Webreach on XP SP2 or Win 2003 Server SP1


Symptoms

This problem occurs on systems using Windows XP Service Pack 2 or 2003 Server SP1. The following error pops up when a user tries to ‘View Data’ on a Data Log Viewer through WebReach:

Error Type:

PEGQuery (0x80040C8E)

Error with provideHTML. Error with GenerateHTML. WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in GetConnectionStringFromQueryServer while attempting to access Query Server [QUERYSERVER.NITRO] with handle [327952]. The Query Server may not be running. Permission denied

Facts and Changes

Keywords
Webreach

Historical Data

XP SP2

2003 Server SP1

IIS

Permission Denied

Causes and Fixes

Cause
Due to the increased security settings applied in these service packs.
 
Resolution
There is currently no known resolution.
 
Workaround
Step 1: Setting Permissions
 
WebReach requires launch and activation privileges for the accounts used. This is performed using the Component Services applet, which can be found under Control Panel-> Administrative Tools. Once in Component Services proceed with the following steps:
 
1.       Expand ‘Component Services’ and ‘Computers’ respectively
2.       Right click on ‘My Computer’
3.       Select ‘Properties’
4.       Choose the ‘COM Security’ tab
5.       Under ‘Launch and Activation Permissions’, select ‘Edit Default’
6.       If the following accounts are not displayed, you will need to add them:
<machine name>\IUSR_<machine name>
<machine name>\IWAM_<machine name>
 

 
IF THE ACCOUNTS ARE NOT THERE:
To add these accounts, click to ‘Add…’ button shown above in the ‘Launch Permission’ window. This will lead to the following screen:
 

 
You can add the user(s) under the local host computer name as shown above.
Once you create the users, make sure that the user(s) has/have permission to at least ‘Remote Launch’ and ‘Local Activation’. Full access is advised if the user is administrator. See below:
 

 
 
 
Step 2:  Configuring Webreach
 
1.       Open Control Panel-> Windows Firewall.
2.       Select the Advanced tab
3.       Under Network Connection Settings, select Advanced Settings
Select ‘Web Server(HTTP)’ as shown below
 

 
More Information
It is possible that the workaround described above will resolve the problem with accessing historical data through WebReach when the error message is displayed such as:
 
PEGQuery error '80040c8e'
Error with provideHTML. Error with GenerateHTML. WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in GetConnectionStringFromQueryServer while attempting to access Query Server [LOGSRV.STEADFAST] with handle [327952]. The Query Server may not be running. Automation error Catastrophic failure
/ion/Historical/GetLogs.asp, line 40
 
 

Original article#11362
Last Revised: 9 July 2007
Controlled
All content © 1992-2007 Schneider Electric

Was this helpful?
What can we do to improve the information ?