Hi,
Just thought I would bring this to your attention if your interested.
We have an Intouch system logging Alarm data to an SQL Laarm Database on a seperate Server.
we noticed recently that the last 3 months data was missing. the pc was restarted and the machine started loggin again. Luckily we also had INSQL configured which was acting as a continous historian, so we were able to query all alarms over the period.
I noticed that this had happened a few times in the past so I tried to identify the problem. I narrowed it down to the fact that the link was severed every time a particuler operator was logged in.
The particuler operators name was eg. " John O'Connor". This turned out to be very important.
In our system, everytime an alarm occurs the operator is required to enter his username ie. "oconnorj", password and a comment.
This username is then cross referenced with Active Directory and the operators Display Name as it appears in the Active Directory configuration is added to the Comment Table in the Alarm database.
No comments were ever recieved for this operator.
CAUSE:
Everytime this operator tried to log a comment to the database, Intouch was attempting to add his display name( John o'Connor) to a field in the comment Table. This field could not take an APOSTROPHE and Loggin failed immediatly.
Solution:
We have had to fire anybody who has an apostrophe in their name.
Anyway, anybody know how to put a watchdog alarm between INTOUCH node and SQL.
Just thought I would bring this to your attention if your interested.
We have an Intouch system logging Alarm data to an SQL Laarm Database on a seperate Server.
we noticed recently that the last 3 months data was missing. the pc was restarted and the machine started loggin again. Luckily we also had INSQL configured which was acting as a continous historian, so we were able to query all alarms over the period.
I noticed that this had happened a few times in the past so I tried to identify the problem. I narrowed it down to the fact that the link was severed every time a particuler operator was logged in.
The particuler operators name was eg. " John O'Connor". This turned out to be very important.
In our system, everytime an alarm occurs the operator is required to enter his username ie. "oconnorj", password and a comment.
This username is then cross referenced with Active Directory and the operators Display Name as it appears in the Active Directory configuration is added to the Comment Table in the Alarm database.
No comments were ever recieved for this operator.
CAUSE:
Everytime this operator tried to log a comment to the database, Intouch was attempting to add his display name( John o'Connor) to a field in the comment Table. This field could not take an APOSTROPHE and Loggin failed immediatly.
Solution:
We have had to fire anybody who has an apostrophe in their name.
Anyway, anybody know how to put a watchdog alarm between INTOUCH node and SQL.