Script Error

[master_student]

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

[PrashantSangle]

Can you try with removing + symbol

also try with writing SQL before Select statment

like

SQL select *

from table;

Regards,

[master_student]

same error

[PrashantSangle]

try with simple select query

Regards,

[master_student]

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

[PrashantSangle]

can you post complete error message.

Also try with simple select query.

like

select * from tableName;

Regards,

Prashant Sangle

[Anil_Babu_Samineni]

May be this?

SQL Select .....;

Disconnect;

[neha_shirsath]

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.

[Anonymous]

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

[sasiparupudi1]

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