Goals and Symptoms
Webreach functionality works for everything except multiple node queries. Webreach gives the following error:
MultipleNodeQuery
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.
Attachments
(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
Public
Original Author: MN
All content © 1992-2009 Schneider Electric
Legacy KB System (APS) Data: RESL198436 V1.0, Originally authored by MiNe on 05/06/2009, Last Edited by MiNe on 05/06/2009
Related ranges: ION Enterprise V5.5, ION Enterprise V5.6