Qlikview SQL错误

Question

当我使用SQL查询运行Qlikview时，会得到以下错误：

SQL##f - SqlState: S1000，ErrorCode: 1111，ErrorMsg: DataDirectOpenAccess SDK SQL EngineException executing : java.lang.NullPointerException 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

我正在运行的SQL查询是：

SQL //Total na tabela incident_alert

   SELECT COUNT(number) as Total
   FROM   incident_alert;

SQL //Total de incident_alert com relacionamento válido na tabela事件

   SELECT COUNT(incident_alert.number)
   FROM incident_alert
   LEFT   JOIN   incident      ON     (incident_alert.dv_source_incident=incident.number);

SQL //Registos validos na tabela incident_alert com relacao a tabela事件e com a data da passagem para massivo。

   SELECT incident_alert.number, incident.opened_at
   FROM incident_alert
   LEFT   JOIN   incident      ON     (incident_alert.dv_source_incident=incident.number)
   WHERE (incident_alert.number) NOT IN 
   (
                 SELECT DISTINCT incident_alert.number
                 FROM  incident_alert
                 INNER      JOIN   incident ON     (incident_alert.dv_source_incident=incident.number)
                 INNER         JOIN   sys_audit    ON     (incident.sys_id = sys_audit.documentkey)
                 WHERE sys_audit.fieldname = 'u_masiva' 
                 AND   sys_audit.oldvalue = 0
                 AND   sys_audit.newvalue = 1
   );

连接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
   FROM  incident_alert
   INNER      JOIN   incident ON     (incident_alert.dv_source_incident=incident.number)
   INNER        JOIN   sys_audit    ON     (incident.sys_id = sys_audit.documentkey)
   WHERE sys_audit.fieldname = 'u_masiva' 
   AND   sys_audit.oldvalue = 0
   AND   sys_audit.newvalue = 1;

我马上就会得到错误：

SQL //Registos validos na tabela incident_alert com relacao a tabela事件e com a data da passagem para massivo。

有什么帮助吗？

Answer 1

找到了答案和解决方案。我已经更新了ODBC驱动程序版本，使其生效。