topic Re: Script Error in QlikView

Script Error

master_student — Fri, 18 Aug 2017 08:06:43 GMT

Hello Guys,

I hope this finds you very well

I got this error whene I run my script in qlikview ErrorSource: OraOLEDB, ErrorMsg: ORA-00904: : invalid identifier

the query runs well on Toad

SELECT A.CASE_ID as "Code Cas",

GRP.NAME1 as "Groupe prestataires",

A.RC_STATUS,

ST.RC_SHORT_DESCR as "Statut Cas",

Glo.sla_global ,

sum( sysadm.duree_ouvrable (A.ROW_ADDED_DTTM, A.ROW_LASTMANT_DTTM)) as SLA_interm,

A.ROW_LASTMANT_DTTM as "Date de dernière modification",

B.ROW_ADDED_DTTM as "Date de commande",

C.RC_DESCR_SS as "Criticité cas "

FROM xxxx A,

xx B,

xxx C,

xxx bc,

xxxx GRP,

xxxxx ST,

(SELECT AA.CASE_ID,

sum( sysadm.duree_ouvrable (AA.ROW_ADDED_DTTM, AA.ROW_LASTMANT_DTTM)) as sla_global

FROM ffff AA

group by AA.case_id) GLO

WHERE 1=1

AND A.CASE_ID= B.CASE_ID

AND B.RC_SEVERITY = C.RC_SEVERITY

and A.CASE_ID = GLO.case_id

and B.BO_ID_Contact = BC.BO_ID

and GRP.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID

and A.RC_STATUS = ST.RC_STATUS

GROUP BY A.CASE_ID,GRP.NAME1,A.RC_STATUS, ST.RC_SHORT_DESCR,glo.sla_global, A.ROW_LASTMANT_DTTM,B.ROW_ADDED_DTTM ,C.RC_DESCR_SS

Re: Script Error

PrashantSangle — Fri, 18 Aug 2017 08:13:51 GMT

Can you try with removing + symbol

also try with writing SQL before Select statment

SQL select *

from table;

Regards,

Re: Script Error

master_student — Fri, 18 Aug 2017 08:15:05 GMT

same error

Re: Script Error

PrashantSangle — Fri, 18 Aug 2017 08:18:17 GMT

try with simple select query

Regards,

Re: Script Error

master_student — Fri, 18 Aug 2017 09:13:47 GMT

Thanks Prashant but even with adding SQL before the query I got the same error

Re: Script Error

PrashantSangle — Fri, 18 Aug 2017 09:26:43 GMT

can you post complete error message.

Also try with simple select query.

select * from tableName;

Regards,

Prashant Sangle

Re: Script Error

Anil_Babu_Samineni — Fri, 18 Aug 2017 10:45:49 GMT

May be this?

SQL Select .....;

Disconnect;

Re: Script Error

neha_shirsath — Fri, 18 Aug 2017 11:04:45 GMT

Try like this

Edit Script -> Select -> Select Table -> Select required columns -> Click OK button.

See how Qlikview generates the SQL Query. If this works then step by step add your conditions.

Hope this helps you.

Re: Script Error

Anonymous — Fri, 18 Aug 2017 13:16:38 GMT

Please use the below code and try this.

SELECT A.CASE_ID as "Code Cas",

GRP.NAME1 as "Groupe prestataires",

A.RC_STATUS,

ST.RC_SHORT_DESCR as "Statut Cas",

GLO.sla_global ,

sum( sysadm.duree_ouvrable (A.ROW_ADDED_DTTM, A.ROW_LASTMANT_DTTM)) as SLA_interm,

A.ROW_LASTMANT_DTTM as "Date de dernière modification",

B.ROW_ADDED_DTTM as "Date de commande",

C.RC_DESCR_SS as "Criticité cas "

FROM xxxx A,

xx B,

xxx C,

xxx bc,

xxxx GRP,

xxxxx ST,

(SELECT AA.CASE_ID, sum( sysadm.duree_ouvrable (AA.ROW_ADDED_DTTM, AA.ROW_LASTMANT_DTTM)) as sla_global FROM ffff AA group by AA.case_id) GLO

WHERE 1=1

AND A.CASE_ID= B.CASE_ID

AND B.RC_SEVERITY = C.RC_SEVERITY

and A.CASE_ID = GLO.case_id

and B.BO_ID_Contact = bc.BO_ID

and GRP.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID

and A.RC_STATUS = ST.RC_STATUS

GROUP BY A.CASE_ID,GRP.NAME1,A.RC_STATUS, ST.RC_SHORT_DESCR,GLO.sla_global, A.ROW_LASTMANT_DTTM,B.ROW_ADDED_DTTM ,C.RC_DESCR_SS

if not worked please correct the table alias names properly(case).

Re: Script Error

sasiparupudi1 — Sun, 20 Aug 2017 20:07:44 GMT

If you have any preceeding load happening on top of your query, please comment that and see if the query runs fine..

Qlik send any statement between SQL and ; as a text to the driver to get executed on the server and your oracle query should execute properly in Qlik just like it does in Toad