Here is a question concerning Factory SQL. In our primary data collection system we are using Horner NX PLC’s which use Modbus TCP/IP as their connection to OPC. We recently purchased 10 machines which have Mitsubishi PLC units in them. They use Mitsubishi TCP/IP. Anyway Honer had been working on a handshake so that the NX could poll the Mitsubishi, more than likely thru the serial connection, to gather the data. Since MGMT did not want to wait they asked that I at least hook up to the Mitsubishi and poll some data and place it in SQL. The group I designed in FSQL contained both Mitsubishi OPC tags and Horner OPC tags. When I initially started the group it seemed to work OK. But the following day we noticed that some of the data was either a: not being populated or b: was being deleted. We are not sure which one was taking place. So my questions are as follows:
- Would using OPC tags from 2 different devices using different protocols under one group cause any problems in FSQL?
- Although there was no errors on any of the groups would this cause problems with SQL not taking all the data all the time?
- Is there a error table or something somewhere in FSQL that I could look at and it would show if there was any connection problems, write problems, or is something was commanding the data to be deleted?
I ask number 3 because this problem seemed to be as if someone placed a check mark in the DELETE RECORDS OLDER THAN configuration item for the groups. But yet when I went thru all 100 groups not one of the had a check mark in that configuration item. And since all of them post to the same SQL table I take it if any one of them would have the check mark in that config box that it would affect all of them. Would this be correct?
Thanks and have a great day.