Hi Eduard,
No, I can't access cache studio, I'm connecting via ODBC.
No that field is not available.
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 > 10000
24/08/2016 4:17:46 p.m. > Queue '10018:' added
24/08/2016 4:17:46 p.m. > Queue '10017:' added
24/08/2016 4:17:46 p.m. > Queue '10021:' added
24/08/2016 4:17:46 p.m. > Queue '10142:' added
24/08/2016 4:17:46 p.m. > Queue '10198:' added
24/08/2016 4:17:46 p.m. > Queue '10071:' added
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 :-)