In Vista, the query wizard fails to edit the Data Log Viewer with the following error:
Invalid escape clause - handle & node not separated by '@' :
ION Enterprise systems which have been upgraded to SPM that contain custom diagrams/custom datalog viewers.
In SPM 7, there was a localization-related problem that required a space be added to Vista diagram SQL queries, i.e. instead of
, "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 @.
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.