Multiple node query works in ION Enterprise Vista but not in Webreach.



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

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