Table update is causing front end SQL statement to fail
Turned on sql profiler and learned there was a sequence table that is used to determine the next primary key id. Updated this table and deleted the cache. Performed a restart on the server and the problem was solved. In short it was primary key violation. 

Thanks for the sql trace idea that led to sql profiler.