Echec de lecture OLEDB

[master_student]

Hello Guys,

I need your help I get this error : ECHEC de lecture OLEDB :

here's my script :

test :

LOAD

*,

if( match( date( Today(), 'M/D/YYYY'),  date( [ROW_LASTMANT_DTTM] , 'M/D/YYYY') )  , 0 ,

              (NetWorkDays([ROW_ADDED_DTTM],   Today()-1, $(vHol)))

              ) as  "AGE_INSTANCE",

mid(date("ROW_LASTMANT_DTTM",'DD/MM/YYYY HH24:mm:ss'),12,2) as "TRANCHE_HORAIRE",

Date("ROW_LASTMANT_DTTM",'DD/MM/YYYY') as "Date Dern. modif.",

    day("ROW_LASTMANT_DTTM") as Jour_last,

    Month("ROW_LASTMANT_DTTM") as Mois_last,

    "ROW_ADDED_DTTM" as "Date création",

     "ROW_LASTMANT_DTTM"

;

SELECT

A.CASE_ID as "Code Cas",

GRP.PROVIDER_GRP_ID as "PROVIDER_GRP_ID",

GRP.NAME1 ,

B."BUSINESS_UNIT",

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 ,

B.ROW_ADDED_DTTM ,

C.RC_DESCR_SS as "Criticité cas "

FROM sysadxxxxA_PRV_GRP A,

....

[Anil_Babu_Samineni]

What are you getting when you reload with out this line AGE_INSTANCE

Note - In your SELECT statement there is an aggregation function but end part there is no Group By ...