go to post Neeraj Mehta · Sep 16, 2016 Hi Dmitry, Thanks for pointing that out, I'm not sure how it happened but the tablename in the query must have got changed somehow.I changed the query back to the query from the log files when it was working and it executes now. Thanks a lot for your help :-)
go to post Neeraj Mehta · Sep 16, 2016 Hi Eduard,No, I can't access cache studio, I'm connecting via ODBC.No that field is not available.
go to post Neeraj Mehta · Sep 15, 2016 Hi Eduard,Thanks for your reply.This query was developed by an ex employee and it was working perfectly till now.My doubt is that if the table doesn't contains the specific field how was it working earlier?I can remove ApplicationID from the query but was under the impression that it would stop the query from working.Below is the output from log files when the query was functional.24/08/2016 4:17:39 p.m. > select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iSkillsetStat where ApplicationID > 1000024/08/2016 4:17:46 p.m. > Queue '10018:' added24/08/2016 4:17:46 p.m. > Queue '10017:' added24/08/2016 4:17:46 p.m. > Queue '10021:' added24/08/2016 4:17:46 p.m. > Queue '10142:' added24/08/2016 4:17:46 p.m. > Queue '10198:' added24/08/2016 4:17:46 p.m. > Queue '10071:' added