We have been evaluating the demo, and are now having problems getting the FactorySQL service running. The Kepware demo is working and reading PLC values that we are trying to bring into FactorySQL and log to an Oracle database. Initially, we had problems getting FactorySQL to create a table in Oracle with the “store time/date stamp” and “store opc quality code”. Automatically create table was selected. It asked if it should add the columns, and when we said yes, it threw an invalid alter table option. We manually added the t_stamp and quality_code columns, and it then worked correctly. This issue sometimes happens, sometimes doesn’t. We aren’t sure exactly what causes this yet.
Anyway, once we created the columns by hand in Oracle, we used FactorySQL to log to the table using a block group. We wanted to add another column for OPC time stamp (to see if it differed from the Oracle time stamp; we want to update on every execution, not just on changes to the value), so we added the block data item for timestamp to the group. After starting to the block group back up, FSQL did create the extra column in Oracle and started logging. The service then failed and will not get back up and running. We have tried killing the FSQL tray program, rebooting, using different ports, etc, and the service will not start. In the Windows Services program, if we start the service, it will stop itself after a minute or so. Here is the error message from Windows Event Log (System): “The FactorySQL service terminated unexpectedly. It has done this n time(s).”
If we open the FactorySQL Connection Settings and test the connection, we see “Unable to Connect! Error Verifying Connection: No connection could be made because the target machine actively refused it 127.0.0.1:5505”
I’m guessing we may have seriously offended the FactorySQL service to where it won’t initialize to a point where anything can connect to it. I’m not sure if it has to do with the other intermittent Oracle issues we had been seeing, but obviously we’d like to know what has happened and how to recover from it. If you need any further details please let me know.