topic Problem with query QvSAPConnector in QlikView

Problem with query QvSAPConnector

Wed, 17 Dec 2014 13:33:38 GMT

Hi, i'm trying to get data form SAP table with the following sentence:

Select *

From COEP

Where OBJNR IN (Select PAROB From COEP Where OBJNR = 'PR00023048')

OR OBJNR = 'PR00023048'

when i execute this SQL statement, it crushes and give me this error Custom read failed

I'm apprecieted If somebody could to help me.

Re: Problem with query QvSAPConnector

fkeuroglian — Wed, 17 Dec 2014 14:53:22 GMT

Hi,

is a problem in the query or the connector?

if you do the select without any where condition

Select *

From COEP

works ok?

Re: Problem with query QvSAPConnector

Wed, 17 Dec 2014 14:56:36 GMT

Yeah, if not include Where clause it works, the problem is that COEP table has more than 20 millions of records and takes more than 16 hours to execute completely, then i need to filter only this data.

Re: Problem with query QvSAPConnector

fkeuroglian — Wed, 17 Dec 2014 15:01:35 GMT

pherhaps could be a syntax error in the where conditon? if you take out the OR works?

Re: Problem with query QvSAPConnector

Wed, 17 Dec 2014 15:05:04 GMT

I was reading abuot it and it could be a buffering exceded problem. somebody says that including a mayor timeout fetch limit i could be resolved, but i don't find how to make it