Where can we find the actual error which is causing the query to fail. The brief information provided in the transformation is not enough. Most of the times it simply says syntax error.
