We have been making our database into a relational database. At first we had no issues with the data streaming in through LNDB. Now it seems the data is no longer being updated in the database. The .dat files are in the LNDB just not being pushed into the database anymore.
We added a column to the tables in the database so when new data come in it will be assigned a SiteID associated with that site.
Any suggestions on getting this fixed?
You should review how you have configured LNDB for what action it takes when table definitions change for a station. Sometimes the old table gets archived and new table is created. Sometimes the table is modified and continues with the new data column, leaving the previous records blank/null for that new column.
The next thing to try would be this:
1. Finish any Loggernet Network map changes (Apply in SetupScreen)
2. Stop the LNDB server
3. Restart loggernet.
4. Restart the LNDB service.
Are you using the latest version (v2.0) ? If not, you probably will want to upgrade.
If your problem is not resolved after that, you should contact your local customer support rep. The logs in C:\Campbellsci\LNDB can give hints and clues as to what might have happened.
I am using the latest version. And we did get this resolved although still not clear why this happened.
What seemed to be causing this was a station that we discontinued that I disabled in the setup but left on the network as we planned to reuse this one. It was there for almost 4 months with no issues then all of a sudden stopped everything; including all other stations.