Technical FAQs

Ask a Question

ION Enterprise Vista: Waveform Query Error in Data Viewer "'PML' is not a recognized ODBC vendor clause option."

Goals and Symptoms

The following error message appears when attempting to view the waveform log for a meter in ION Enterprise Vista:


Error Text:
Operation Incomplete
The following register information could not be retrieved.
Node Register Description
QUERYSERVER QM1 Query Register DBReg_fetch
QUERYSERVER QM1 Query Register DBReg_results
'PML' is not a recognized ODBC vendor clause option.

Causes and Fixes

An exceptionally long meter name along with a long blank space in the FROM clause of the SQL statement between the product modifier and the meter name will cause the SQL query to fail.

Note: When looking at the SQL statement it may be necessary to scroll a long way to the right to see the complete FROM statement

The statement will appear as follows:

SELECT timestamp
, cause_ion
, cause_value
, effect_ion
, effect_value
, NULL AS V1
, NULL AS V2
, NULL AS V3
, NULL AS I1
, NULL AS I2
, NULL AS I3

FROM --(*vendor(PML),product(LogServer) 0x1000@Group.Meter_Name *)--

WHERE cause_value LIKE 'Disturbance%'
OR
cause_value LIKE 'DDD Analysis Done'
OR
effect_ion LIKE 'Man Wfm Trg'

This SQL statement can be found by right clicking on the datalog viewer in Vista, clicking on the Query tab, and then clicking edit SQL as shown below. Notice it looks like nothing is after the LogServer part of the from statement where the red arrow is indicating that the rest of the statement is off to the right.



Solution:
Take out the large blank space in all FROM clauses so each FROM clause appears like this:

FROM --(*vendor(PML),product(LogServer)0x1000@Group.Meter_Name *)--

Attachments

(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/234053e76b6a0d2ac12576570052ac0a/fl_block_5/0.1AD6?OpenElement&FieldElemFormat=gif)
Date Created: October 20, 2009
Last Revised: October 22, 2009
Public
Original Author: RU
All content © 1992-2009 Schneider Electric


Legacy KB System (APS) Data: RESL200320 V1.0, Originally authored by MiNe on 10/22/2009, Last Edited by MiNe on 10/22/2009
Related ranges: ION8600, ION7550/ION7650, ION7300, ION Enterprise V5.0, ION Enterprise V6.0, ION Enterprise V5.6, ION Enterprise V5.5
Was this helpful?
What can we do to improve the information ?