Technical FAQs

Ask a Question

StruxureWare Power Monitoring 7.0 and 7.0.1: In Vista, the query wizard fails to edit the Data Log Viewer with the following error: 'Invalid escape clause - handle and node not separated by '@' '

Issue
In Vista, the query wizard fails to edit the Data Log Viewer with the following error:

Semantic error:
Invalid escape clause - handle & node not separated by '@' :


 

Environment

ION Enterprise systems which have been upgraded to SPM that contain custom diagrams/custom datalog viewers.


Cause

In SPM 7, there was a localization-related problem that required a space be added to Vista diagram SQL queries, i.e. instead of

SELECT timestamp
, "kWh net"

FROM --(*vendor(PML),product(LogServer) EgyDmd Log@EDS_SERVER.cell_31A *)--

as it would be in 6.0, in 7.0 the from clause is now:


FROM --(*vendor(PML),product(LogServer) EgyDmd Log @EDS_SERVER.cell_31A *)--

(note the new space in front of the @)

 

If an older system with custom diagrams and custom datalog viewers is upgraded to SPM 7.0 or 7.0.1 then all of these data log viewers will display problems in Vista and WebReach because of the lack of a space before @.
 

Resolution

Add the space in front of the last @ symbol.

Note: If the system has several custom diagrams please use a free global search/replace text editor that can search subfolder and support regular expressions in its searches because regular expressions can search for very specific patterns.

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