You get this error when running your application:
Unable to update the transaction record cache …
This error is generally caused by triggers in your application’s underlying database and not by your Iron Speed Designer generated application itself.
To isolate the problem, insert a record into a table using the Query Analyzer or similar tool and see if it succeeds. If it fails, then the trigger is the most likely cause.
Part VII: Troubleshooting Applications