I put a TABLEUPDATE before the SUM but still get the error.

I also tried optimistic buffering on the table, but it did not help. When I removed buffering from the table I got no error. If I am using a view to update the table, do I need to have the table bufffered?