New post
User bio
404 bio not found
Member since Sep 15, 2016
Posts:
show all 1
Replies:
show all 3
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 :-)

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.

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 > 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

Followers:
Neeraj has no followers yet.
Following:
Neeraj has not followed anybody yet.
Global Masters badges:
Neeraj has no Global Masters badges yet.