Echec de lecture OLEDB

master_student — Tue, 26 Sep 2017 07:46:50 GMT

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,

....

Re: Echec de lecture OLEDB

Anil_Babu_Samineni — Tue, 26 Sep 2017 07:52:46 GMT

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