.Net DataProvider for SAP Timeout

I am using the .Net DataProvider for SAP.

When importing data I receive an error, when calling sap functions via exec.

The errors vary (e.g. Error 0xc0047062: Data Flow Task: Microsoft.Adapter.SAP.SAPManagedProviderException: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.)

On the sap-side the function runs, but it takes a few minutes.

I can ask the sap-bw team to speed up their performance, but this is political.

The sql-timeout parameter is not working with this datareader.

Have you any proposal that solves the problem.

Thanks

this is just a hunch: try using a smaller value for the DefaultBufferMaxRows property of data flow task.|||

This has no effect.

On my opion none of the properties has any effect.

But thanks for your answer.

|||

Hello Groth,

you may also have a look at this tool: www.xtract-is.com

It works definitly faster than the .NET SAP Provider and there is no need to install any addtional components in SAP.

./. Krishtan

|||

I'm tested the whole week and found out:

The timeouts in the .Net DataProvider for SAP occurs, if the function called on sap-side runs for more than 120 seconds.

Whon knows to whom I can address this problem on the side of MS?

Thanks

|||

GROTH wrote:

I'm tested the whole week and found out:

The timeouts in the .Net DataProvider for SAP occurs, if the function called on sap-side runs for more than 120 seconds.

Whon knows to whom I can address this problem on the side of MS?

Thanks

are you using the ado.net connection manager? if so, did you try changing the connect timeout property?