sdk - Qlikview SQL error -

when run qlikview sql query getting following error:

sql##f - sqlstate: s1000, errorcode: 1111, errormsg: [datadirect][odbc openaccess sdk driver][openaccess sdk sql engine]exception executing ipexecute : java.lang.nullpointerexception oajava.service_now.condition.getvalue(condition.java:107) oajava.service_now.condition.(condition.java:35) oajava.service_now.passthrough.logicalexpression.describelogicexp(logicalexpression.java:29) oajava.service_now.passthrough.logicalexpression.(logicalexpression.java:16) oajava.service_now.passthrough.queryexpression.(queryexpression.java:41) oajava.servic sql

the sql query running is:

sql //total dos registos na tabela incident_alert

   select count(number) total      incident_alert; 

sql //total de registo na tablea de incident_alert com relacionamento válido na tabela incident

   select count(incident_alert.number)    incident_alert    left   join   incident      on     (incident_alert.dv_source_incident=incident.number); 

sql //registos validos na tabela incident_alert com relacao tabela incident e com data da passagem para massivo.

   select incident_alert.number, incident.opened_at    incident_alert    left   join   incident      on     (incident_alert.dv_source_incident=incident.number)    (incident_alert.number) not in     (                  select distinct incident_alert.number                   incident_alert                  inner      join   incident on     (incident_alert.dv_source_incident=incident.number)                  inner         join   sys_audit    on     (incident.sys_id = sys_audit.documentkey)                  sys_audit.fieldname = 'u_masiva'                   ,   sys_audit.oldvalue = 0                  ,   sys_audit.newvalue = 1    ); 

concatenate sql

select distinct incident_alert.number, incident_alert.dv_source_incident, sys_audit.sys_updated_on, sys_audit.fieldname, sys_audit.oldvalue, sys_audit.newvalue     incident_alert    inner      join   incident on     (incident_alert.dv_source_incident=incident.number)    inner        join   sys_audit    on     (incident.sys_id = sys_audit.documentkey)    sys_audit.fieldname = 'u_masiva'     ,   sys_audit.oldvalue = 0    ,   sys_audit.newvalue = 1; 

i getting error right after:

sql //registos validos na tabela incident_alert com relacao tabela incident e com data da passagem para massivo.

any help?

found answer , solution. i've updated odbc driver version newer 1 , worked.