ODI Data Load to Essbase ASO is Hung & Throwing "Network Error 1042017" in Essbase (Doc ID 1581778.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion Essbase - Version 9.3.1.0.00 and later
Information in this document applies to any platform.
***Feb 6,2015**

Symptoms

When loading data to Essbase via ODI, the load fails and the following error is seen in the Essbase application log:

Essbase error 1042017: Network error: The client or server timed out waiting to receive data using TCP/IP. Check network connections. Increase the NetRetryCount and/or NetDelay values in the ESSBASE.CFG file. Update this file on both client and server. Restart the client and try again.

 If error logging is enabled for the ODI IKM SQL to Hyperion Essbase (DATA) (as per note 1088139.1) then the error log should contain a similar error that has been returned from Essbase.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms