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
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