Hello Stefean i am facing prblem in Event list of Smart Clinet 2.2 Rev C i am not geeting any event could u plz hep
Answers
Smart Client events require an IM; so I assume you have a Smart Client Data Provider running in some IM.
The IM in turn, must be configured with an OPC message log collecting events from the 800xA Base system.
1) Check running OPC Message Log in IM
2) Check running Event service (EVT800XA) in SC DataProvider Supervision Manager in IM
3) Check that EVT800XA has connected in SC Server
"C:\Program Files\ABB Industrial IT\Operate IT\ABB Smart Client\Bin\adsstatus"
4) Check content in IM Message Log table* in IM
SQL> select count(*), max(localtime) from ops$ocshis.msg110;
COUNT(*) MAX(LOCAL
---------- ---------
100443 21-APR-16
5) Check content in SC Message Log table in IM
SQL> select count(*), max(localtime) from abbsg.sc_ae_log;
COUNT(*) MAX(LOCAL
---------- ---------
995000 21-APR-16
*) Table name in IM varies; check IM Data Access and Reports User's Guide to learn how you find the table name (or, as me do a "select table_name from all_tables where table_name like 'MSG%';" to see all tables carrying the name MSG... one of them is your IM OPC Message Log...)
Supplemental to the information provided by Stefan, I offer you the following. I have attached a procedure to validate the status of the Messages in the ABBSG Schema in Oracle against the contents of the ADVA Schema utilized by the IM in the 800xA system. Additionally, here is a procedure to find the first and last message date/timestamps of the Smart Client database.
C:\Users\800xAService>sqlplus abbsg/abbsg@localhost (log into the ABBSG schema of Oracle)
SQL*Plus: Release 11.2.0.2.0 Production on Thu Apr 21 23:16:23 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
SQL> alter session set nls_date_format = "dd-mon-yyyy hh24:mi:ss"; (make date format equal to that stored)
Session altered.
SQL> select localtime from abbsg.sc_ae_log where idx = (select max(idx) from abbsg.sc_ae_log); (find the maximum timestamp in the database)
LOCALTIME
--------------------
21-apr-2016 23:16:03
SQL> select localtime from abbsg.sc_ae_log where idx = (select min(idx) from abbsg.sc_ae_log); (find the minimum timestamp in the database)
LOCALTIME
--------------------
08-dec-2015 19:04:58
SQL>
Regards,
Geof
Add new comment