You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old May 16th, 2018, 05:25 AM   #1
Jezz
Member
United Kingdom

Jezz is offline
 
Jezz's Avatar
 
Join Date: Dec 2002
Location: Kendal
Posts: 389
Wonderware Historian

HI All,
I've got a problem with a couple of devices communicating to our historian server where the coms is lost (normally someone switching something off or just a random coms issue) what I'm wanting to do is set up an even tag to email me when we lose coms on a I/O server topic , the email is set up and working, I'm just struggling to fine the best way to trigger that an I/O server has failed any suggestions welcome ?

Thanks in advance
__________________
Jezz
Eagles may soar but Weasels don't get sucked in to jet engines....
  Reply With Quote
Old May 16th, 2018, 09:10 AM   #2
Snap25
Lifetime Supporting Member
United States

Snap25 is offline
 
Join Date: Dec 2014
Location: Michigan
Posts: 225
Are you using Intouch as well?

You could monitor Intouch's connection to the DA Server with an IOStatus topic or monitor the DA server connection to a specific device with the $SYS$Status tag?
  Reply With Quote
Old May 16th, 2018, 10:21 AM   #3
Jezz
Member
United Kingdom

Jezz is offline
 
Jezz's Avatar
 
Join Date: Dec 2002
Location: Kendal
Posts: 389
We have InTouch but not on every topic most are daservers to specific items, so I'm looking to do it all on the server if possible.
__________________
Jezz
Eagles may soar but Weasels don't get sucked in to jet engines....
  Reply With Quote
Old May 18th, 2018, 12:05 AM   #4
Jezz
Member
United Kingdom

Jezz is offline
 
Jezz's Avatar
 
Join Date: Dec 2002
Location: Kendal
Posts: 389
Still trying to find a solution to this , any InSQL/ Historian Guru's out there?
__________________
Jezz
Eagles may soar but Weasels don't get sucked in to jet engines....
  Reply With Quote
Old May 18th, 2018, 03:18 AM   #5
lostcontrol
Member
New Zealand

lostcontrol is offline
 
lostcontrol's Avatar
 
Join Date: May 2009
Location: NeverSayNever
Posts: 761
Is the issue specific to the end device being switched off, or comma are just lost ie logging is missed..?
I can think of a couple of solutions, but does depend on what the root cause is & what platforms you are using.?

A simple option could be to the a periodic query on a tag per topic looking for a change from the last value, but that relies on a changing tag...
I often use a clock.second tick for similar
  Reply With Quote
Old May 18th, 2018, 03:29 AM   #6
Jezz
Member
United Kingdom

Jezz is offline
 
Jezz's Avatar
 
Join Date: Dec 2002
Location: Kendal
Posts: 389
We have had both an item being switched off ( or it's local network switch failing) and an I/O server hanging up in both cases we simply stopped receiving data, how would you do a periodic query on a tag changing value SQL is not my first language LOL
__________________
Jezz
Eagles may soar but Weasels don't get sucked in to jet engines....

Last edited by Jezz; May 18th, 2018 at 03:36 AM.
  Reply With Quote
Old May 18th, 2018, 04:49 AM   #7
Jezz
Member
United Kingdom

Jezz is offline
 
Jezz's Avatar
 
Join Date: Dec 2002
Location: Kendal
Posts: 389
I've tried using a Generic SQL Detector to trigger an Event tag but keep getting errors,

The code I used was:

SELECT OPCQuality
FROM runtime.dbo.DiscreteLive
WHERE TagName IN ('Work-Shop-Email-Test') AND OPCQuality = 192

and that would return a table with a value of 192 if connected and no table if disconnect, I'm not sure what the Detector is looking for when using generic SQL.
__________________
Jezz
Eagles may soar but Weasels don't get sucked in to jet engines....
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Replacement for Wonderware InTouch 9.5 Historian installation disc ryangriggs LIVE PLC Questions And Answers 3 September 6th, 2017 08:58 PM
Product Reporting with Wonderware Historian mcrawford LIVE PLC Questions And Answers 2 October 10th, 2014 08:44 AM
Wonderware Historian azlan270690 LIVE PLC Questions And Answers 0 September 27th, 2014 02:45 AM
ODBC for WonderWare Historian osipi_geek LIVE PLC Questions And Answers 2 February 21st, 2012 03:25 PM
Wonderware Historian + InTouch display issues OllieWallie LIVE PLC Questions And Answers 2 March 11th, 2011 03:15 PM


All times are GMT -5. The time now is 11:17 PM.


.