I am getting Failure in execution start in Ignition Transaction Groups.
“Error during group execution. java.lang.Exception: Unable to add data to memory buffer, buffer full. Unable to add data to memory buffer, buffer full.”
Please help
That means you have no room in the store-and-forward system. The SQL is failing and the intended data storage activity is piling up. You need to investigate what’s wrong with the database (or your table setup for the transaction), and clear out the quarantine.
2 Likes
Thanks! Fixed it !
But is there a way where i can increase size of the memory buffer or delete old records? Because i keep getting this error every 3 hours.
I have increased the memory size buffer , cleared the local cache memory by deleting my .ignition file in my PC. Still, i find my local cache to be 100% utilized . Am i missing out something?
Note the transaction rate going into the Store and Forward system versus the transaction rate going from S&F to your database. Your database is not powerful enough to keep up. (Or something–remote comms perhaps–is slowing your DB down.)
1 Like