Problem with query QvSAPConnector

[#1]

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.

[fkeuroglian]

Hi,

is a problem in the query or the connector?

if you do the select without any where condition

Select *

From COEP

works ok?

[#3]

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.

[fkeuroglian]

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

[#5]

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