Essbase: Validate a database against any errors with Esscmd (Part 1)

You have two options for attempting to validate an Essbase database: Esscmd and Maxl. This post is for using Esscmd.


Essbase Command Mode Interface 64-bit - Release 11.1.2 (ESB11.
Copyright (c) 1991, 2012, Oracle and/or its affiliates. All rights reserved.
U.S. Patent Number 5,359,724
U.S. Patent Number 6,317,750
Host Node >localhost
User >admin
Password >***********
[Sun Nov 24 11:47:08 2013]Local////Info(1051034)
Logging in user [admin]
Available Application Database:
TestApp ==> TestDB
localhost:::admin[1]-> select TestApp TestDB
localhost:::admin[1]-> validate
Enter error log file name >./TestDB_error.log
Validate in progress (Hit <Esc> key to cancel).........
[Sun Nov 24 11:51:04 2013]localhost/TestApp/TestDB/admin/Info(1005024)
Validate: no errors found during validation
Validate completed
sts = 0

If you had any errors, you can view your log file and correct anything listed.

Please follow and like us:

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.