While running a Rep task or an activity of large tables in HANA Smart Data Integration I am getting an error in WebIDE.
Error is: " internal error: Remote execution error Prefetch timed out"
The error is because of too low Prefetch value.
Please use this SQL to increase your prefetch value to 10 mins:
ALTER SYSTEM ALTER CONFIGURATION ('dpserver.ini', 'SYSTEM') SET ('framework', 'prefetchTimeout') = '6000' WITH RECONFIGURE;
You can also disable the prefetch by running this SQL:
ALTER SYSTEM ALTER CONFIGURATION ('dpserver.ini', 'SYSTEM') SET ('framework', 'usePrefetch') = 'false' WITH RECONFIGURE;
The error you are facing is due to low Prefetch value. Increasing the prefetch value to will resolve this error
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.