I'm a SQL DBA, a customer's external content type had its database schema changed from underneath it. Using SQL Profiler we could easily determine that the query included a column that no longer existed. By refreshing and recreating the methods the problem was resolved.
However I would prefer to have the the sharepoint developer come to me with the error message to hand, where could he obtain this? which log is it stored in ?