Sporadic Connectivity Issues Via SQL Load Rule (Error 1042013)
Last updated on NOVEMBER 28, 2017
Applies to:Hyperion Essbase - Version 18.104.22.168.017 to 22.214.171.124.020 [Release 11.1]
Information in this document applies to any platform.
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 : Failed to receive data.
ERROR - 1042012 - Network error : 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.
Applied the Essbase 126.96.36.199.017 patch set update.
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