Wednesday, October 3, 2012

Essbase Error(1060001): NULL argument (%s) passed to ESSOTL function %s


Exception::Cannot verify cube outline. Essbase Error(1060001): NULL argument (%s) passed to ESSOTL function %s

If you are accessing the Esssbase from the fusion applications and when you are trying to modify the essbase  [insert ] then it gives the error
the otl is the database outline which resides in the fusion applications path
/u01/oracle/fa/config/BIShared/Essbase/essbaseserver1/app/<application_name>/db/db.otl  and it is the binary file

Error Message

Known Warning with otl close :: Cannot verify cube outline. Essbase Error(1060001): NULL argument (%s) passed to ESSOTL function %s
addTreeVersionToOutline(): known otl save exception ::  : Exception::Cannot verify cube outline. Essbase Error(1060001): NULL argument (%s) passed to ESSOTL function %s publishTreeVersions() : cube outline is opened :: otl2

publishTreeVersions() : cube outline is opened :: otl5
sortCOAMembers(): EssException: Cannot get member information. Essbase Error(1290001): Network Error [10061]: Unable To Connect To [<hostname>:10302].  The client timed out waiting to connect to the Essbase Server using TCP/IP.  Check the network connections. Also make sure that Server and Port values are correct.
sortCOAMembers(): EssException: Cannot get member information. Essbase Error(1290001): Network Error [10061]: Unable To Connect To [<hostname>:10302].  The client timed out waiting to connect to the Essbase Server using TCP/IP.  Check the network connections. Also make sure that Server and Port values are correct.
sortCOAMembers(): EssException: Cannot get member information. Essbase Error(1290001): Network Error [10061]: Unable To Connect To [<hostname>:10302].  The client timed out waiting to connect to the Essbase Server using TCP/IP.  Check the network connections. Also make sure that Server and Port values are correct.
publishTreeVersions(): Known Warning with otl close :: Cannot verify cube outline. Essbase Error(1290001): Network Error [10061]: Unable To Connect To [fahapp.oasiserp.com:10302].  The client timed out waiting to connect to the Essbase Server using TCP/IP.  

Cause of the error 

Check the network connections. Also make sure that Server and Port values are correct this error is due to the port value which is specified in the o/s check the port range 

Check the local_port_range
net.ipv4.ip_local_port_range = 9000 65500

and change the local port range to the min and max number of ports specified 
1024 to 65535

net.ipv4.ip_local_port_range = 1024  65535

bounce the BIDomain and the bi 'C' stuff and retest the issue

fastartstop script is used to start and stop  the admin server and the managed server's of the particular domain or the whole fusion applications .. 

Stopping the BI Domain 

$APPL_TOP/lcm/ad/bin/fastartstop.sh -Stop -domains <domain_name>... -username <username> -appbase $APPL_TOP 

-domains we can specify multiple domains or single domain
-username the user who owns the domain
-appbase  $APPL_TOP

starting the BI domain 

$APPL_TOP/lcm/ad/bin/fastartstop.sh -Start -domains <domain_name>... -username <username> -appbase $APPL_TOP -startAdminServer -true

The default mode is the admin server will be shutdown when we are running the fastartstop with start or stop options  so if we need to start the admin server by using the parameter -startAdminServer -true

To Bounce the 'C' stuff go to the BIInstance path and bin/opmnctl 

./opmnctl stopall
./opmntl startall
./opmnctl status -l

you can stop the individual ias component also but in this scenario we need to bounce the full opmnctl  
 



1 comment:

  1. Hitting that Essbase Error(1060001): NULL argument passed to ESSOTL function is a classic Hyperion outline headache, usually meaning a MaxL script or dimension build process attempted to pass empty metadata into a critical .otl restructuring API! However, when EPM administrators have to rapidly pull down massive Oracle Essbase server patches, bulky offline Hyperion diagnostic suites, or heavy multidimensional backup tools to fix these corrupted dimension builds, built-in browser downloads frequently timeout. To securely grab these immense enterprise performance management payloads without corrupted archives, configuring an elite 14-step IDM integration blueprint guarantees a lightning-fast, drop-free download setup on Windows 10 and 11. Thanks for sharing the exact MaxL debug logs needed to track down that missing dimension argument!

    ReplyDelete