topic ODBC read failed error in QlikView

ODBC read failed error

Mon, 26 Sep 2016 11:09:51 GMT

Hi all

Please help me with the following error i am getting ..

I am trying to retrieve the data from MS SQL database.

I am getting the ODBC read failed error. for the following sql query, which joins the two tables

select BB.ID_CO,COUNT(DISTINCT BB.ID_BAG) as NoOfBags,

COUNT(DISTINCT BB.ID_BOX) as NoOfBOXES,

BH.ID_CO

from [BAG_BOX_REPORT] BB

inner join [BAG_BOX_HISTORY] BH

on BB.ID_CO=BB.ID_CO

WHERE BH.ID_CO='7354741'

AND BR.ID_CO='7354741'

GROUP BY BB.ID_CO,BH.ID_CO;

below is the screenshot of the error i encounter

I am not getting any error, if i load the both tables individually without any join i am not getting any errors.

Thanks

Ganesh

Re: ODBC read failed error

Anonymous — Mon, 26 Sep 2016 11:20:33 GMT

Hi Ganesh,

Try this:

select BB.ID_CO,

COUNT(DISTINCT BB.ID_BAG) as NoOfBags,

COUNT(DISTINCT BB.ID_BOX) as NoOfBOXES,

BH.ID_CO

from [BAG_BOX_REPORT] BB join [BAG_BOX_HISTORY] BH

WHERE BH.ID_CO='7354741'

AND BR.ID_CO = BH.ID_CO

GROUP BY BB.ID_CO,BH.ID_CO;

Regards!!

Re: ODBC read failed error

Clever_Anjos — Mon, 26 Sep 2016 11:27:16 GMT

You have 2 fields with same name ID_PO.

Remove one or rename

Re: ODBC read failed error

Mon, 26 Sep 2016 11:28:33 GMT

Hi Manuel

Thanks for the reply

I a getting the following error at where , with the change you suggested

Thanks

Ganesh

Re: ODBC read failed error

Anonymous — Mon, 26 Sep 2016 11:31:25 GMT

What error do you have on MS SQL Management Tool?

Re: ODBC read failed error

Mon, 26 Sep 2016 11:43:55 GMT

Thanks Clever

I have removed the duplicate field. I thought, since i have used the alias table name on each column name, they will be treated as different fields

Thanks a lot

Re: ODBC read failed error

Mon, 26 Sep 2016 11:45:04 GMT

Thanks for quick reply and helping me Manuel

Re: ODBC read failed error

Clever_Anjos — Mon, 26 Sep 2016 11:46:24 GMT

Ganesh Vara, alias table name are not loaded into Qlik.

Select

table.fieldA

becomes fieldA

If you need the table name use this

select

table.fieldA as [table.fieldA]

Re: ODBC read failed error

Mon, 26 Sep 2016 11:50:05 GMT

Thank you...