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  
 



No comments:

Post a Comment