Transaction Groups Execution Error

Ignition
1

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

Capture
Capture1598×834 145 KB

2

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.

3

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.

4

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?

Capture
Capture1323×609 33.4 KB

5

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.)