ERROR - SQL Error '[Cache ODBC][State : S1000][Native Code 29]

Question

Question

Neeraj Mehta · Sep 15, 2016

I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

Error details for the log files are below.

14/09/2016 11:20:05 a.m. > ERROR - SQL Error '[Cache ODBC][State : S1000][Native Code 29]
[C:\xlink\xlink Compiled Package\Xlink Application\Isps_Ul.exe]
[SQLCODE: <-29>:]
[Cache Error: <errdone+2^%qaqqt>]
[Details: ]
[%msg: < SQL ERROR #29: Field 'APPLICATIONID' not found in the applicable tables^select distinct ( convert ( char ( 5 ) , SkillsetID ) + :%qpar(1) + Skillset ) from iagentbySkillsetStat where ApplicationID >>]'

Thanks in advance.

Discussion (6)0

Log in or sign up to continue

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

0 0

score 1 · Answer 1 · 2016-09-15T19:12:13-04:00

How did you get this query?

You need to remove ApplicationID from the query, as that field does not exist. Maybe it was an ID field instead and got changed into ApplicationID somehow?

score 0 · Answer 2 · 2016-09-15T19:21:52-04:00

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

score 1 · Answer 3 · 2016-09-16T03:41:22-04:00

Can you access Caché studio?
Do you see ApplicationID field in iSkillsetStat (or SQLUSER.iSkillsetStat) table in any database explorer application?

score 0 · Answer 4 · 2016-09-16T09:48:25-04:00

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.

0 0

score 1 · Answer 5 · 2016-09-16T05:24:33-04:00

In your question and comment I see two tables iagentbySkillsetStat and iSkillsetStat. Are you sure that you working with right table which contains such property ?