Hi, I have a redundant FactorySQL system, both communication with Local Rockwell’s RSOPC Gateway. Some groups are trigger based, while other are interval based i.e. every 1 sec, 5 sec etc.
Similarly some are directly bound to tables, while some are bound to stored procedures.
After some time, The group status for all my trasnaction groups Show Execution:0, Erros:0, L:ast Attempted and successful execution as 1/1/0001 12:00:00 AM. No Errors are displayed, the scheduled groups without trigger keep on working but some trigger based groups set to async change stop working. Stopping and Starting the group fixes the issue, so I do not understand what the problem could be.
I am using SQL Server 2000 Enterprise Edition DB. Execution of Stored Procedures is fast enough and I know group executions are not being queued.