Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
Webreach functionality works for everything except multiple node queries. Webreach gives the following error:
Microsoft OLE DB Provider for SQL Servererror '80040c8e'
Error with provideHTML. Error with GenerateHTML. WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in Execute: 'PML' is not a recognized ODBC vendor clause option.
/ION/Historical/GetLogs.asp, line 51
Causes and Fixes
In ION Enterprise Vista right click on the data viewer experiencing the issue with the toolbox open and go to the Query tab. Choose edit query here. After the screen where the nodes are chosen and the screen to choose the logs appears for each node as shown below.
Check the Advanced log view box shown in the red box above. Choose Finish, ok, and save the Vista diagram. Open up a new webreach screen and the problem should be resolved.
(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/d4de634171ece0f0c12575ae001099a2/fl_block_5/0.1AD6?OpenElement&FieldElemFormat=gif)
Date Created: October 29, 2008
Last Revised: May 5, 2009
Original Author: MN
All content © 1992-2009 Schneider Electric