Hi everyone,
FTTM 13 on the same box as FactoryTalk View SE, logging about 40 tags off a 1756-L73 to SQL Server on the IT side every 10 seconds, scheduled transaction. Went to pull a report Monday and there's been no rows since Friday 18:40. Configuration shows running, data point connector and transaction both green.
What I did find is the transaction's cache file in the FTTM folder. It's 2 GB and growing, so it's collecting and not delivering. I stopped and started the configuration, no difference, then checked the L73 tags in the live data connector test and the values come through, and pinged the SQL box, that's fine as well. Someone suggested a reinstall and I'd rather not.
PLC side fine, database side dead, cache filling. Where do I look between the two? Is there a log in that FTTM folder that says why the delivery's failing, or am I stuck asking IT what changed on the SQL box on Friday night?
Don't reinstall.
What's the exact error in the FTTM log for the database connector, and in the SQL Server log at 18:40 Friday? One line each. Not the summary, the line with the reason.