Publisher (TimeoutFetch)

[tmumaw]

I am receiving the following error while extracting data from SAP's BSEG table "Fetch aborted, since no data has been received during 1201 s. Try increasing the value of 'TimeoutFetch' may solve the problem." Is this an OS setting or a setting within Qlikview?

Thanks
Thom

[#2]

Hello Guys,

Same Problem here.. Does anyone has an Idea?? Thanks in advance..

@Thom Mumaw

Did you solve the Problem??

[#3]

Hello

TimeOutFetch is a property you can set in your connection string.

Default value (before 5.3) was 600 seconds, since 5.3 (i'm not hundred pct sure ) it is 1200 Seconds

The TimeOutFetch is the number of seconds the connector will wait before raising an error (which is the case).

Either you improve your query to limit the time it takes (which is I think the best solution).

Or you increase the TimeOutFetch property in your connection string (add for example ;TimeOutFetch=1300 in your connection string).

I hope this will help you.

Rgds,

Sébastien

[#4]

Spastor, Thanks for your answer..How can you limprove your query to limit the time it takes? What do you mean by that?

What does Sleep do? do u mean that??

Thanks once more in advance

Sravan

[#5]

By improving I mean, using indexes in the SQL statement, doing incremental loading, limit the number of fields you retrieve in the query, etc..

I didn't mention Sleep at all, and it has no relation with the query improvment.

Rgds,

Sébastien