Sporadic Connectivity Issues Via SQL Load Rule (Error 1042013) (Doc ID 2284436.1)

Last updated on JULY 10, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.4.017 and later
Information in this document applies to any platform.

Symptoms

Data loads via MaxL Scripts utilizing SQL/IF Load Rules, showing sporadic connectivity issues to database where pulling data.  MaxL cycles through 7 Load Rules into Essbase cube, but will fail on one (not always the same one), with:

ERROR - 1042013 - Network error [10054]: Failed to receive data.
ERROR - 1042012 - Network error [10054]: Failed to send data.
ERROR - 1241101 - Unexpected Essbase error 1042013

Application also crashes producing an exception log (log0000x.xcp) file each time the data load fails.

 

Changes

Applied the Essbase 11.1.2.4.017 patch set update.

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